I am trying to execute pg_basebackup command to take base backup but I do not see a success statement when I execute the command. Is there anything else where I went wrong?
pg_basebackup -h127.0.0.1 -U owner -D backup -Ft -z -P
Asked
Active
Viewed 795 times
0
Sanoob
- 2,466
- 4
- 30
- 38
-
Can you please bring the error message ? – Houari Feb 06 '14 at 21:12
-
Are you trying to run the command on a regular command prompt, or are you trying to run it using a connection to the PostgreSQL server with (e.g.) `psql`? – Craig Ringer Feb 07 '14 at 02:20
-
I am trying to run the command on SQL shell (psql) – user3277224 Feb 07 '14 at 15:30
-
Syntax error at or near "pg_basebackup" – user3277224 Feb 07 '14 at 15:48
-
1pg_basebackup is a program, not an SQL command. You run it from the system shell, not from inside psql. – jjanes Feb 07 '14 at 19:10