I was wondering if something ran into this before and has some answers
to what may have gone wrong here. I set up my local little test server
to allow for SSL connections only as I was playing around with this.
I had to restore a copy of a clients database on my machine to look at
some data and pg_restore kept getting disconnected half way through
restoring the backup with no explanation. Looking at the postgres logs I
noticed a couple of entries related to a negotiation error on SSL. Not
expecting much I changed my pg_hba file to allow for non secure
connections and was suddenly able to restore this backup.
I have had no issues with other backups since I switched my little test
setup to using SSL but I'm eager to find out if this is a known issue
with SSL and if something can be done about this. We're about to roll
out a few setups that require SSL connections and I obviously want to
make sure any backups made on these systems can be restored.
Obviously on a production environment we'd be running the backup process
on the server itself moving the resulting backup file off the server and
there is no requirement to connect over SSL.
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2011-03-01 04:58:10|
|Subject: Re: Backups and SSL |
|Previous:||From: Barbara Figueirido||Date: 2011-03-01 02:03:47|
|Subject: Date operations|