Re: directory name equal database name

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: squid ward <squidw(at)mail(dot)ru>
Cc: pgsql-interfaces(at)lists(dot)postgresql(dot)org
Subject: Re: directory name equal database name
Date: 2020-02-04 16:20:15
Message-ID: 7029.1580833215@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

=?UTF-8?B?c3F1aWQgd2FyZA==?= <squidw(at)mail(dot)ru> writes:
> Question is why directory name not equal as database name?

Because (1) it doesn't work for database names that aren't legal as
filenames (according to the none-too-well-standardized rules of your
particular filesystem); (2) SQL requires us to treat "FOO" and "foo"
as distinct names, but the filesystem might not; (3) renaming a database
is dangerous, as there's no way to make the directory rename action
atomic with commit of the system catalog updates; (4) renaming a database
causes problems for concurrent sessions that might be in the middle of
opening files in that database. And probably a few other reasons I
don't recall off the top of my head.

> Can i change it?

No.

regards, tom lane

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message مهنــ التعليم ــدس MOHANDSEDU 2020-02-04 18:24:43 yti
Previous Message Dave Cramer 2020-02-04 11:15:36 Re: directory name equal database name