Login  Register

Re: Where is blankdatabase backup?

Posted by pedroparkero on Jan 21, 2011; 1:55am
URL: http://ngl.70.s1.nabble.com/Where-is-blankdatabase-backup-tp5929412p5946190.html

I found the answer why I can't load the plain sql database. From http://www.pgadmin.org/pgadmin3/faq/ :
pgAdmin III uses PostgreSQL's pg_restore tool, which supports only the COMRESS and TAR options of pg_dump which is used for backup creation. The PLAIN format can't be interpreted by pgAdmin III and pg_restore (it can be edited manually, and executed with psql and pgAdmin III's query tool in many cases), and thus isn't accepted as valid file. We recommend using the COMPRESS format for daily backup tasks. The PLAIN format is for advanced manual processing before executing as SQL script, and has some restrictions (no blobs) which makes it less usable for standard backup tasks.
Since I'm using version 8.3 I need the COMPRESS or TAR backup. So how can I convert the PLAIN format into COMPRESS? Is there already a file for this?
-------------------------------------------------
With great knowledge comes great responsibility.