Home > mailing lists

pg_dump - Mailing list pgsql-general

From	Ramesh T
Subject	pg_dump
Date	December 17, 2014 04:03:11
Msg-id	CAK8Zd=vRia3kosKuAW-Dvt=-oh1uQZotWDUa0AwD9SahiVvaqQ@mail.gmail.com Whole thread Raw
List	pgsql-general

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...

i'm using putty to connect host

how to bash to c:\..?

From: harpagornis
Date: 17 December 2014, 03:45:41
Subject: Re: SSL Certificates in Windows 7 & Postgres 9.3

From: Ramesh T
Date: 17 December 2014, 04:03:17
Subject: Re: pg_dump