Re: [ADMIN] Read db files directly

2006-07-29 Thread Mingzuo Shen
Sorry I did not make it clear. I still do not see the db, tables, etc. vacuumdb, pg_dumpdball, psql, etc that requires a normal PostgreSQL do not see the db. Tried them all, many times. --- Jeff Frost <[EMAIL PROTECTED]> wrote: > So, is the working postmaster running in > /var/lib/pgsql/data? >

Re: [ADMIN] Read db files directly

2006-07-29 Thread Andy Shellam
I know exactly what you're trying to do - it's a similar thing to "attaching database files" in MS SQL 2000. You've got a set of data files for a single database from a previous PGSQL install and want to get another PGSQL to see it and use it as a normal DB so you can extract the data, right?

Re: [ADMIN] Postgres replication solutions

2006-07-29 Thread Mario Splivalo
On Fri, 2006-07-28 at 11:01 -0700, Jeff Frost wrote: > Mario, > > There's also Command Prompt's Mammoth replicator: > http://commandprompt.com/products/mammothreplicator/ I sent an email asking if they have an evaluation version of some sort... > Also, you could batch up PITR restores or even j

Re: [ADMIN] Postgres replication solutions

2006-07-29 Thread Jeff Frost
On Sat, 29 Jul 2006, Mario Splivalo wrote: PIRT restores are not working for me. I did it like this: I issued pg_start_backup, then I 'tar cvf - pg_data/ | nc destination 9876'-ed the cluster directory, when that was done i did pg_stop_backup, after that I deleted pg_xlog directory, and put new

Re: [ADMIN] Postgres replication solutions

2006-07-29 Thread Joshua D. Drake
Mario Splivalo wrote: On Fri, 2006-07-28 at 11:01 -0700, Jeff Frost wrote: Mario, There's also Command Prompt's Mammoth replicator: http://commandprompt.com/products/mammothreplicator/ I sent an email asking if they have an evaluation version of some sort... We do, but our 1.7 8.1 version