Re: Documentation section F

Zitat von Peter Eisentraut : No, what was discussed was that the Debian packaging included them in the same package as the server instead of having a separate -contrib package. But the modules themselves are still extensions that you need to install into the databases. Oh, another misundersta

Re: Alter table set logged hanging after writing out all WAL

On Wed, Feb 07, 2018 at 11:35:13AM -0600, Jeremy Finzel wrote: > I was able to get it to finish by just waiting awhile. To give you an > idea, the table with no indexes was set logged in 7 minutes. With the gist > index, it took 3 hours but finally finished. It is only writing WAL for > about th

Re: Master-Slave error: the database system is starting up

Hello on slave hot_standby is on hot_standby = on# "on" allows queries during recovery -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Re: pgadmin4: not possible to create server

On 06.02.2018 18:28, Adrian Klaver wrote: On 02/06/2018 09:24 AM, robert rottermann wrote: Hi there, I have installed pgadmin4 locally using its docker image. this i did running the following command: docker run -p 80:80 -e "PGADMIN_DEFAULT_EMAIL=admin" -e "PGADMIN_DEFAULT_PASSWORD=admin"

Re: pgadmin4: not possible to create server

thanks unfortunately id did not help On 06.02.2018 18:29, Murtuza Zabuawala wrote: Add following in your pg_hba.conf, host all all             0.0.0.0/ 0md5 restart your Postgres database server and try to connect again from pgAdmin4. from pgadmin3 I can conn

Re: Critical errors during logical decoding

On 02/07/2018 10:22 PM, Colin Morelli wrote: > Hey Tomas, > > We're using v1.1.0 of pglogical. I can't honestly say what could > reproduce this issue as I'm not entirely sure and haven't tested it yet. > Well, consider updating - there's 1.1.2 in that exact branch, and there's also 2.1.1 now.

Re: Fwd: postgres instalation

On 02/06/2018 11:02 PM, Azimuddin Mohammed wrote: I think I fig out what the issue here under the ./configure i need to mention man directory as well which I was missing let me ask this once the installation is I see a message "PostgreSQL installation complete" how many directories I should b

Re: "could not receive data from client" && "incomplete startup packet"

David Gauthier wrote: > I thin kit's 9.3.2 :-( > > % psql -V > psql (PostgreSQL) 9.3.2 Ah, you're screwed then. My condolences. > These are my options... > ls -ld /tool/pandora64/.package/postgresql* > drwxr-xr-x 8 pandora pandora 4096 Sep 2 2016 > /tool/pandora64/.package/postgresql-8.2.3 >

Re: "could not receive data from client" && "incomplete startup packet"

I thin kit's 9.3.2 :-( % psql -V psql (PostgreSQL) 9.3.2 These are my options... ls -ld /tool/pandora64/.package/postgresql* drwxr-xr-x 8 pandora pandora 4096 Sep 2 2016 /tool/pandora64/.package/postgresql-8.2.3 drwxr-xr-x 8 pandora pandora 4096 Sep 16 2013 /tool/pandora64/.package/postgresql-

Re: "could not receive data from client" && "incomplete startup packet"

I think I found out what's going on. In the perl script, I'm "forking" a parallel process. The DB connection gets messed up as a consequence (sorry, I can't articulate better because I don't fully understand). But the answer (at least what worked for me), is to formally disconnect and then reconn

Re: BDR, ERROR: previous init failed, manual cleanup is required

On Wed, Feb 7, 2018 at 9:14 AM, Zhu, Joshua wrote: > > > Here is a BDR problem we ran into recently: > > > > A BDR group with a pair of nodes, N1 and N2, group is created on N1, N2 > joins the group, so far so good > > N2 departs/rejoins the group a couple of times, then ran into an issue, > with

Re: Critical errors during logical decoding

