Hey all,
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.
Cheers,
Bastiaan Olij
e-mail/MSN: bastiaan@basenlily.me
web: http://www.basenlily.me
Skype: Mux213
http://www.linkedin.com/in/bastiaanolij
