Re: [GENERAL] Postgre compatible version with RHEL 7.5

2018-05-21 Thread Martín Marqués
ll supported versions will work (and some of the unsupported ones will as well, although it's not recommended to still be on versions prior to 9.3). -- Martín Marquéshttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

Re: Fast logical replication jump start with PG 10

2018-05-26 Thread Martín Marqués
at is a stopper. If the active node is *active* (receiving writes statements) you'll lose all those changes. I would instead suggest using pglogical and the pglogical_create_subscriber tool to create the subscriber from a basebackup. Kind Regards, -- Martín Marquéshttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

Re: upgrading from pg 9.3 to 10

2018-08-14 Thread Martín Marqués
oing to first jump to 9.4, I'd recommend using pglogical after getting to 9.4 and upgrade straight from 9.4 to 10 (always after testing your application against 10) Regards, -- Martín Marquéshttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

Re: hardcode password in connect string

2018-04-15 Thread Martín Marqués
ll, the best option, and the most secure, is to use a .pgpass file. The psql invocation with it's password will very likely end in .bash_history and alike. Regards, -- Martín Marquéshttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

Re: Pgbouncer discard all

2018-10-16 Thread Martín Marqués
s nothing to do. The connection has already been assigned to the client and the waiting is happening on the database server, not the pooler. Regards, -- Martín Marquéshttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

Re: Enabling bdr in multiple databases on the same postgresql instance/cluster

2018-10-28 Thread Martín Marqués
he first BDR group. Keep in mind you'll need more slots and replication connections, so check the values of max_replication_slots, max_worker_processes and max_wal_senders. Regards, -- Martín Marquéshttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

Re: PostgreSQL MVCC and alternative REDO implementation - my thoughts

2018-11-18 Thread Martín Marqués
in WAL files BTW, could you point us to the blog you read this? Maybe you got REDO and UNDO mixed up. Saludos, -- Martín Marquéshttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

Re: postgresql10-server RPM unpacking of archive failed

2018-11-20 Thread Martín Marqués
yum clean all yum update postgresql10-server Regards, -- Martín Marqués It’s not that I have something to hide, it’s that I have nothing I want you to see

Re: pg_restore fails due to foreign key violation

2018-12-10 Thread Martín Marqués
system. > I would start by running amcheck to see if there is index corruption somewhere, as that can lead to data corruption (in particular if the corrupted index is a unique or primary key index) Regards, -- Martín Marqués It’s not that I have something to hide, it’s that I have nothing I want you to see

Re: Unused indexes

2018-12-01 Thread Martín Marqués
primary doesn't have information of index_scans on other nodes of the cluster. Regards, -- Martín Marqués It’s not that I have something to hide, it’s that I have nothing I want you to see

Re: Pulling data from Postgres DB table for every 5 seconds.

2019-01-09 Thread Martín Marqués
nto our > elasticsearch cluster directly as we get it. I realy doubt that would work. Aurora doesn't have WALs, so how would you be able to decode the transactions? AFAIU, you can't use logical decoding on Aurora. Maybe you should be asking at the Aurora support channel. Regards, -- Martín M

Re: postgres operational

2019-01-09 Thread Martín Marqués
El 9/1/19 a las 17:38, Ron escribió: > On 1/9/19 12:19 PM, Martín Marqués wrote: >> El 9/1/19 a las 14:58, Steve Clark escribió: >>> Hi List, >>> >>> Is there a sure fire way to tell if postgres server is up an >>> operational. I was testing to see if

Re: multiple configurations with repmgr

2019-01-09 Thread Martín Marqués
der to manage, reason why that was removed in later versions Cheers, -- Martín Marquéshttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

Re: postgres operational

2019-01-09 Thread Martín Marqués
where the > socket was there but my script couldn't read from my database yet. Use `check_postgres` -- Martín Marquéshttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services