Re: [GENERAL] File system level backup of shut down standby does not work?

On 02/19/2014 11:43 AM, Albe Laurenz wrote: > Jürgen Fuchsberger wrote: >> One very important thing I just noted when shutting down and restarting >> my standby server: >> >> My standby server *always needs the last WAL-file* from the archive >> directory, even when the shut down was "smart". Wit

Re: [GENERAL] File system level backup of shut down standby does not work?

That is correct. When the source server is shut down, it may or may not be caught up for replication (most likely not). You'll need all of the WAL files that haven't been applied yet; if for some reason you've got a large amount of replication lag, you might need more than just the first. I'm n

Re: [GENERAL] File system level backup of shut down standby does not work?

Jürgen Fuchsberger wrote: > One very important thing I just noted when shutting down and restarting > my standby server: > > My standby server *always needs the last WAL-file* from the archive > directory, even when the shut down was "smart". Without this the > consistent recovery state will not b

Re: [GENERAL] File system level backup of shut down standby does not work?

All, One very important thing I just noted when shutting down and restarting my standby server: My standby server *always needs the last WAL-file* from the archive directory, even when the shut down was "smart". Without this the consistent recovery state will not be reached. 2014-02-19 11:10:20

Re: [GENERAL] File system level backup of shut down standby does not work?

On 02/19/2014 02:14 AM, Antman, Jason (CMG-Atlanta) wrote: > Juergen, > > I've seen this quite a lot in the past, as we do this multiple times a day. > > Here's the procedure we use to prevent it: > 1) read the PID from postmaster.pid in the data directory > 2) Issue "service postgresql-9.0 sto

Re: [GENERAL] File system level backup of shut down standby does not work?

Juergen, I've seen this quite a lot in the past, as we do this multiple times a day. Here's the procedure we use to prevent it: 1) read the PID from postmaster.pid in the data directory 2) Issue "service postgresql-9.0 stop" (this does a fast shutdown with -t 600) 3) loop until the PID is no lon

Re: [GENERAL] File system level backup of shut down standby does not work?

On Mon, Feb 17, 2014 at 7:02 PM, Jürgen Fuchsberger < juergen.fuchsber...@uni-graz.at> wrote: > Hi all, > > I have a master-slave configuration running the master with WAL > archiving enabled and the slave in recovery mode reading back the WAL > files from the master ("Log-shipping standby" as des

[GENERAL] File system level backup of shut down standby does not work?

Hi all, I have a master-slave configuration running the master with WAL archiving enabled and the slave in recovery mode reading back the WAL files from the master ("Log-shipping standby" as described in http://www.postgresql.org/docs/9.1/static/warm-standby.html) I take frequent backups of the s

Re: [GENERAL] file system level backup

On 01/06/2014 07:03 AM, zach cruise wrote: I am not sure if you have already answered it and I have somehow missed it: - Are these 'a' and 'b' on two different servers? ( I think they are on different servers) > yes - Did you stop the server on 'b' before you replaced the files and attempted a

Re: [GENERAL] file system level backup

I am not sure if you have already answered it and I have somehow missed it: - Are these 'a' and 'b' on two different servers? ( I think they are on different servers) > yes - Did you stop the server on 'b' before you replaced the files and attempted a startup? > yes > thanks. it doesn't help. i

Re: [GENERAL] file system level backup

On 01/04/2014 06:41 PM, zach cruise wrote: CCing list: So is there anything in the Windows system logs? > looks like file system level backups don't work well on windows because they get corrupted during transfer. Whoa, how did we get to that conclusion? > as a safety, i had a

Re: [GENERAL] file system level backup

I am not sure if you have already answered it and I have somehow missed it: - Are these 'a' and 'b' on two different servers? ( I think they are on different servers) - Did you stop the server on 'b' before you replaced the files and attempted a startup? > thanks. it doesn't help. i also tried pg_

Re: [GENERAL] file system level backup

On 01/04/2014 04:37 PM, zach cruise wrote: So is there anything in the Windows system logs? > looks like file system level backups don't work well on windows because they get corrupted during transfer. Whoa, how did we get to that conclusion? Does the Task Manager show another Postgres r

Re: [GENERAL] file system level backup

I am still not understanding. You have a 2008 server at a and one at b. You copied the Postgres data files from 2008 server a to 2008 server b. This did not work, so you say you restored the data directory on server b from an old copy of the data directory at b. So where did t

Re: [GENERAL] file system level backup

On 01/04/2014 02:13 PM, zach cruise wrote: I am still not understanding. You have a 2008 server at a and one at b. You copied the Postgres data files from 2008 server a to 2008 server b. This did not work, so you say you restored the data directory on server b from an old copy of the data direc

Re: [GENERAL] file system level backup

Questions: 1) Both servers are x64? > yes 2) What installation files(Graphical installer, source,etc)? > postgresql-9.3.0-1-windows-x64 from enterprisedb.com 3) Does the data directory have the config files? > yes however,

