Re: scram-sha-256 authentication broken in FIPS mode

On Wed, Sep 05, 2018 at 03:29:31AM +, Alessandro Gherardi wrote: > It looks like scram-sha-256 doesn't work when postgres is linked > against FIPS-enabled OpenSSL and FIPS mode is turned on. > > Specifically, all login attempts fail with an OpenSSL error saying > something along the lines of "

scram-sha-256 authentication broken in FIPS mode

It looks like scram-sha-256 doesn't work when postgres is linked against FIPS-enabled OpenSSL and FIPS mode is turned on. Specifically, all login attempts fail with an OpenSSL error saying something along the lines of "Low level API call to digest SHA256 forbidden in fips mode". I think this iss

Re: PostgreSQL: Copy from File missing data error

On 09/04/2018 01:13 PM, Holly Gibons wrote: > Could someone suggest what I'm doing wrong? There's probably a magic character that is not escaped properly somewhere before the error location. Exactly how to find them all in a 2GB+ file is another question: e.g. if you know python you could play wi

Re: PostgreSQL: Copy from File missing data error

You might want to try pg_bulkload, and have it kick out malformed rows. It's packaged for RHEL6 and above, plus various other distros. On 09/04/2018 01:13 PM, Holly Gibons wrote: I'm using PostgreSQL 9.0 via pgAdmin III I'm trying to build a PostgreSQL/PostGIS database using Entire country fi

PostgreSQL: Copy from File missing data error

I'm using PostgreSQL 9.0 via pgAdmin III I'm trying to build a PostgreSQL/PostGIS database using Entire country files dataset but I'm getting missing data error I'm wondering if the copy command is affected by diacritics or I've not set the databa

Re: Barman versus pgBackRest

On 9/4/18 7:41 AM, Ron wrote: > On 03/09/2018 08:56 AM, David Steele wrote: > >>> - use replication slots for backingup wal on the backup server. >> Another good feature.  We have not added it yet because pgBackRest was >> originally written for very high-volume clusters (100K+ WAL per day) and >>

Re: Barman versus pgBackRest

Hi Ron, On 9/4/18 7:41 AM, Ron wrote: > On 03/09/2018 08:56 AM, David Steele wrote: > [snip] >>> About pgBarman, I like : >>> - be able restore on a remote server from the backup server >> This a good feature, and one that has been requested for pgBackRest. You >> can do this fairly trivially with

Re: Barman versus pgBackRest

On 09/04/2018 08:55 AM, Ron wrote: On 09/04/2018 10:51 AM, David Steele wrote: [snip] This will work, but I don't think it's what Ron is getting at. To be clear, it is not possible to restore a database into an *existing* cluster using pgBackRest selective restore.  This is a limitation of Post

Re: Barman versus pgBackRest

On 9/4/18 11:55 AM, Ron wrote: > On 09/04/2018 10:51 AM, David Steele wrote: > [snip] >> This will work, but I don't think it's what Ron is getting at. >> >> To be clear, it is not possible to restore a database into an *existing* >> cluster using pgBackRest selective restore.  This is a limitation

Re: Barman versus pgBackRest

On 09/04/2018 10:51 AM, David Steele wrote: [snip] This will work, but I don't think it's what Ron is getting at. To be clear, it is not possible to restore a database into an *existing* cluster using pgBackRest selective restore. This is a limitation of PostgreSQL file-level backups. To do wh

Re: Barman versus pgBackRest

On 9/4/18 11:24 AM, Joshua D. Drake wrote: > On 09/04/2018 07:52 AM, Ron wrote: >> On 09/04/2018 09:24 AM, Joshua D. Drake wrote: >>> On 09/04/2018 07:14 AM, Ron wrote: That was about barman, in the barman group.  This is asking about pgbackrest...  :) So: does pgbackrest h

Re: Barman versus pgBackRest

On 09/04/2018 10:24 AM, Joshua D. Drake wrote: On 09/04/2018 07:52 AM, Ron wrote: On 09/04/2018 09:24 AM, Joshua D. Drake wrote: On 09/04/2018 07:14 AM, Ron wrote: That was about barman, in the barman group.  This is asking about pgbackrest...  :) So: does pgbackrest have this ability whic

Re: increasing HA

