[ADMIN] PG8 Timelines

2005-04-09 Thread gustavo-bartz
Please, how do I identify a id timeline on a transaction log file? Thanks. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [ADMIN] can be database files be copied using 'cp' between hosts with different endianess?

2005-04-09 Thread Vlad Harchev
On Sat, Apr 09, 2005 at 08:42:19PM +0200, Peter Eisentraut wrote: > Vlad Harchev wrote: > > I have a quesion - suppose I have sparc box and x86 box running same > > release of postgresql compiled with same options. Can I simply copy > > database directory between hosts (of course when postgresql se

Re: [ADMIN] can ALL database files reside on readonly filesystem

2005-04-09 Thread Vlad Harchev
On Sat, Apr 09, 2005 at 08:42:43PM +0200, Peter Eisentraut wrote: > Vlad Harchev wrote: > > Is it possible for ALL database files to reside on readonly > > filesystem (provided all requests made into database are selects)? > > No. OK :( Thanks for your answer! -- Best regards, -Vlad --

Re: [ADMIN] can be database files be copied using 'cp' between hosts with different endianess?

2005-04-09 Thread Peter Eisentraut
Vlad Harchev wrote: > I have a quesion - suppose I have sparc box and x86 box running same > release of postgresql compiled with same options. Can I simply copy > database directory between hosts (of course when postgresql server is > stopped on both boxes)? Absolutely not. -- Peter Eisentraut h

Re: [ADMIN] can ALL database files reside on readonly filesystem

2005-04-09 Thread Peter Eisentraut
Vlad Harchev wrote: > Is it possible for ALL database files to reside on readonly > filesystem (provided all requests made into database are selects)? No. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 1:

[ADMIN] can ALL database files reside on readonly filesystem

2005-04-09 Thread Vlad Harchev
Hello, Is it possible for ALL database files to reside on readonly filesystem (provided all requests made into database are selects)? I guess psql will have to create temporary tables for sorting and joining, will it automatically detect that all tables reside on readonly device and will place t

[ADMIN] can be database files be copied using 'cp' between hosts with different endianess?

2005-04-09 Thread Vlad Harchev
Hello, I have a quesion - suppose I have sparc box and x86 box running same release of postgresql compiled with same options. Can I simply copy database directory between hosts (of course when postgresql server is stopped on both boxes)? BTW Mysql (MyISAM) and sqlite allow this. Thanks for your

Re: [ADMIN] Automatic Backups

2005-04-09 Thread Magnus Hagander
>I am writing a program to backup Postgres 8.0 installed on windows via >Visual Basic. > >Is there an easy way to find out where a the PostgreSQL bin files are >located so I can get the pg_dump and pg_restore utilities? It's stored in the registry under HKLM\Software\PostgreSQL\Installations\\Bi