Re: Question

That's my biggest problem.
The server i have use plain format dumps , but use gz to archive them .

I could change the way backups are made but that's not my goal.

So my problem remains : how can i convert Plain format dumps to files readable by pg_restore ?



Dave Page wrote:

On Thu, Jun 19, 2008 at 8:34 AM, daniel <daniel@ascent-soft.ro> wrote: 

Is there a tool to convert  postgresql backups (sql.gz files) to Pgadmin Backups ?   

With the exception of PLAIN format dumps, they are entirely compatible
because pgAdmin just calls pg_dump to create them. PLAIN format
backups must be fed into psql however - pg_restore doesn't understand
them, and that's what pgAdmin uses for restores.
 

Dascar Daniel
Ascent Soft SRL
www.ascent-soft.ro
daniel@ascent-soft.ro

tel: +40256 40.74.00
fax: +40356 40.90.47
gsm: +40722 32.67.96