How to restore

Hi,

Le 10 août 2015 7:43 AM, "Sachin Srivastava" <ssr.teleatlas@gmail.com> a
écrit :

Dear Team,

If I have taken any backup successfully through pg_dump? How can I

restore this pg_dump(Sql file) without use of pg_restore.

There is any command line option or through psql, kindly inform to me.

If it's an SQL file, you can run it through psql.

--
Guillaume

On Mon, Aug 10, 2015 at 2:41 PM, Sachin Srivastava
<ssr.teleatlas@gmail.com> wrote:

Dear Team,

If I have taken any backup successfully through pg_dump? How can I restore
this pg_dump(Sql file) without use of pg_restore.
There is any command line option or through psql, kindly inform to me.

The way to restore a backup depends on the format a dump has been taken:
http://www.postgresql.org/docs/devel/static/app-pgdump.html
Except the plain format that need psql, all the others (custom,
directory and tar) need pg_restore.
--
Michael

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Please keep the list in your answers.

Le 10 août 2015 7:51 AM, "Sachin Srivastava" <ssr.teleatlas@gmail.com> a
écrit :

Dear Guillaume,

What is the syntax of this (psql), kindy confirm.

That can be: psql -f the_file the_database

Regards,
Sachin

On Mon, Aug 10, 2015 at 11:18 AM, Guillaume Lelarge <

guillaume@lelarge.info> wrote:

Hi,

Le 10 août 2015 7:43 AM, "Sachin Srivastava" <ssr.teleatlas@gmail.com> a

écrit :

Dear Team,

If I have taken any backup successfully through pg_dump? How can I

restore this pg_dump(Sql file) without use of pg_restore.

If I have taken any backup successfully through pg_dump? How can I restore this pg_dump(Sql file) without use of pg_restore.

You can send the file to psql, the command line client:

psql yourdb < yourbackup.sql

Or:

cat yourbackup.sql | psql yourdb

Kind regards,
Andomar

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general