Re: [ADMIN] Failover Solution for Postgres

John Allgood wrote: > I am looking for information on postgres failover solutions. Set up two machines with shared storage and have the machine monitor each other with heartbeat. If you don't want to invest in shared storage hardware, set up DRBD to replicate the file system between the tw

Re: [ADMIN] Enabling --log-update

No idea what that is but I have never heard of those flags. My guess is that is a hacked version of PostgreSQL. --- Dan Hrabarchuk wrote: > I need to track changes to my database while I'm doing a pg_dump. > > I've found a

Re: [ADMIN] Users and multiple server environment

Try : ./psql -d template1 -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Monday, October 04, 2004 5:25 AM To: Michael Long Cc: [EMAIL PROTECTED] Subject: Re: [ADMIN] Users and multiple server environment Michael Long <[EMAIL PROTECTED]> writes: > ./psql template1

Re: [ADMIN] Failover Solution for Postgres

John Allgood wrote: Hello All I am looking for information on postgres failover solutions. I have researched Dbmirror, DBcluster, and GFS along with others. This server is running rh-postgresql-7.3.6 and Redhat ES 3.0 and I am trying to get an idea of what is stable and reliable. What are peo

[ADMIN] Enabling --log-update

I need to track changes to my database while I'm doing a pg_dump. I've found a reference to do this http://www.arkeia.com/hotbackup/postgresql/ (see the second method). It states that I need to put my database in the "mode --log-update" I've tried to do this, but I keep getting an error saying t

[ADMIN] Failover Solution for Postgres

Hello All I am looking for information on postgres failover solutions. I have researched Dbmirror, DBcluster, and GFS along with others. This server is running rh-postgresql-7.3.6 and Redhat ES 3.0 and I am trying to get an idea of what is stable and reliable. What are people on this list ru

Re: [ADMIN] fedora core 2 postgresql regression tests fail

On Thursday 30 September 2004 00:07, John McBride wrote: > As user postgres I try and run the tests: > $ pwd > /usr/lib/pgsql/test/regress > $ time ./pg_regress.sh --schedule=parallel_schedule > > 6 of 93 tests failed, 1 of these failures ign

Re: [ADMIN] postgresql 8 in jail - LOG: could not create socket

On Mon, 4 Oct 2004, Peter Eisentraut wrote: Toma¾ Bor¹tnar wrote: Is this (subject) something to worry about or not? I am testing pgsql8beta in DragonFlyBSD jail. The statistics collector is optional, so you should get away with it. The error message refers to lack of support for datagram s

Re: [ADMIN] postgresql 8 in jail - LOG: could not create socket for statistics collector: Protocol not supported

Tomaž Borštnar wrote: > Is this (subject) something to worry about or not? I am testing > pgsql8beta in DragonFlyBSD jail. The statistics collector is optional, so you should get away with it. The error message refers to lack of support for datagram sockets; you should think about whether

[ADMIN] postgresql 8 in jail - LOG: could not create socket for statistics collector: Protocol not supported

Hello! Is this (subject) something to worry about or not? I am testing pgsql8beta in DragonFlyBSD jail. Tomaž ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [ADMIN] PLEASE GOD HELP US!

it sometimes happens that mysql is faster .obviosly you have a case when you have to try force the query to use indexes . here are some not nice and trivial solutions: [1] add another column that marks the rows that are in the upper 25 now, set up trigger to update the field .that would be VERY

Re: [ADMIN] Users and multiple server environment

Obviously not :-(. This should be pointing to /usr/local/pgsql_8.0b3/lib/ so it seems you didn't do the rpath enabling correctly; or maybe your system is configured in a way that overrides rpath (do you have LD_LIBRARY_PATH set in your environment?). Yay!! When I set LD_LIBRARY_PATH then thing