Hi all,
Can I do a consistent file-system-level backup using the following
procedure:
1) SELECT pg_start_backup(...)
2) rsync postgres data dir to another server
3) SELECT pg_stop_backup()
4) rsync pg_xlog directory
From what I understand this should be similar to running pg_basebackup
using th
> Original Message
> Subject: Re: [GENERAL] LDAP authentication not working
> Resent-From:
> Date: Wed, 14 May 2014 06:47:45 -1000
> From: Stephan Fabel
> To: Magnus Hagander
> CC: Postgres List , Jürgen Fuchsberger
>
>
Hi,
I'm running postgresql 9.1 on Debian and am trying to set up LDAP
authentication using the following configuration in pg_hba.conf:
hostssl testdb all 143.50.203.0/24 ldap ldapserver="wegc24.uni-graz.at"
ldapport=636 ldapbinddn="cn=nss,dc=uni-graz,dc=at"
ldapbindpasswd="" ldapbasedn="dc=u
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, e
base
> cluster state: *shut down"` - if pg_controldata output doesn't include
> "shut down" or "shut down in recovery", then something's amiss and the
> backup won't be clean (error in shutdown, etc.)
> 5) `sync`
> 6) now take the backu
tate: *shut down"` - if pg_controldata output doesn't include
> "shut down" or "shut down in recovery", then something's amiss and the
> backup won't be clean (error in shutdown, etc.)
> 5) `sync`
> 6) now take the backup
>
> -Jason
Jason,
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
Hi all,
I have a problem with a corrupt backup, fortunately I was only testing
so I did not loose any data. Unfortunetely what I did is to follow the
backup guidelines in the documentation, which I thought should work
reliably. Here are the details:
I am running a postgreSQL 8.4 database on