pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedTablespace with multiple locations
2+ messages / 2 participants
[nested] [flat]
* Tablespace with multiple locations
@ 2022-12-29 14:29 PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Doc comments form @ 2022-12-29 14:29 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: husseinyouness@outlook.com
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/15/sql-createtablespace.html
Description:
Hello,
I m kindly requesting a clarification regarding a debatable subject in one
of my projects, that if it's possible to create one global tablespace and
assign many locations like the following example:
create tablespace TBS1 location ('/pgdata1','/pgdata2');
Which will be helpful on database migration, once the new database to be
restored needs further available space than the created tablespace ( if the
new DB is larger than the existing tablespace ), so it can be automatically
distributed on the assigned locations ( filesystems ) with no need for
manual intervention to distribute the schema objects between many
tablespaces that can't be done automatically.
And if a tablespace needs to be extended on a physical partitioned disk
device that is not configured as a logical volume.
Thank you,
Hussein Younes
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Tablespace with multiple locations
@ 2023-01-04 07:12 Peter Eisentraut <peter.eisentraut@enterprisedb.com>
parent: PG Doc comments form <noreply@postgresql.org>
0 siblings, 0 replies; 2+ messages in thread
From: Peter Eisentraut @ 2023-01-04 07:12 UTC (permalink / raw)
To: husseinyouness@outlook.com; pgsql-docs@lists.postgresql.org
On 29.12.22 15:29, PG Doc comments form wrote:
> I m kindly requesting a clarification regarding a debatable subject in one
> of my projects, that if it's possible to create one global tablespace and
> assign many locations like the following example:
>
> create tablespace TBS1 location ('/pgdata1','/pgdata2');
What kind of clarification are you looking for? This feature doesn't
exist and is not planned AFAICT.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2023-01-04 07:12 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-12-29 14:29 Tablespace with multiple locations PG Doc comments form <noreply@postgresql.org>
2023-01-04 07:12 ` Peter Eisentraut <peter.eisentraut@enterprisedb.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox