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 --strk; http://www.cartodb.com - Map, analyze and build applications with your data ~~ http://strk.keybit.net _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
