Extract Database Definition Files for PostgreSQL

When PostgreSQL and are not installed on the same machine (the database may be installed on any machine within the network), the database definition files need to be transferred to the PostgreSQL machine before the database can be created.

  1. On the PostgreSQL machine (as postgres UNIX user): transfer the database-setup.tar file from the machine and extract the files:

    $ tar -xvf ./database-setup.tar
     
  2. Set the permissions for the extracted files:

    $ chmod -R 755 ./postgresql