[ADMIN] pg_dump segv'ing

For those who see pg_dump segv'ing, there's one obvious place to look. pg_dump uses an internal buffer to store the SQL it outputs, instead of using the buffering provided by fprintf. I don't understand that design decision (I think it's wrong). pg_dump also doesn't check if it writes past the

[ADMIN] 'C' function (spi?) for datetime UPDATE trigger - HOW?

Hi, I'm having problems with triggers that need to change datetime values. If the trigger returns OK, the datetime field will be saved correctly, but if I return [ array get NEW ] (trigger in Tcl) the datetime "gain" 2 hours. If I do an "elog NOTICE $NEW(field1)" it prints the correct valu

[ADMIN] 'C' function (spi?) for datetime UPDATE trigger - HOW?

Hi All I hope this is the right list:) I sent this in a few days ago, but got no reply, so now I have joined the list and send it again hoping to get a reply, or atleast get directed to the right list if this is not it. Need: Update a datetime field to the current time upon a record being UPDAT

Re: [ADMIN] Re: user is not in "pg_shadow"

> As we know pg_shadow , pg_database and pg_group are System catalog Table > and > they are shared to all database , unlike pg_class etc ... are local to > database > My question is > How can i define my own System catalog or a Table that is shared by all > database one like similar to pg_s

Re: [ADMIN] Backup of postgres

On Wed, 19 Aug 1998, Przemyslaw Bak wrote: > Hi all, > > I have following script to backup database: > - cut -- > #!/bin/sh > > PSQL=/usr/local/pgsql/bin/psql > DUMP=/usr/local/pgsql/bin/pg_dump > PREFIX=`date +%j` > BACKUP_DIR=/usr/local/pgsql/data/base/.BACKUP > > Databases=

[ADMIN] Backup of postgres

Hi all, I have following script to backup database: - cut -- #!/bin/sh PSQL=/usr/local/pgsql/bin/psql DUMP=/usr/local/pgsql/bin/pg_dump PREFIX=`date +%j` BACKUP_DIR=/usr/local/pgsql/data/base/.BACKUP Databases=`$PSQL -tq -d template1 -c "select datname from pg_database"` renice

Re: [ADMIN] Re: user is not in "pg_shadow"

As we know pg_shadow , pg_database and pg_group are System catalog Table and they are shared to all database , unlike pg_class etc ... are local to database My question is How can i define my own System catalog or a Table that is shared by all database one like similar to pg_shadow,pg_datab

[ADMIN] dump & restore problem

My apologies for sending this question to the list twice. Due to a glitch in our procmail configuration, I lost all mail that I should have received overnight, including any answers to this question. I have a problem with upgrading postgresql 6.1 to 6.3.2. Compilation and installation of the dat