By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,962 Members | 1,998 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,962 IT Pros & Developers. It's quick & easy.

postgres server recovery

100+
P: 138
hi all,
i have a postgres server for one online application. if the server is crashed by chance how can i recover it, if i have taken the back-up of the "data" folder. can it be done in linux, if yes then how? could anybody suggest me ? or is there any other method to do so?
thanx in advance
Apr 15 '08 #1
Share this Question
Share on Google+
5 Replies


Expert 100+
P: 700
hi all,
i have a postgres server for one online application. if the server is crashed by chance how can i recover it, if i have taken the back-up of the "data" folder. can it be done in linux, if yes then how? could anybody suggest me ? or is there any other method to do so?
thanx in advance
What is data folder? You mean folder with databases?
Apr 15 '08 #2

100+
P: 138
What is data folder? You mean folder with databases?

hi rski,
yes i mean the folder with databases.can it be done?


coolminded
Apr 15 '08 #3

Expert 100+
P: 700
hi rski,
yes i mean the folder with databases.can it be done?


coolminded
But you have only 'base' (where are databases folders) folder or whole cluster folder?
Apr 16 '08 #4

100+
P: 138
But you have only 'base' (where are databases folders) folder or whole cluster folder?

my data folder is in

/usr/local/pgsql/data

and it contains following

base pg_hba.conf pg_subtrans PG_VERSION postmaster.opts
global pg_ident.conf pg_tblspc pg_xlog postmaster.pid
pg_clog pg_multixact pg_twophase postgresql.conf serverlog

and one more question to ask
how to setup PITR in linux

with regards..
Apr 16 '08 #5

Expert 100+
P: 700
my data folder is in

/usr/local/pgsql/data

and it contains following

base pg_hba.conf pg_subtrans PG_VERSION postmaster.opts
global pg_ident.conf pg_tblspc pg_xlog postmaster.pid
pg_clog pg_multixact pg_twophase postgresql.conf serverlog

and one more question to ask
how to setup PITR in linux

with regards..
So you have w copy of whole cluster. What you need is to start serwer with your this cluster using command

pg_ctl start -D path_to_data_directory

was it helpful?
See here for PITR.
Apr 16 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.