Re: [ADMIN] Broken pg_class table

Roger Ging <[EMAIL PROTECTED]> writes: > I accidentally wrecked the pg_class table in a database by leaving off > the where clause of an update statement when setting the reltriggers > back to the count from pg_trigger after a bulk data load. What was the *exact* update statement, and which PG v

[ADMIN] Broken pg_class table

I accidentally wrecked the pg_class table in a database by leaving off the where clause of an update statement when setting the reltriggers back to the count from pg_trigger after a bulk data load. I can no longer connect to the database, although it does start up without error. running psql

[ADMIN] Restore database

I need to test and create a procedure to restore databases. I followed the steps based on the site, but I couldn't finish succesfully. I did: 1. Put the database on Backup Mode and copy datafiles. /pg/bin/psql cresoldev -c "SELECT pg_start_backup('/pg/backup/');" tar -cvf /pg/backup/bk_

Re: [ADMIN] Fwd: PITR- timeline query

Hi , I am experimenting with PITR aspect of postgres8.0, and I needed some answers on this subject. I have following questions : 1) At time

[ADMIN] ERROR: relation "pg_user" does not exist

Hi,   I am running Postgresql 7.4.7-2PGDG on RHEL4 AS U1 on Proliant DL-360 system.  I am having problems with the pg_dump command. The error was visible on execution of the command:pg_dump: SQL command failed pg_dump: Error message from server: ERROR: relation "pg_user" does not exist

[ADMIN] required Disk Space

I w'd like how the DB growth impacts the actual disk space. For example, I have a table with one textfield, char(20) and I insert 100 records. My DB size w'd be approximately, 20+28(Overhead)=48*100=48MB. What is the actual effect on the physical HDD. I w'd appreciate your help. Thanks, Uma

[ADMIN] How to implement Snap shots and Meterialized views in Postgres

Hai, i am femiliar with Oracle9i and Pl/Sql. Sufficient knowledge in Postgres... Now we are using Postgres8.1 according to client requirement in my Project. Now, I want to implement Meterilized views and snapshots concepts in my project . How to implent this one..   _

[ADMIN] How to get rid of UTF-8

Dear All ,I am reciving unicode text in one of the table field this actually breaks my frontend. I want to create a trigger which will actually detect a unicode character in the field and change/filter it out. How to go about this ?-- Regards,Vishal Kashyap.http://vishal.net.in

Re: [ADMIN] Recycle error logs

Hi, On Sat, 2006-07-15 at 19:37 +1200, adey wrote: > Please advise if there is a way to start a fresh Postgresql error / > output log at regular intervals? PostgreSQL 8.0.0 and above has a built-in log rotation mechanism. Check postgresql.conf for this. See the section "Error reporting and loggin

[ADMIN] Recycle error logs

Please advise if there is a way to start a fresh Postgresql error / output log at regular intervals? We are tuning a "new toproduction" system, so I have all the SQL logged, but the file gets too big and cumbersome, so I'd like to start a new one each morning without restarting Postgres.