1

My PostgreSQL database is currently stored in the cloud. Normally, when creating a PostgreSQL database, all the data is stored on the root volume of the EC2 instance.

How can I make sure all the PostgreSQL data stored on the EBS volumes and not the root volume?

4
  • The root volume already is an EBS volume unless you chose an instance-store AMI.
    – ceejayoz
    Commented Apr 16, 2013 at 18:48
  • @ceejayoz that is correct, however when installing postgresql and creating a database, it naturally stores all that data on the root volume, how can I configure it so that all the data is stored on the other EBS volumes?
    – deadlock
    Commented Apr 16, 2013 at 18:52
  • 1
    data_directory in your .conf file. postgresql.org/docs/8.3/static/…
    – ceejayoz
    Commented Apr 16, 2013 at 18:53
  • @ceejayoz thanks for the help ceejayoz, much appreciated!
    – deadlock
    Commented Apr 16, 2013 at 19:00

0

You must log in to answer this question.

Browse other questions tagged .