Re: [ADMIN] Users and multiple server environment

2004-10-04 Thread Michael Long
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

Re: [ADMIN] PLEASE GOD HELP US!

2004-10-04 Thread Tsirkin Evgeny
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

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

2004-10-04 Thread Tomaž Borštnar
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] postgresql 8 in jail - LOG: could not create socket for statistics collector: Protocol not supported

2004-10-04 Thread Peter Eisentraut
Toma Bortnar 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

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

2004-10-04 Thread Marc G. Fournier
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

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

2004-10-04 Thread Lamar Owen
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 ignored.

[ADMIN] Failover Solution for Postgres

2004-10-04 Thread John Allgood
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

[ADMIN] Enabling --log-update

2004-10-04 Thread Dan Hrabarchuk
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

Re: [ADMIN] Failover Solution for Postgres

2004-10-04 Thread Gaetano Mendola
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

Re: [ADMIN] Users and multiple server environment

2004-10-04 Thread Cao Van Khanh
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] Enabling --log-update

2004-10-04 Thread Bruce Momjian
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