pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to move data folder to another mount pount
2+ messages / 2 participants
[nested] [flat]
* How to move data folder to another mount pount
@ 2015-12-20 13:32 clingareddy@vsoftcorp.com
0 siblings, 1 reply; 2+ messages in thread
From: clingareddy@vsoftcorp.com @ 2015-12-20 13:32 UTC (permalink / raw)
To: pgsql-admin
Hi All,
i am using 1TB for my pg_data folder for postgres. But my 1TB if filled with base folder only.
Now i had 2TB another mount point, so i want to move my data folder or new mount point. So please suggest me how to move data folder or my base folder to another location.
Thanks,
Chandra Kiran L
DBA - TEAM
Please do not print this email unless it is absolutely necessary.
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail and destroy all copies of this message and any attachments. Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
Warning: Although the company has taken reasonable precautions to ensure no viruses are present in this email, the company cannot accept responsibility for any loss or damage arising from the use of this email or attachments.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How to move data folder to another mount pount
@ 2015-12-20 13:56 Matheus de Oliveira <matioli.matheus@gmail.com>
parent: clingareddy@vsoftcorp.com
0 siblings, 0 replies; 2+ messages in thread
From: Matheus de Oliveira @ 2015-12-20 13:56 UTC (permalink / raw)
To: clingareddy@vsoftcorp.com; +Cc: pgsql-admin
On Sun, Dec 20, 2015 at 11:32 AM, <clingareddy@vsoftcorp.com> wrote:
> i am using 1TB for my pg_data folder for postgres. But my 1TB if filled
> with base folder only.
>
>
>
> Now i had 2TB another mount point, so i want to move my data folder or new
> mount point. So please suggest me how to move data folder or my base folder
> to another location.
>
You have two options: (1) create a new tablespace at the new mount point
and move the database(s) or some relations or (2) move the entire PGDATA
directory to the new mount point.
For the option (2) we need to know which OS/distro you are using and how
you installed PostgreSQL (package, EDB installer, etc.).
Best regards,
--
Matheus de Oliveira
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2015-12-20 13:56 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-12-20 13:32 How to move data folder to another mount pount clingareddy@vsoftcorp.com
2015-12-20 13:56 ` Matheus de Oliveira <matioli.matheus@gmail.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