Re: pg_dump

On 12/16/2014 07:29 AM, Ramesh T wrote:
> hi,
> i need to export a file the database
> postgres
> pg_dump -U postgres -C -Fp -f c:/backup/db2.dump db_1;
>
> where i can run pg_dump
> please send me details
>
> i want to export db_1 to db2
> i got an error below
>
> postgres=# pg_dump -U postgres -C -Fp -f c:/backup/db_2.dump
> db_1;
> ERROR: syntax error at or near "pg_dump"
> LINE 1: pg_dump -U postgres -C -Fp -f c:/backup/db_2du...

Are you trying this from inside psql?

If so pg_dump is a command line program and needs to be from the shell
terminal not inside psql.
>
> i'm using putty to connect host
> how to bash to c:\..?

That would depend on where your Postgres server is relative to the c:\
drive.

>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com