Re: [ADMIN] caching table/query

2005-07-18 Thread Tsirkin Evgeny
Well i guess that there are cases where that is not so.However i understand that postgres does not have any way accept the automatic. Tom Lane wrote: Tsirkin Evgeny [EMAIL PROTECTED] writes: What i realy want is to say to postgres that the particular table should be cached .

[ADMIN] Statement logging per connection

2005-07-18 Thread KÖPFERL Robert
Hi, is it possible to enable statement logging just for certain statements? several tries with SET xxx to yyy resulted in messages like xx can't be set now? When can it be set? I intend to use that via an jdbc connection bu had a try in pgAdmin. ---(end of

[ADMIN] unsubscribe

2005-07-18 Thread Luiz Fernando de Menezes Calabria
---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[ADMIN] backing up without lock ?

2005-07-18 Thread FM
Hello, Is it possible to backup postgresql databases without locking tables. Thanks ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [ADMIN] backing up without lock ?

2005-07-18 Thread Scott Marlowe
On Mon, 2005-07-18 at 12:25, FM wrote: Hello, Is it possible to backup postgresql databases without locking tables. Yes and no. No, it's actually possible to backup postgresql without a lock. However, it's an access shared lock, so it's not a blocking lock. Also, the backup is coherent for

Re: [ADMIN] unable to configure

2005-07-18 Thread Martin Fandel
Hi, configure it as root... Best regards, Martin Am Montag, den 18.07.2005, 12:33 -0500 schrieb Mogin Mohandas: Hey, I have the postgresql source downloaded onto a linux cluster. But when I run ./configure along with its options it says permission Denied. Is it a previlage

Re: [ADMIN] backing up without lock ?

2005-07-18 Thread Scott Marlowe
On Mon, 2005-07-18 at 12:51, Scott Marlowe wrote: On Mon, 2005-07-18 at 12:25, FM wrote: Hello, Is it possible to backup postgresql databases without locking tables. Yes and no. No, it's actually possible to backup postgresql without a lock. That should be NOT POSSIBLE (with

[ADMIN] unable to configure

2005-07-18 Thread Mogin Mohandas
Hey, I have the postgresql source downloaded onto a linux cluster. But when I run ./configure along with its options it says permission Denied. Is it a previlage problem?Please help. Thanks Moginraj ---(end of broadcast)--- TIP 6: explain