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

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

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: 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

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

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

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

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

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

[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, > >

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:

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?: >>

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: 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

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;