[ADMIN] using disable-triggers in pg_dump

Hi- One of our processes requires merging data from a staging database into a production database. I'd like to do this without taking the production database off-line, but I'm running into a problem with triggers. One of the tables is populated and maintained solely by triggers set up on three ot

[ADMIN] PG version for n_distinct question.

Oops- forgot to give the version on that last question: I'm running version 7.3.2 on a Debian Linux platform. -NF - Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.965.7363 Fax 1.765.962.9788 doxpop - Court records at your

[ADMIN] Error message using pg_dump with tar format

Hi- I'm getting the following error message: pg_dump: [tar archiver] could not write to tar member (wrote 39, attempted 166) Here are the particulars: -I'm running this command: "pg_dump -Ft prod | prod.dump.tar" (The database is named prod) -The dump gets about 1/4 of the way through, and the

[ADMIN] Problem with tcp/ip connection, postgresql.conf

Hi- I'm posting this summary for a person that I've been corresponding with off-list: He is trying to use JDBC, so he wants to turn on the TCP/IP socket. The platform is Postgresql 7.2 on SuSe 8.0 If he starts the postmaster with the -i flag, he can get a connection. If he sets tcpip_socket =