Thursday, June 19, 2008

Re: [pgadmin-support] 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.    


--
Dan Turcitu

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

r


No comments: