Upgrading 9.2 to 9.6 questions

Hi. We have a setup of 3 Postgres 9.2 nodes (1x master, 2x slaves) running on EC2 instances in AWS. We want to upgrade to 9.6 so we can move to Amazon RDS (it requires at least a 9.3.5 version ). As far as I know, we

Java's org.postgresql.util.PSQLState is missing common PostgreSQL Error Codes

In my Java API server, I am using SERIALIZABLE transaction isolation mode, so I'm specially handling the error code of "40001 serialization_failure", which can occur often. I'm getting the error code String using SQLException's getSQLState() function. Therefore I was surprised to see that the

Re: ALTER DEFAULT PRIVILEGES FOR ROLE

On 1/30/19 10:57 AM, Hilbert, Karin wrote: After a database was updated by the application, a schema dump showed the following default privilege statements: -- -- Name: DEFAULT PRIVILEGES FOR SEQUENCES; Type: DEFAULT ACL; Schema: public; Owner: gitlab_dbo -- ALTER DEFAULT PRIVILEGES FOR

ALTER DEFAULT PRIVILEGES FOR ROLE

After a database was updated by the application, a schema dump showed the following default privilege statements: -- -- Name: DEFAULT PRIVILEGES FOR SEQUENCES; Type: DEFAULT ACL; Schema: public; Owner: gitlab_dbo -- ALTER DEFAULT PRIVILEGES FOR ROLE IN SCHEMA public REVOKE ALL ON SEQUENCES

Re: Old tsearch functions

Howard News writes: > On 30/01/2019 17:20, Adrian Klaver wrote: >> Is to late to experiment with dropping the extension on a 9.5 database >> and then dumping? > Not a problem - The problem only shows in development so far. I have all > the originals in 9.5 and backups to try this on. Note

Re: Old tsearch functions

On 30/01/2019 17:20, Adrian Klaver wrote: Is to late to experiment with dropping the extension on a 9.5 database and then dumping? Not a problem - The problem only shows in development so far. I have all the originals in 9.5 and backups to try this on.

Re: Old tsearch functions

On 1/30/19 9:07 AM, Howard News wrote: Hi, upgrading from 9.5 to 11.1, I have a few tsearch problems that appear to relate to a much older migration (8.3) Originally, for those that remember that far back, tsearch was a contrib module. However it appears that I still have some of the old

Old tsearch functions

Hi, upgrading from 9.5 to 11.1, I have a few tsearch problems that appear to relate to a much older migration (8.3) Originally, for those that remember that far back, tsearch was a contrib module. However it appears that I still have some of the old tsearch functions in my database, and

Re: Major upgrade from 9.6.10 to 10.6 and pg_stat_statement update

On 1/30/19 7:14 AM, Thomas Poty wrote: Hi, I am about to upgrade from 9.6.10 to 10.6 . I read, in the release notes of the 9.6.11 and of the 10.6, an "alter extension pg_stat_statements update" must be done. So, after my upgrade, must the update of pg_statements be done ? Per the notes:

Major upgrade from 9.6.10 to 10.6 and pg_stat_statement update

Hi, I am about to upgrade from 9.6.10 to 10.6 . I read, in the release notes of the 9.6.11 and of the 10.6, an "alter extension pg_stat_statements update" must be done. So, after my upgrade, must the update of pg_statements be done ? Thanks Thomas

Re: pgexpress 4.60 vita voom

On 30/01/2019 14:19, Ray O'Donnell wrote: On 30/01/2019 11:22, ceuro wrote: Hello everybody, this is my first post. I need to update to vita voom pgexpress 4.60 in order to upgrade to postgresql 9.2: I've tried to contact vita voom to collect (I've also already payed) the last release of the

Re: pgexpress 4.60 vita voom

On 30/01/2019 11:22, ceuro wrote: Hello everybody, this is my first post. I need to update to vita voom pgexpress 4.60 in order to upgrade to postgresql 9.2: I've tried to contact vita voom to collect (I've also already payed) the last release of the driver but nobody answer me: Is there anybody

Re: pgexpress 4.60 vita voom

On 1/30/19 5:22 AM, ceuro wrote: Hello everybody, this is my first post. I need to update to vita voom pgexpress 4.60 in order to upgrade to postgresql 9.2: I've tried to contact vita voom to collect (I've also already payed) the last release of the driver but nobody answer me: Is there anybody

pgexpress 4.60 vita voom

Hello everybody, this is my first post. I need to update to vita voom pgexpress 4.60 in order to upgrade to postgresql 9.2: I've tried to contact vita voom to collect (I've also already payed) the last release of the driver but nobody answer me: Is there anybody that could help me in finding the

Re: pg_rewind success even though getting error 'record with incorrect prev-link'

> The only *error* I see is when you apparently manually kill the process. You mean walreceiver process?? 'FATAL: terminating walreceiver process due to administrator command' ? Actually, I didn't kill the receiver. It is done by postgres itself, as far as I understand. I restart this node using