Re: [ADMIN] PITR/Online Backups? When can I delete archived WAL logs?

2005-04-02 Thread Jason DiCioccio
Tom,   Sorry.. I sent this a while ago (before my previous message).  It was just sitting in the moderation queue because I was not subscribed to the list at the time.   Please disregard it :) Regards, -JD-

Re: [ADMIN] PITR/Online Backups? When can I delete archived WAL logs?

2005-04-02 Thread Tom Lane
Jason DiCioccio <[EMAIL PROTECTED]> writes: > When I do this, and throw a recovery.conf into place, it generally > spits out errors like this on the other box if I attempt to start with > this: > cp: /usr/local/pgsql/archive/0001.history: No such file or directory > cp: /usr/local/pgsql/archiv

[ADMIN] postgres 7.2.1 pg_restore large objects

2005-04-02 Thread Dario Pudlo
Problem: Not being able to restore a database with lo. I have already read forums and doc. Probably I'm loosing something, but I just can figure. Reading forums I think I finally got the "right" way to do it. I'm running this as OS postgres which is a super user pg_dump -Ft -o -b base > base.tar 2

Re: [ADMIN] standalone version of psql.exe?

2005-04-02 Thread Cris Carampa
Cris Carampa wrote: I'm wondering if there is a packaged standalone version of psql.exe for Windows, or if there is a way to extract only psql.exe and the required DLLs from a full PostgreSQL Windows installation and copy these files on another computer. I have to send some scripts to a client w

[ADMIN] standalone version of psql.exe?

2005-04-02 Thread Cris Carampa
I'm wondering if there is a packaged standalone version of psql.exe for Windows, or if there is a way to extract only psql.exe and the required DLLs from a full PostgreSQL Windows installation and copy these files on another computer. I have to send some scripts to a client which has a PostgreS

Re: [ADMIN] �Stalled post to pgsq

2005-04-02 Thread Dr. Roger Wie�ner
Thank you for your answer, but: How can I get subscribed to the list? "Bruno Wolff III" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > On Wed, Mar 23, 2005 at 17:26:18 +0100, > "Dr. Roger Wießner" <[EMAIL PROTECTED]> wrote: >> Why occurs this message each time I post someth

[ADMIN] postgres 7.2.1 pg_restore large objects

2005-04-02 Thread Dario Pudlo
Problem: Not being able to restore a database with lo. I have already read forums and doc. Probably I'm loosing something, but I just can figure. Reading forums I though I finally got a "right" way to do it. I'm running this as OS user "postgres" which is a super user pg_dump -Ft -o -b base > ba

[ADMIN] PITR/Online Backups? When can I delete archived WAL logs?

2005-04-02 Thread Jason DiCioccio
Ok. I have been going over the documention for PITR/Online Backups, and it has me confused about a couple of things. Hopefully someone can help me. :-) First of all, here's what I'm doing: -- from psql SELECT pg_start_backup('mylabel'); -- from shell rsync --exclude $WALARCHIVEDIR $PGDATA remo

Re: [ADMIN] Disk Encryption - Postgresql vs. Oracle

2005-04-02 Thread Bruce Momjian
Christopher Browne wrote: > Martha Stewart called it a Good Thing when pgman@candle.pha.pa.us (Bruce Momj$ > > Wow, nice analysis. Should this be in our documentation somewhere? > > Suggest a suitable section and I'd be more than happy to send in a > patch adding this in. The only place I see pgc

Re: [ADMIN] Disk Encryption - Postgresql vs. Oracle

2005-04-02 Thread Christopher Browne
Martha Stewart called it a Good Thing when pgman@candle.pha.pa.us (Bruce Momjian) wrote: > Wow, nice analysis. Should this be in our documentation somewhere? Suggest a suitable section and I'd be more than happy to send in a patch adding this in. The only place I see pgcrypto referred to (which