file system level backup

From: iztech <rashantha(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: file system level backup
Date: 2008-06-12 13:31:35
Message-ID: 05ce354c-1f7d-4586-a714-469479250f26@a9g2000prl.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

i have just switched to posgresql and installed for use with ruby.

i need to move my app and database to a new server. since i can shut
down the server i think it will be easier for me to do a file system
level back up.

when i try to shut the server down i get this message

sudo -u postgres pg_ctl -D /opt/local/var/db/postgresql82/defaultdb
stop
pg_ctl: PID file "/opt/local/var/db/postgresql82/defaultdb/
postmaster.pid" does not exist
Is server running?

it is running.

this is my first time attempting this. can someone suggest an easy
tutorial on this.

also...
i have set up the new server with the same permissions so i should be
able to move the db to the new location.

total newbie

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2008-06-12 13:32:23 Re: array column and b-tree index allowing only 8191 bytes
Previous Message Adam Dear 2008-06-12 13:12:25 Re: Unable to dump database using pg_dump