Content-Type: multipart/alternative;
	boundary=Apple-Mail-B3883887-5115-4FCA-86EA-141BE6276B32
Mime-Version: 1.0 (1.0)
Subject: Re: pg_restore and the -C flag
From: John Scalia <jayknowsunix@gmail.com>
In-Reply-To: 
 <CAHw75vuaUiGJk3eXarVUnFztc=JSB-bhjGukqw9==ULhdAHrDQ@mail.gmail.com>
Date: Wed, 17 Jul 2019 09:51:08 -0400
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Content-Transfer-Encoding: 7bit
Message-Id: <E0AF71C5-DF4C-4E68-BE49-EFCC837DA7A6@gmail.com>
References: <4C9267A4-5A07-4FC0-B331-40EA95959534@gmail.com>
 <CAHw75vuaUiGJk3eXarVUnFztc=JSB-bhjGukqw9==ULhdAHrDQ@mail.gmail.com>
To: Keith <keith@keithf4.com>
Precedence: bulk


--Apple-Mail-B3883887-5115-4FCA-86EA-141BE6276B32
Content-Type: text/plain;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

Thanks, Keith. I reread the documentation, and I guess that earlier, I wasn=E2=
=80=99t awake enough to comprehend it. It=E2=80=99s all working now.

Sent from my iPhone

> On Jul 17, 2019, at 9:19 AM, Keith <keith@keithf4.com> wrote:
>=20
>=20
>=20
>> On Wed, Jul 17, 2019 at 8:43 AM John Scalia <jayknowsunix@gmail.com> wrot=
e:
>> Hi all,
>>=20
>> =46rom what I=E2=80=99m reading on www.postgresql.org, the -C option for p=
g_restore is supposed to create the database before restoring into it, but h=
ere=E2=80=99s my command line:=20
>>=20
>> pg_restore -p 5432 -C -d restored_db recovery.dmp
>>=20
>> The dmp file was created with pg_dump using=20
>>=20
>> pg_dump -p 5432 -F c orig_db > recovery.dmp.
>>=20
>> Pg_restore errors saying the database does not exist. Yes, I know that po=
rt 5432 is the default, but not all of our databases are.  So, do I have any=
 options wrong with either utility? Or why is this happening? I=E2=80=99m ju=
st trying to document a recovery procedure and testing my documentation.
>> =E2=80=94
>> Jay
>>=20
>> Sent from my iPhone
>>=20
>=20
> I suspect the name your feeding to -d is the one you're trying to create? Y=
ou still have to tell pg_restore to connect to a database that actually exis=
ts so it can log in to create one. So try passing "postgres" to the -d optio=
n. Or connect as you usually do with psql and run \l to see what databases a=
lready exist and connect to one of those.
>=20
> Keith
>=20

--Apple-Mail-B3883887-5115-4FCA-86EA-141BE6276B32
Content-Type: text/html;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto">Thanks, Keith. I reread the documentation, a=
nd I guess that earlier, I wasn=E2=80=99t awake enough to comprehend it. It=E2=
=80=99s all working now.<br><br><div id=3D"AppleMailSignature" dir=3D"ltr">S=
ent from my iPhone</div><div dir=3D"ltr"><br>On Jul 17, 2019, at 9:19 AM, Ke=
ith &lt;<a href=3D"mailto:keith@keithf4.com">keith@keithf4.com</a>&gt; wrote=
:<br><br></div><blockquote type=3D"cite"><div dir=3D"ltr"><div dir=3D"ltr"><=
div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" cl=
ass=3D"gmail_attr">On Wed, Jul 17, 2019 at 8:43 AM John Scalia &lt;<a href=3D=
"mailto:jayknowsunix@gmail.com">jayknowsunix@gmail.com</a>&gt; wrote:<br></d=
iv><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;borde=
r-left:1px solid rgb(204,204,204);padding-left:1ex">Hi all,<br>
<br>
=46rom what I=E2=80=99m reading on <a href=3D"http://www.postgresql.org" rel=
=3D"noreferrer" target=3D"_blank">www.postgresql.org</a>, the -C option for p=
g_restore is supposed to create the database before restoring into it, but h=
ere=E2=80=99s my command line: <br>
<br>
pg_restore -p 5432 -C -d restored_db recovery.dmp<br>
<br>
The dmp file was created with pg_dump using <br>
<br>
pg_dump -p 5432 -F c orig_db &gt; recovery.dmp.<br>
<br>
Pg_restore errors saying the database does not exist. Yes, I know that port 5=
432 is the default, but not all of our databases are.&nbsp; So, do I have an=
y options wrong with either utility? Or why is this happening? I=E2=80=99m j=
ust trying to document a recovery procedure and testing my documentation.<br=
>
=E2=80=94<br>
Jay<br>
<br>
Sent from my iPhone<br>
<br></blockquote><div><br></div><div>I suspect the name your feeding to -d i=
s the one you're trying to create?=20
You still have to tell pg_restore to connect to a database that actually exi=
sts so it can log in to create one.

So try passing "postgres" to the -d option. Or connect as you usually do wit=
h psql and run \l to see what databases already exist and connect to one of t=
hose.</div><div><br></div><div>Keith<br></div><div><br></div></div></div>
</div></blockquote></body></html>=

--Apple-Mail-B3883887-5115-4FCA-86EA-141BE6276B32--