[postgis-users] Error in dumping the database

Sandro Santilli strk at keybit.net
Fri Dec 14 02:49:51 PST 2012

On Fri, Dec 14, 2012 at 04:07:00PM +0530, tasneem dewaswala wrote:
> Hello,
> I am trying to take a backup of my database using
> pg_dump -Ft *mydatabasename* > *mydatabase*.tar;
> but it gives me an error as "syntax error at or near "pg_dump""
> i don't understand what is the problem.

You have to run it from a shell, not from the psql monitor.
Also, I'd recommend -Fc, not -Ft, for possible use with postgis_restore.pl [1]

[1] http://postgis.refractions.net/documentation/manual-1.5/ch02.html#hard_upgrade


 http://www.cartodb.com - Map, analyze and build applications with your data

                                       ~~ http://strk.keybit.net 

More information about the postgis-users mailing list