PostgreSQL 11 with SSL on Linux

2020-06-04 Thread Susan Joseph
Can someone tell me if there is a yum version of PostgreSQL 11 that can be installed on Linux that has SSL enabled?  Currently the only way I have gotten SSL turned on in PostgreSQL is by doing the following commands: - tar xzvf /tmp/postgresql-11.2.tar.gz -C /data - mv /data/postgresq

Re: PostgreSQL 11 with SSL on Linux

2020-06-04 Thread Susan Joseph
d for this to work on a non-networked server? -Original Message- From: Magnus Hagander To: Susan Joseph Cc: pgsql-general@lists.postgresql.org Sent: Thu, Jun 4, 2020 11:14 am Subject: Re: PostgreSQL 11 with SSL on Linux On Thu, Jun 4, 2020 at 5:01 PM Susan Joseph wrote: Can so

Re: PostgreSQL 11 with SSL on Linux

2020-06-04 Thread Susan Joseph
So when I run rpm -i it says that the package is installed, but I can't find a postgresql directory with all the files and executables.  So what am I missing? -Original Message- From: Tom Lane To: Susan Joseph Cc: mag...@hagander.net ; pgsql-general@lists.postgresql.org

Re: PostgreSQL 11 with SSL on Linux

2020-06-04 Thread Susan Joseph
with SSL on Linux On Thu, 2020-06-04 at 17:32 +, Susan Joseph wrote: So when I run rpm -i it says that the package is installed, but I can't find a postgresql directory with all the files and executables.  So what am I missing? The server stuff is in postgresql11-serverif you're

Re: PostgreSQL 11 with SSL on Linux

2020-06-04 Thread Susan Joseph
OK thanks, I figured I had something messed up in my thought process.  I will work through these steps and let you know how it goes. Susan -Original Message- From: Mohammed Bhatti To: Susan Joseph Cc: ahodg...@lists.simkin.ca ; pgsql-general@lists.postgresql.org Sent: Thu, Jun 4

Minor Upgrade Question

2020-06-16 Thread Susan Joseph
So when I first started working with PostgreSQL I was using the latest version (11.2).   I don't want to move to 12 yet but I would like to get my 11.2 up to 11.8.  Due to my servers not being connected to the Internet I ended up downloading the libraries and building the files locally.  My que

Re: Minor Upgrade Question

2020-06-19 Thread Susan Joseph
, Jun 16, 2020 at 7:12 AM Susan Joseph <mailto:sandajos...@verizon.net>> wrote: So when I first started working with PostgreSQL I was using the latest version (11.2).   I don't want to move to 12 yet but I would like to get my 11.2 up to 11.8.  Due to my servers not being

SSL between Primary and Seconday PostgreSQL DBs

2020-08-24 Thread Susan Joseph
I have setup a Primary and Secondary PostgreSQL DBs.  They were setup up with basic replication then I went back and modified them to use SSL.  I am just not sure if I did it correctly.  Everything is working but I want to make sure I have the settings correctly.  I am using PostgreSQL 11.2. 

Re: SSL between Primary and Seconday PostgreSQL DBs

2020-08-27 Thread Susan Joseph
So has no one done this before? -Original Message- From: Susan Joseph To: pgsql-gene...@postgresql.org Sent: Mon, Aug 24, 2020 10:10 am Subject: SSL between Primary and Seconday PostgreSQL DBs I have setup a Primary and Secondary PostgreSQL DBs.  They were setup up with basic

Re: SSL between Primary and Seconday PostgreSQL DBs

2020-09-03 Thread Susan Joseph
m a client to the database doesn't prove that database to database is working.  Susan Joseph sandajos...@verizon.net -Original Message- From: Peter Eisentraut To: Susan Joseph ; pgsql-gene...@postgresql.org Sent: Thu, Sep 3, 2020 1:01 am Subject: Re: SSL between Prima

Re: SSL between Primary and Seconday PostgreSQL DBs

2020-09-03 Thread Susan Joseph
Unfortunately I am not allowed to use wireshark in my environment.  Good idea though Susan Joseph sandajos...@verizon.net -Original Message- From: Wim Bertels To: Susan Joseph ; peter.eisentr...@2ndquadrant.com ; pgsql-gene...@postgresql.org Sent: Thu, Sep 3, 2020 7:44 am

Re: SSL between Primary and Seconday PostgreSQL DBs

2020-09-03 Thread Susan Joseph
that "sslmode=verify-ca" doesn't actually verify that the certificate is from a CA it trusts?  So my big question is:  am I really adding more security by turning on SSL or is it just more work for the DBA?  Susan Joseph sandajos...@verizon.net -Original Messag

Re: SSL between Primary and Seconday PostgreSQL DBs

2020-09-03 Thread Susan Joseph
8E SHA-1 Fingerprint: 51B1A879EB5ADAFA23042A8E84165CF89438F29B Susan Joseph sandajos...@verizon.net -Original Message- From: Susan Joseph To: sfr...@snowman.net Cc: pgsql-gene...@postgresql.org Sent: Thu, Sep 3, 2020 8:55 am Subject: Re: SSL between Primary and Seconday PostgreSQL DBs T

Re: SSL between Primary and Seconday PostgreSQL DBs

2020-09-03 Thread Susan Joseph
Susan Joseph sandajos...@verizon.net -Original Message- From: Stephen Frost To: Susan Joseph Cc: pgsql-gene...@postgresql.org Sent: Thu, Sep 3, 2020 9:12 am Subject: Re: SSL between Primary and Seconday PostgreSQL DBs Greetings, * Susan Joseph (sandajos...@verizon.net) wrote

Re: 答复: Security issues concerning pgsql replication

2020-10-27 Thread Susan Joseph
I know when I set it up with a password protecting the private key it would prompt me for the password when I started up the service. Susan Joseph sandajos...@verizon.net -Original Message- From: xiebin (F) To: Magnus Hagander Cc: pgsql-gene...@postgresql.org ; zhubo (C

Upgrading from 11 to 13

2021-03-30 Thread Susan Joseph
I am currently using PostgreSQL 11.2 and would like to try and upgrade it to the latest version 13.  Can I go straight from 11 to 13 or do I need to upgrade to 12 first and then to 13? Thanks, Susan