[postgis-users] Error in dumping the database

[tasneem dewaswala]

I tried it from the shell also, but it still gives me the same error
can you tell me proper way of working with shell, since i am not used to
work with that.

On Fri, Dec 14, 2012 at 4:19 PM, Sandro Santilli <strk at keybit.net> wrote:

> 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
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121214/ade99868/attachment.html>