I am using built-in SQL shell available while postgre installation and i tried with pgadmin but it gives me same error.
On Fri, Dec 14, 2012 at 4:27 PM, Sandro Santilli <[email protected]> wrote: > Maybe you're not using a unix-like shell ? > Did you give pgadmin a try ? I'm sure it can make dumps. > > --strk; > > 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 <[email protected]> > 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; > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
