Re: Creating a new database on a different file system
| От | Tim Gerber |
|---|---|
| Тема | Re: Creating a new database on a different file system |
| Дата | |
| Msg-id | CAPKih1wGSz4oAL+8hn6F=8gW4ZGCm+CEmLzARDmUFOXYSJuioQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Creating a new database on a different file system (Ian Dauncey <Ian.Dauncey@bankzero.co.za>) |
| Список | pgsql-general |
Tablespaces would work... take a look: https://www.postgresql.org/docs/current/manage-ag-tablespaces.html
Hi All
We are running an old version of PostgreSQL on a Linux Server.
We have created a few databases on the file system defined in the postgresql.conf, but now I would like to create another database within the same cluster but on a different file system.
Is this possible and if so, how do we go about it.
In a nutshell:
I have the following statement defined in the postgresql.conf file - data_directory = '/opt/pgdata_postgres'
I have created the following database datadb1, datadb2 (plus all default databases)
Now I want to create a third database datadb3, but it needs to be created on file system “/opt/pgdata1_postgres” and not on ‘/opt/pgdata_postgres'
Is this possible
Regards
Ian
В списке pgsql-general по дате отправления: