4

I have an odd situation. I have a postgreSQL database master with multiple large tablespaces divided across 3 physical disks. I am setting up a slave that will be used to offload long, time-insensitive queries from the master.

Because time is not a concern on the slave, I have set up a machine with only one disk. However, when I try to set up replication, psql tries to mimic the structure on the master.

$ /usr/pgsql-9.2/bin/pg_basebackup -h [master] -D "/opt/database" -U [user]
pg_basebackup: could not create directory "/opt/archive-tables": permission denied

Because I have only one disk, I need all data to be stored in /opt/database (where the disk is mounted).

Is there some way to override the master tablespace structure and force everything to go into a single tablespace (or at least onto a single file location)?

1

Community Wiki answer generated from a question comment by a_horse_with_no_name

Create symbolic links on the slave that match the mount points of the tablespaces on the master.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.