X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 87416DB7DF for ; Tue, 15 Nov 2005 00:08:23 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 52825-03 for ; Tue, 15 Nov 2005 04:07:43 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from scm.exportbank.com.ph (unknown [202.73.175.197]) by svr1.postgresql.org (Postfix) with ESMTP id 245E7DB77B for ; Tue, 15 Nov 2005 00:07:41 -0400 (AST) X-eSCM-MailFrom: Received: from EIBPOST (192.9.1.179) by scm (192.9.1.37); Tue, 15 November 2005 12:05:45 +0800 Received: by EIBPOST with Internet Mail Service (5.5.2657.72) id ; Tue, 15 Nov 2005 12:08:56 +0800 Message-ID: <227C7FFACEA9D9118BD600096BA5A7CA011E19C6@EIBPOST> From: "ITS ONT Alcazar, Jose Aguedo C" To: Tim Allen , "ITS ONT Alcazar, Jose Aguedo C" Cc: pgsql-admin@postgresql.org Subject: Re: Major Problem, need help! Can't run our website! Date: Tue, 15 Nov 2005 12:08:55 +0800 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: text/plain; charset="iso-8859-1" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[MANY_EXCLAMATIONS=0] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/169 X-Sequence-Number: 19542 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@proximity.com.au] Sent: Tuesday, November 15, 2005 11:40 AM To: ITS ONT Alcazar, Jose Aguedo C Cc: pgsql-admin@postgresql.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@proximity.com.au Proximity Pty Ltd http://www.proximity.com.au/