On 09/04/2018 07:58 AM, Thomas Poty wrote: - using an automatick failover  I found PAF  Could you advice any others solutions to explore or share your experience? LinuxHA or Patroni are the most common we run into. JD-- Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc *

Re: Barman versus pgBackRest

On 09/04/2018 07:52 AM, Ron wrote: On 09/04/2018 09:24 AM, Joshua D. Drake wrote: On 09/04/2018 07:14 AM, Ron wrote: That was about barman, in the barman group.  This is asking about pgbackrest...  :) So: does pgbackrest have this ability which barman does not have? The "--db-include" opti

RE: increasing HA

Hi I have made a lot of PostgreSQL High Availability tests (more than 20 by solution) and the two following products respond well to the need : (1)Repmgr (2ndQuadrant) (2)Pglookout (aiven) About PAF, the product is hard to install and set up . It need a linux cluster and

increasing HA

Hello, I am looking after some advice about solution allowing to increase High availability? Here is a bit of context : I have an Master-Slave architecture - 1 master - 2 asynchronous slaves using replication slot - backup is made with barman using replication slot - Wal archiving is done to

Re: Barman versus pgBackRest

On 09/04/2018 09:24 AM, Joshua D. Drake wrote: On 09/04/2018 07:14 AM, Ron wrote: That was about barman, in the barman group.  This is asking about pgbackrest...  :) So: does pgbackrest have this ability which barman does not have? The "--db-include" option seems to indicate that you can re

Re: Barman versus pgBackRest

On 09/04/2018 07:14 AM, Ron wrote: That was about barman, in the barman group.  This is asking about pgbackrest...  :) So: does pgbackrest have this ability which barman does not have? The "--db-include" option seems to indicate that you can restore a single db, but does indicate whether or

RE: psqlODBC

Thank you Adrian! Hi ODBC Project Team, Would you mind looking into this please? Regards, Virendra. -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday, September 04, 2018 9:47 AM To: Kumar, Virendra; pgsql-general@lists.postgresql.org Subject: Re: p

Re: Barman versus pgBackRest

That was about barman, in the barman group.  This is asking about pgbackrest...  :) So: does pgbackrest have this ability which barman does not have? The "--db-include" option seems to indicate that you can restore a single db, but does indicate whether or not you can rename it. On 09/04/

Re: psqlODBC

On 09/04/2018 06:38 AM, Kumar, Virendra wrote: Hi Community, We are facing some problem with using psqlODBC driver connecting to postgres-xl. Whom should we redirect our queries? https://www.postgresql.org/list/pgsql-odbc/ Basically, when using load balancing across cluster we are seeing b

Re: Barman versus pgBackRest

Your problem looks like this one ;-) https://groups.google.com/forum/#!topic/pgbarman/kXcEpSLhw8w answer may help Physical backup/restore operates on a whole cluster... Le mar. 4 sept. 2018 à 14:47, Ron a écrit : > On 09/04/2018 07:14 AM, Thomas Poty wrote: > > > Do you just change the IP addre

psqlODBC

Hi Community, We are facing some problem with using psqlODBC driver connecting to postgres-xl. Whom should we redirect our queries? Basically, when using load balancing across cluster we are seeing below error and the process is failing: -- "AutomationException: Underlying DBMS error[ERROR: prep

Re: Barman versus pgBackRest

On 09/04/2018 07:14 AM, Thomas Poty wrote: > Do you just change the IP address of the "restore target"? Do you expect a typical restore command? I'm investigating barman and pgBackRest to replace our exitsing NetBackup system, so don't know what you mean by "typical restore command". Here ar

Re: Barman versus pgBackRest

> Do you just change the IP address of the "restore target"? Do you expect a typical restore command? If yes, here is a small bash script I use for check restore ... barmanBackupID="" barmanBackupServer=$1 if [ 1 -eq $# ]; then echo ${barmanBackupServer} barmanBackupID=$(barman list-backup

Re: Barman versus pgBackRest

On 03/09/2018 08:56 AM, David Steele wrote: [snip] About pgBarman, I like : - be able restore on a remote server from the backup server This a good feature, and one that has been requested for pgBackRest. You can do this fairly trivially with ssh, however, so it generally hasn't been a big deal