Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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? –  Chrinna 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! –  Chrinna Apr 16 '13 at 19:00
add comment

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.