Re: Major Problem, need help! Can't run our website!

Can anyone help me on how to create this? I will personally do this in able
not to happen again. Or can you link me to the part of the archive that
re-creates xlog? Our internet here is soooooooooo slow.
Pleasssssssseeeeeeeee... Many thanks in advance!

-----Original Message-----
From: Tim Allen [mailto:tim(at)proximity(dot)com(dot)au]
Sent: Tuesday, November 15, 2005 11:40 AM
To: ITS ONT Alcazar, Jose Aguedo C
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Major Problem, need help! Can't run our website!

ITS ONT Alcazar, Jose Aguedo C wrote:
> Anyone!
>
> Before anything else, I have no background in PostgreSQL. But I have a
> little knowledge in Linux. We used postgreSQL to run one of our website.
It
> runs in Redhat Linux 7.3. Our System Administrator, who used to maintain
> this server, had resigned and didn't have a proper documentation on how to
> maintain this server. Right now, our NEW System Administrator is clearing
> some logs in /var/lib/pgsql/data/pg_xlog in able to free some space in the
> /var file system. It used to work before, but now, its not working
anymore.

Ouch. Tell him to stop. Though it's probably too late. The transaction
logs (ie anything you'll find in pg_xlog) are not disposable, they're an
important part of the database. Your new sysadmin has presumably
corrupted your database. So you've definitely lost any recent
transactions. What you can probably do is at least get your database up
and running again by re-creating the xlog (aka WAL) files with empty
data. Maybe someone else will post telling you how to do that, otherwise
search the mailing lists archives.

> Information below is the message we are encountering when we are trying to
> connect to the website. Please, ANYONE, help us!
>
> Warning: Unable to connect to PostgreSQL server: could not connect to
> server: Connection refused Is the server running on host localhost and
> accepting TCP/IP connections on port 5432? in
> /var/lib/phplib-7.2d/php/db_pgsql.inc on line 48
> Database error: Link-ID == false, pconnect failed
> ODBC Error: 0 ()
> Session halted.
>
> Thanks! --AGUEDO

Tim

--
-----------------------------------------------
Tim Allen tim(at)proximity(dot)com(dot)au
Proximity Pty Ltd http://www.proximity.com.au/