Обсуждение: 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
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.
>> >
>> > 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
>
>
> > 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