165 reputation
16
bio website
location Manali, India
age 38
visits member for 2 years, 10 months
seen Jan 2 at 12:34

I am using Ubuntu from November 2010. So I started with Ubuntu 10.10. I use Ubuntu server 10.4 and 10.10 as well. I have some experience as a unix admin in the past.

My current work involves with a startup in healthcare IT domain where we are trying to create a user friendly, high quality hospital management software for Indian Market.


Jan
2
accepted Postgresql - Recovery using recovery.conf
Jan
2
awarded  Notable Question
Aug
2
awarded  Popular Question
Jul
17
comment Postgresql - Recovery using recovery.conf
Looks like this is it!. Thanks, I will check and let you know the results.
May
1
awarded  Teacher
Oct
14
answered What are the minimum matching criteria recommended for reliable demographic based patient matching?
Aug
12
revised Postgresql - Recovery using recovery.conf
added more info
Aug
12
revised Postgresql - Recovery using recovery.conf
added 606 characters in body
Aug
12
comment Postgresql - Recovery using recovery.conf
after a time, I am trying to revisit this issue. Here is the output of database times and it is correct.
Aug
9
awarded  Editor
Aug
9
revised PostgreSQL on Ubuntu - Using conf files for recovery
added 2 characters in body
Aug
9
comment PostgreSQL on Ubuntu - Using conf files for recovery
It does not seem to look at /etc/postgresql/..., I had to keep postgresql.conf also in data directory. Probably this is specific to Ubuntu.
Jun
22
comment PostgreSQL on Ubuntu - Using conf files for recovery
I am yet to validate it. but accepting the answer as it looks correct and I will be taking few days to validate them. Thanks Peter.
Jun
22
accepted PostgreSQL on Ubuntu - Using conf files for recovery
Jun
22
comment Postgresql - Recovery using recovery.conf
In this case, WAL files from the same server, so it was from archive directory. So only one server involved in backup and recovery here. I did not see any WAL files missing.
Jun
22
awarded  Scholar
Jun
20
awarded  Student
Jun
20
comment Postgresql - Recovery using recovery.conf
Database timezone is also correct and matching to OS TZ. So I am still at loss why log reported a different time and recovery proceeded 3.5 hours ahead of the time I specified. Will you be able to guide me to check time zone in WAL files?
Jun
17
awarded  Supporter
Jun
17
comment Postgresql - Recovery using recovery.conf
OS time zone is correct. I will check TZ in db and report back. Thanks