[ADMIN] locking all databases

2003-06-23 Thread Michiel Lange
Hello everybody, I wondered if it was possible to make all databases quiet for a while (e.g. for a dump) so there are no updates in any database during that time? But all transactions get into the before image, instead of being commited, until the quiet state is ended? Thanks! Michiel --

Re: [ADMIN] How do I disconnect other users gracefully from a

2003-06-23 Thread scott.marlowe
On Mon, 23 Jun 2003, P G wrote: > What is the graceful way to disconnect other users > from a database without shutting it down? Is there a > command that I can use within psql or is it simply > "kill $PID_OF_USER" from the OS shell command line? That's how I do it, but if you're just looking to

[ADMIN] How do I disconnect other users gracefully from a database???

2003-06-23 Thread P G
What is the graceful way to disconnect other users from a database without shutting it down? Is there a command that I can use within psql or is it simply "kill $PID_OF_USER" from the OS shell command line? Thanks. __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.

Re: FW: [ADMIN] pgsql function doesn't work

2003-06-23 Thread Ian Barwick
On Monday 23 June 2003 14:25, Mel Jamero wrote: > I don't understand this. Can anybody translate? > > Thanks. I've had this one before. It's a "I'm out of the office"-type autoresponder. According to my trusty Polish-German dictionary (always have one to hand ;-) "urlopie" means "holiday". I wo

FW: [ADMIN] pgsql function doesn't work

2003-06-23 Thread Mel Jamero
I don't understand this. Can anybody translate? Thanks. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 11:51 PM To: [EMAIL PROTECTED] Subject: Re: [ADMIN] pgsql function doesn't work Witam Jestem na urlopie (nie czytam maili). Wracam

[ADMIN] About remote synchronization for postgresql

2003-06-23 Thread utomo restu
Dear All. please help me ??? i want to ask about rsync ?, my study cases is how i can implemented database postgresql on both node (i use Redhat Linux Operating System) with notice synchronization for postgresql on both node. i want to implemented HA Postgresql with Heartbeat and RSYNC. for Heart

[ADMIN] About remote synchronization for postgresql

2003-06-23 Thread utomo restu
Dear All. please help me ??? i want to ask about rsync ?, my study cases is how i can implemented database postgresql on both node (i use Redhat Linux Operating System) with notice synchronization for postgresql on both node. i want to implemented HA Postgresql with Heartbeat and RSYNC. for Heart

Re: [ADMIN] contrib/tsearch - word order

2003-06-23 Thread Oleg Bartunov
On Sun, 22 Jun 2003, Bruce Young wrote: > I am playing around with contrib/tsearch, but now i am not sure how to > implement it. > When i insert words into a txindx column, they are not in the same order after that's right. > a select. > Question is... is there a way to select text in the order