From: | Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com> |
---|---|
To: | Ron <ronljohnsonjr(at)gmail(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: pg_restore a dump in -Fd format? |
Date: | 2018-05-03 16:38:14 |
Message-ID: | CAGDYbUM9wcgHoFuRqwT4ty_aTRBF4o=br53f+xLjbbVE7pB8OA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi Ron,
You can try the below command by specifying the database name separately.
pg_restore -vcCe --if-exists --jobs=2 -d $DB $SRC
Hope this helps..
On Thu, May 3, 2018 at 9:40 PM, Ron <ronljohnsonjr(at)gmail(dot)com> wrote:
> On 05/03/2018 10:59 AM, David G. Johnston wrote:
>
> On Thu, May 3, 2018 at 8:21 AM, Ron <ronljohnsonjr(at)gmail(dot)com> wrote:
>
>> Hi,
>>
>> v9.6.6
>>
>> I created a backup using "pg_dump -Fd", but am having no luck trying to
>> restore it, and the docs are AFAICT lacking in examples of how to restore
>> -Fd dumps.
>>
>> What's the secret sauce for this method?
>>
>
> What did you try?
>
>
> SRC=/path/to/dump
> DB=mydatabase
> echo `date` Begin restore
> pg_restore -vcCe --if-exists --jobs=2 --file=$SRC/DB
> echo `date` Eng restore
>
> The nohup.out file looks like this:
>
> Thu May 3 11:12:19 EDT 2018 Begin restore
>
> total 49752768
> drwxr-xr-x 2 postgres postgres 20480 May 3 10:20 ./
> drwxr-xr-x 4 postgres postgres 4096 May 3 10:33 ../
> -rw-r--r-- 1 postgres postgres 5 May 3 2018 10001.dat
> -rw-r--r-- 1 postgres postgres 5 May 3 2018 10003.dat
> -rw-r--r-- 1 postgres postgres 5 May 3 2018 9022.dat
> -rw-r--r-- 1 postgres postgres 5 May 3 2018 9024.dat
> -rw-r--r-- 1 postgres postgres 487586 May 3 2018 9026.dat
> -rw-r--r-- 1 postgres postgres 10193438 May 3 2018 9028.dat
> -rw-r--r-- 1 postgres postgres 5 May 3 2018 9030.dat
> [snip]
> -rw-r--r-- 1 postgres postgres 5 May 3 2018 9993.dat
> -rw-r--r-- 1 postgres postgres 5 May 3 2018 9995.dat
> -rw-r--r-- 1 postgres postgres 483 May 3 2018 9997.dat
> -rw-r--r-- 1 postgres postgres 5 May 3 2018 9999.dat
> -rw-r--r-- 1 postgres postgres 1846130 May 3 2018 toc.dat
> pg_restore: [archiver] could not read input file: Bad file descriptor
>
> Thu May 3 11:12:19 EDT 2018 End restore
>
> --
> Angular momentum makes the world go 'round.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Don Seiler | 2018-05-03 17:02:10 | Re: pg_restore a dump in -Fd format? |
Previous Message | Ron | 2018-05-03 16:36:43 | Re: pg_restore a dump in -Fd format? |