[postgis-users] Error in dumping the database
strk at keybit.net
Fri Dec 14 02:57:47 PST 2012
Maybe you're not using a unix-like shell ?
Did you give pgadmin a try ? I'm sure it can make dumps.
On Fri, Dec 14, 2012 at 04:24:56PM +0530, tasneem dewaswala wrote:
> 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
> > 
> > http://postgis.refractions.net/documentation/manual-1.5/ch02.html#hard_upgrade
> > --strk;
More information about the postgis-users