Re: How to restore

From: Andomar <andomar(at)aule(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to restore
Date: 2015-08-10 06:41:36
Message-ID: FB334FD4-3D6D-40AC-B292-CF52ABDA8222@aule.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Leo Baltus 2015-08-10 08:51:01 Re: pg_start_backup: file has vanished from pg_subtrans/
Previous Message Guillaume Lelarge 2015-08-10 05:58:43 Re: How to restore