Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
    
The root volume already is an EBS volume unless you chose an instance-store AMI. – ceejayoz Apr 16 '13 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? – noahandthewhale Apr 16 '13 at 18:52
1  
data_directory in your .conf file. postgresql.org/docs/8.3/static/… – ceejayoz Apr 16 '13 at 18:53
    
@ceejayoz thanks for the help ceejayoz, much appreciated! – noahandthewhale Apr 16 '13 at 19:00

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.