Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <pgsql-interfaces-owner+archive@lists.postgresql.org>)
	id 1iywBP-0008B7-Bd
	for pgsql-interfaces@arkaria.postgresql.org; Tue, 04 Feb 2020 11:15:55 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-interfaces-owner+archive@lists.postgresql.org>)
	id 1iywBN-0004lE-Gb
	for pgsql-interfaces@arkaria.postgresql.org; Tue, 04 Feb 2020 11:15:53 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <davecramer@gmail.com>)
	id 1iywBN-0004ky-96
	for pgsql-interfaces@lists.postgresql.org; Tue, 04 Feb 2020 11:15:53 +0000
Received: from mail-pg1-f178.google.com ([209.85.215.178])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <davecramer@gmail.com>)
	id 1iywBK-0002Bc-2e
	for pgsql-interfaces@lists.postgresql.org; Tue, 04 Feb 2020 11:15:52 +0000
Received: by mail-pg1-f178.google.com with SMTP id z7so715038pgk.7
        for <pgsql-interfaces@lists.postgresql.org>;
 Tue, 04 Feb 2020 03:15:49 -0800 (PST)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20161025;
        h=x-gm-message-state:mime-version:references:in-reply-to:from:date
         :message-id:subject:to:cc;
        bh=ZeYN/wHMy56jjYl3WuRYFooJea+TC/jZMELihl2DsQo=;
        b=JkKUe2vDNaDoK7fZNXKbYSxK55ggtSljIC6K+UkyGyAC0QIZH4Dv+WbARgutgoM2f7
         WRJCzAInfvKweBKv0xyz94CkHEQ4RqlA3Nhjy9GWh64RviaN7mtpea6S9TrI8Q7FpTTD
         KyKBaNmGmF3oQmTLbM34hTcmYn0yiG3dFJM+DTTLP7Y8Boq+RW2hrYYVY2rXsX13Z85Y
         zwf7HotPLclkWUjPeDkH5FrC6B8C2fz2OlAG6aRvJq/pO6k4O2xzlMD0FZiLdEapgHbw
         3MGn+CBAdW05K/jJ4VWmYqSwA3o9rbbm3dOsjETnw/bhFDkbbwxkHFtLuGT4QeYRlrCB
         5FqA==
X-Gm-Message-State: APjAAAV2pz9YBioghSma+ldjupq+0UKHFNtEDbilS4Zl9JXuR0LZBAyv
	kcDXyICspb1kY1DYsvdKPL+CdFcyisUzpyPZHdc=
X-Google-Smtp-Source: 
 APXvYqwy5+2w1n45/z6bpaAr8ljSI396VG987n6RtPBoKJ2phqTZzrxFK1TF43UHZxDhfR9Ans+ddizJnj18Oz5Bbgk=
X-Received: by 2002:a62:e10b:: with SMTP id q11mr11857762pfh.48.1580814947321;
 Tue, 04 Feb 2020 03:15:47 -0800 (PST)
MIME-Version: 1.0
References: <1580814072.863026304@f532.i.mail.ru>
In-Reply-To: <1580814072.863026304@f532.i.mail.ru>
From: Dave Cramer <pg@fastcrypt.com>
Date: Tue, 4 Feb 2020 06:15:36 -0500
Message-ID: 
 <CADK3HH+_UAspcbsCQpNb5YhfbSs+iQ=N3TP1mFoy+-r2kmp-Tg@mail.gmail.com>
Subject: Re: directory name equal database name
To: squid ward <squidw@mail.ru>
Cc: pgsql-interfaces@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000640d30059dbe297a"
List-Id: <pgsql-interfaces.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-interfaces@lists.postgresql.org>
List-Owner: <mailto:pgsql-interfaces-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-interfaces>
Precedence: bulk

--000000000000640d30059dbe297a
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tue, 4 Feb 2020 at 06:01, squid ward <squidw@mail.ru> wrote:

> Greetings.
> I am better know how work with Microsoft SQL Server, but i try learn
> postgresql too for my work.
> Question is why directory name not equal as database name? For example i
> create database named =C2=ABtest1=C2=BB but in directory it will be somet=
hing like
> 1564512 or whatever number is. Why directory name randomize as number, bu=
t
> not as text? Can i change it?
>

The name is not random it is the Oid of the database. You may not change it

Dave

>
>
>

--000000000000640d30059dbe297a
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote">=
<div dir=3D"ltr" class=3D"gmail_attr">On Tue, 4 Feb 2020 at 06:01, squid wa=
rd &lt;<a href=3D"mailto:squidw@mail.ru">squidw@mail.ru</a>&gt; wrote:<br><=
/div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bo=
rder-left:1px solid rgb(204,204,204);padding-left:1ex">
<div><div><div><div><div id=3D"gmail-m_-7825044745875840157style_1580813966=
0182227943_BODY"><div><div><div>Greetings.</div><div>I am better know how w=
ork with Microsoft SQL Server, but i try learn postgresql too for my work.<=
br>Question is why directory name not equal as database name? For example i=
 create database named =C2=ABtest1=C2=BB but in directory it will be someth=
ing like 1564512 or whatever number is. Why directory name randomize as num=
ber, but not as text? Can i change it?</div></div></div></div></div></div><=
/div></div></blockquote><div><br></div><div>The name is not random it is th=
e Oid of the database. You may not change it=C2=A0</div><div><br></div><div=
>Dave=C2=A0</div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px =
0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><di=
v><div><div><div id=3D"gmail-m_-7825044745875840157style_158081396601822279=
43_BODY"><div><div><div>=C2=A0</div><div><div><div>=C2=A0</div></div></div>=
</div></div></div></div></div></div></div>
</blockquote></div></div>

--000000000000640d30059dbe297a--