Re: [GENERAL] file system level backup

On 01/04/2014 01:20 PM, zach cruise wrote: Questions: 1) Both servers are x64? > yes 2) What installation files(Graphical installer, source,etc)? > postgresql-9.3.0-1-windows-x64 from enterprisedb.com 3) Does the data directory have the config files? > yes

Re: [GENERAL] file system level backup

Questions: 1) Both servers are x64? > yes 2) What installation files(Graphical installer, source,etc)? > postgresql-9.3.0-1-windows-x64 from enterprisedb.com 3) Does the data directory have the config files? > yes however, postgresql b won't start ("not listening")? 4) How are you start

Re: [GENERAL] file system level backup

On 01/04/2014 12:54 PM, zach cruise wrote: so i installed 9.3 x64 on two windows 2008 servers from one set of installation files. then i created databases on postgresql a, shutdown all the servers, copied /data/ (from "show data_directory") from postgresql a to postgresql b. in short, i did a ful

[GENERAL] file system level backup

so i installed 9.3 x64 on two windows 2008 servers from one set of installation files. then i created databases on postgresql a, shutdown all the servers, copied /data/ (from "show data_directory") from postgresql a to postgresql b. in short, i did a full file system level backup ( http://www.postg

Re: [GENERAL] File system level backup

"Manoj Agarwal" wrote: > From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov] >> "Manoj Agarwal" wrote: >>> I need to transfer the database from one machine to other. >>> Both machines contain a database with the same name, for >>> example: testdb, but with different data/values, but the

Re: [GENERAL] File system level backup

abase in a cluster, but as a whole, is it possible? Kind Regards, Manoj Agarwal -Original Message- From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov] Sent: Thursday, August 02, 2012 2:18 AM To: Manoj Agarwal; pgsql-general@postgresql.org Subject: Re: [GENERAL] File system le

Re: [GENERAL] File system level backup

"Manoj Agarwal" wrote: > I need to transfer the database from one machine to other. Both > machines contain a database with the same name, for example: > testdb, but with different data/values, but the structure is > exactly same. > Take file system level backup from from first machine for

Re: [GENERAL] File system level backup

Manoj Agarwal wrote on 26.07.2012 12:39: Hi, I have two virtual machines with two different versions of Postgresql. One machine contains Postgres 7.4.19 and another has Postgres 8.4.3. I also have other instances of these two virtual machines. I need to transfer the database from one machine

Re: [GENERAL] File system level backup

On Thu, Jul 26, 2012 at 3:39 AM, Manoj Agarwal wrote: > Hi, > > > > I have two virtual machines with two different versions of Postgresql. One > machine contains Postgres 7.4.19 and another has Postgres 8.4.3. I also > have other instances of these two virtual machines. I need to transfer the >

[GENERAL] File system level backup

Hi, I have two virtual machines with two different versions of Postgresql. One machine contains Postgres 7.4.19 and another has Postgres 8.4.3. I also have other instances of these two virtual machines. I need to transfer the database from one machine to other. Both machines contain a datab

Re: [GENERAL] file system level backup

@craig i am on mac os x 10.5 and i installed via macports using robby russel pg install guide. here is the initdb... Init your new PostgreSQL database with: initdb -D pgdata Start up PostgreSQL with: pg_ctl -D pgdata -l pgdata/psql.log start Create a new database with: createdb argon_development

Re: [GENERAL] file system level backup

iztech wrote: On Jun 12, 6:31 am, iztech <[EMAIL PROTECTED]> wrote: 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. pg_du

[GENERAL] file system level backup

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_c

Re: [GENERAL] file system level backup

On Jun 12, 6:31 am, iztech <[EMAIL PROTECTED]> wrote: > 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

Re: [GENERAL] File system level backup from 32bit to 64bit

Hi, On Montag, 7. Januar 2008, [EMAIL PROTECTED] wrote: | i wanted to move my database from a 32bit machine to 64bit machine with | rsync like it is explained here [...] | i guess that rsyncing all database files from 32bit to 64bit does not work. Yes, you are right; 32bit and 64bit formats are i

[GENERAL] File system level backup from 32bit to 64bit

i wanted to move my database from a 32bit machine to 64bit machine with rsync like it is explained here http://www.postgresql.org/docs/8.1/interactive/backup-file.html I did an inital rsync while database was running. then shutdown, rsync again, starting 64bit database says: /var/lib/postgres