Hey Tomas, We're using v1.1.0 of pglogical. I can't honestly say what could reproduce this issue as I'm not entirely sure and haven't tested it yet. I had thought it was caused when a toasted row is deleted before the pglogical_output plugin processes the event (so it fails when going to de-toast

Re: Critical errors during logical decoding

On 02/07/2018 09:07 PM, Colin Morelli wrote: > Appears to be a problem with pglogical_output when de-toasting columns. > Switched to wal2json and the problem went away. I believe I may have > found the issue anyway. Apologies for the noise. > What pglogical version are you using? Can you share an

Re: LDAP for postgres

Greetings, Please don't top-post. I'd also suggest not cross-posting. * John Scalia (jayknowsu...@gmail.com) wrote: > You’ll need to setup your pg_hba.conf file for LDAP. There are several > different ways to do this, but a lot depends on how your LDAP server is > setup. It’s impossible to rea

Re: LDAP for postgres

You’ll need to setup your pg_hba.conf file for LDAP. There are several different ways to do this, but a lot depends on how your LDAP server is setup. It’s impossible to really accurately say what you’ll need in that file. — Jay Sent from my iPad > On Feb 7, 2018, at 3:28 PM, Azimuddin Mohammed

Re: "could not receive data from client" && "incomplete startup packet"

David Gauthier wrote: > Hi David, thanks for the response. > > I upgraded to 9.3.2 and recreated the DB there. So far, so good. I sincerely hope you mean 9.3.20 and not 9.3.2. There are critical bugs that can eat your data in the 9.3 series prior to 9.3.11, so by all means do upgrade to the lat

[no subject]

ÑAO EÑTENĎI

LDAP for postgres

hello, Any idea about how I can enable LDAP for postgres after install ? -- Regards, Azim

Re: Critical errors during logical decoding

Appears to be a problem with pglogical_output when de-toasting columns. Switched to wal2json and the problem went away. I believe I may have found the issue anyway. Apologies for the noise. Best, Colin On Wed, Feb 7, 2018 at 2:20 PM, Colin Morelli wrote: > List, > > For seemingly no reason at a

Re: Documentation section F

On 2/7/18 02:35, Thiemo Kellner wrote: > I learnt yesterday that pgcrypto and uuid-ossp (possibly more) were > included in the core. No, what was discussed was that the Debian packaging included them in the same package as the server instead of having a separate -contrib package. But the module

Critical errors during logical decoding

List, For seemingly no reason at all, my logical replication slot has just started bailing out with errors every time my client tries to connect to it. Particularly - at this moment - I'm getting: 2018-02-07 19:14:31 UTC [3985-1] svc_app@app LOG: 0: received replication command: START_REPLIC

Re: Alter table set logged hanging after writing out all WAL

On Tue, Feb 6, 2018 at 9:48 PM, Jeremy Finzel wrote: > On Tue, Feb 6, 2018 at 6:02 PM Michael Paquier > wrote: > >> On Tue, Feb 06, 2018 at 01:36:04AM -0600, Jeremy Finzel wrote: >> > Here is the basic structure - is the gist index significant?: >> > >> > CREATE UNLOGGED TABLE foo ( >> > as_

BDR, ERROR: previous init failed, manual cleanup is required

Here is a BDR problem we ran into recently: A BDR group with a pair of nodes, N1 and N2, group is created on N1, N2 joins the group, so far so good N2 departs/rejoins the group a couple of times, then ran into an issue, with the following symptom, after executing bdr.bdr_group_join() on N2 wrt

Re: "could not receive data from client" && "incomplete startup packet"

Hi David, thanks for the response. I upgraded to 9.3.2 and recreated the DB there. So far, so good. But nights are usually the worse time, so we'll see later. There is a more current version of the perl code, but that's not the project default at this time. If the PG upgrade fixes this, I'll be

RE: PostgreSQL Active-Active

I would recommend to read https://linode.com/docs/databases/postgresql/create-a-highly-available-postgresql-cluster-using-patroni-and-haproxy/ And actually we just did a 3 hours tutorial at pgconf.ru and soon we will publish slides. In April we will give the Patroni tutorial at postgresconf.us

Re: "could not receive data from client" && "incomplete startup packet"

On Wed, Feb 7, 2018 at 7:34 AM, David Gauthier wrote: > I have a v9.3.0 PG DB on a linux box as the DB server. > ​[...]​ > Any help would be appreciated! > > Upgrade to 9.3.20 and ensure you are using a current version of Perl and DB modules. David J.

"could not receive data from client" && "incomplete startup packet"

Hi: I'm experiencing what appears to be an intermittent db connection problem of some sort (although I may be wrong about that). I have a v9.3.0 PG DB on a linux box as the DB server. The client is a virtual machine (also linux) running the same version... *server side:* sqf=# select version();

RE: PostgreSQL Active-Active

Do you have any tutorial about patroni + ha-proxy with postgresql (what about load balancing with this setup?) Regards. -Mensaje original- De: Stephen Frost [mailto:sfr...@snowman.net] Enviado el: martes, 6 de febrero de 2018 06:12 a. m. Para: Dhandapani Shanmugam CC: pgsql-admin; pgsql-