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
No comments:
Post a Comment