[GENERAL] enable PostgreSQL SSL from RPM package installation

Hi I have installed PostgreSQL from the following RPMs onto the server. And I would like to enable SSL. postgresql96-devel-9.6.2-2PGDG.rhel7.x86_64 postgresql96-libs-9.6.2-2PGDG.rhel7.x86_64 postgresql96-contrib-9.6.2-2PGDG.rhel7.x86_64 postgresql96-server-9.6.2-2PGDG.rhel7.x86_64

Re: [GENERAL] enable PostgreSQL SSL from RPM package installation

Am 22. Juni 2017 08:10:15 MESZ schrieb Dylan Luong : >Hi >I have installed PostgreSQL from the following RPMs onto the server. >And I would like to enable SSL. > >postgresql96-devel-9.6.2-2PGDG.rhel7.x86_64 >postgresql96-libs-9.6.2-2PGDG.rhel7.x86_64

[GENERAL] pglogical vs. built-in logical replication in pg-10

Hi.   1. Why should one prefer built-in logical replication in pg-10 to pglogical, does it do anything pglogical doesn't? It seems pglogical is more feature-rich... 2. As I understand built-in logical replication in pg-10 doesn't support large-objects, which we use a lot. Does pglogical

Re: [GENERAL] pglogical vs. built-in logical replication in pg-10

On 22/06/2017 11:21, Andreas Joseph Krogh wrote: Hi. 1. Why should one prefer built-in logical replication in pg-10 to pglogical, does it do anything pglogical doesn't? It seems pglogical is more feature-rich... 2. As I understand built-in logical replication in pg-10 doesn't support

Re: [GENERAL] "joining" table records

Il 21/06/2017 19:11, David G. Johnston ha scritto: On Wed, Jun 21, 2017 at 9:47 AM, Moreno Andreo wrote: I have this table rec_code | rec_date | int1 | int2 | 10 2014-07-21 3 4 11 2014-07-21 5 10 2015-01-04 1 2 11

Re: [GENERAL] pglogical vs. built-in logical replication in pg-10

På torsdag 22. juni 2017 kl. 11:43:02, skrev Achilleas Mantzios < ach...@matrix.gatewaynet.com >: On 22/06/2017 11:21, Andreas Joseph Krogh wrote: Hi.   1. Why should one prefer built-in logical replication in pg-10 to pglogical, does it do anything pglogical

Re: [GENERAL] current postgresql logfile being written to?

> On 22 Jun 2017, at 04:44 , Lucas Possamai wrote: > > > > 2017-06-22 14:16 GMT+12:00 hvjunk >: > >> On 22 Jun 2017, at 4:06 AM, Lucas Possamai > > wrote: >> >> >> >>

Re: [GENERAL] enable PostgreSQL SSL from RPM package installation

On 06/21/2017 11:10 PM, Dylan Luong wrote: Hi I have installed PostgreSQL from the following RPMs onto the server. And I would like to enable SSL. postgresql96-devel-9.6.2-2PGDG.rhel7.x86_64 postgresql96-libs-9.6.2-2PGDG.rhel7.x86_64 postgresql96-contrib-9.6.2-2PGDG.rhel7.x86_64

Re: [GENERAL] pglogical vs. built-in logical replication in pg-10

On 22/06/2017 17:46, Andreas Joseph Krogh wrote: På torsdag 22. juni 2017 kl. 15:25:20, skrev Achilleas Mantzios >: On 22/06/2017 13:38, Andreas Joseph Krogh wrote: På torsdag 22. juni 2017 kl. 11:43:02, skrev

Re: [GENERAL] Error when building new db using pg_restore

On 06/21/2017 05:30 PM, Adrian Klaver wrote: On 06/21/2017 05:06 PM, Jim Longwill wrote: On 06/21/2017 01:21 PM, David G. Johnston wrote: On Wed, Jun 21, 2017 at 1:10 PM, Jim Longwill wrote: rdev1=# \dd Object descriptions Schema | Name | Object |

Re: [GENERAL] pglogical vs. built-in logical replication in pg-10

På torsdag 22. juni 2017 kl. 17:10:40, skrev Achilleas Mantzios < ach...@matrix.gatewaynet.com >: [snip] What's so better in LO's VS bytea? You do a lot updates on the binary data, changing only parts of it?   BYTEA really sucks when dealing with large objects

[GENERAL] Prudent practices for PostgreSQL disk configuration?

Hello: I’m about to upgrade my disk configuration and looking for prudent disk configuration practices for running PostgreSQL 9.3 on RHEL6 in a VMWare environment in a shared hosting facility — physical disk not SSD. This is a write-heavy transactional application. 8 Cpu cores (if it matters)

Re: [GENERAL] pglogical vs. built-in logical replication in pg-10

On 2017-06-22 12:43:02 +0300, Achilleas Mantzios wrote: > On 22/06/2017 11:21, Andreas Joseph Krogh wrote: > > Hi. > > 1. Why should one prefer built-in logical replication in pg-10 to > > pglogical, does it do anything pglogical doesn't? > > It seems pglogical is more feature-rich... > > 2. As I

Re: [GENERAL] pglogical vs. built-in logical replication in pg-10

On 2017-06-22 18:10:40 +0300, Achilleas Mantzios wrote: > > Once again having pg_largeobject as a system-catalog prevents LOs > > from working smoothly. Neither replication nor having LOs on a > > different tablespace (by moving pg_largeobject) works. > I think logical decoding was designed for

Re: [GENERAL] pglogical vs. built-in logical replication in pg-10

På torsdag 22. juni 2017 kl. 19:30:49, skrev Andres Freund >: On 2017-06-22 18:10:40 +0300, Achilleas Mantzios wrote: > > Once again having pg_largeobject as a system-catalog prevents LOs > > from working smoothly. Neither replication nor having

Re: [GENERAL] londiste3: removing a node that does not exist

2017-06-22 18:21 GMT+03:00 Willy-Bas Loos : > Does anyone know of a method to get rid of the bad node and the data that > it is gathering? I also do not know the correct way to achieve this. But once I needed to rename one of the queues to follow the internal naming

Re: [GENERAL] Error when building new db using pg_restore

On 06/22/2017 10:05 AM, Jim Longwill wrote: Ok. Thank you for the input. I do see the 'Description' of plpgsql there. So, if I can determine the source table(s) of this information perhaps I could delete that particular value.I tried the following as per documentation: COMMENT

[GENERAL] SPI_execute_plan and vardata

Hello I can't:convert char* to Datum Datum Values[2]; Values[0]-is integer type  but Values[1] is string type so  Values[0] = SET_4_BYTES(227); please assist how can i convert som char* string to Datum Values[1] = CONVERT_STRING_TO DATUM(char *); etc best -- Арсен Арутюнян

Re: [GENERAL] 10beta1 role

On 06/22/2017 12:06 PM, Ray Stell wrote: I used "initdb -U" to specify an alternate superuser. On startup it Can you show your complete initdb command? throws these msgs: 2017-06-22 14:36:34 EDT,0,startup FATAL: 28000: role "postgresql" does not exist 2017-06-22 14:36:34 EDT,0,startup

Re: [GENERAL] 10beta1 role

On 6/22/17 4:07 PM, Adrian Klaver wrote: On 06/22/2017 12:06 PM, Ray Stell wrote: I used "initdb -U" to specify an alternate superuser. On startup it Can you show your complete initdb command? throws these msgs: 2017-06-22 14:36:34 EDT,0,startup FATAL: 28000: role "postgresql" does not

Re: [GENERAL] 10beta1 role

On 6/22/17 4:36 PM, Adrian Klaver wrote: On 06/22/2017 01:16 PM, Ray Stell wrote: On 6/22/17 4:07 PM, Adrian Klaver wrote: On 06/22/2017 12:06 PM, Ray Stell wrote: I used "initdb -U" to specify an alternate superuser. On startup it Can you show your complete initdb command? throws

Re: [GENERAL] 10beta1 role

On 06/22/2017 01:16 PM, Ray Stell wrote: On 6/22/17 4:07 PM, Adrian Klaver wrote: On 06/22/2017 12:06 PM, Ray Stell wrote: I used "initdb -U" to specify an alternate superuser. On startup it Can you show your complete initdb command? throws these msgs: 2017-06-22 14:36:34 EDT,0,startup

Re: [GENERAL] 10beta1 role

On Thu, Jun 22, 2017 at 1:39 PM, Jeff Janes wrote: > On Thu, Jun 22, 2017 at 1:34 PM, Adrian Klaver > wrote: > >> On 06/22/2017 01:29 PM, Jeff Janes wrote: >> >>> On Thu, Jun 22, 2017 at 1:22 PM, Adrian Klaver < >>> adrian.kla...@aklaver.com

[GENERAL] 10beta1 role

I used "initdb -U" to specify an alternate superuser. On startup it throws these msgs: 2017-06-22 14:36:34 EDT,0,startup FATAL: 28000: role "postgresql" does not exist 2017-06-22 14:36:34 EDT,0,startup LOCATION: InitializeSessionUserId, miscinit.c:503 -- Sent via pgsql-general mailing

Re: [GENERAL] 10beta1 role

On Thu, Jun 22, 2017 at 1:22 PM, Adrian Klaver wrote: > On 06/22/2017 01:13 PM, Jeff Janes wrote: > >> On Thu, Jun 22, 2017 at 12:06 PM, Ray Stell ste...@vt.edu>> wrote: >> >> I used "initdb -U" to specify an alternate superuser. On startup it >>

Re: [GENERAL] 10beta1 role

On Thu, Jun 22, 2017 at 12:06 PM, Ray Stell wrote: > I used "initdb -U" to specify an alternate superuser. On startup it > throws these msgs: > > 2017-06-22 14:36:34 EDT,0,startup FATAL: 28000: role "postgresql" does > not exist > > 2017-06-22 14:36:34 EDT,0,startup LOCATION:

Re: [GENERAL] 10beta1 role

On 6/22/17 4:34 PM, Adrian Klaver wrote: On 06/22/2017 01:29 PM, Jeff Janes wrote: On Thu, Jun 22, 2017 at 1:22 PM, Adrian Klaver > wrote: On 06/22/2017 01:13 PM, Jeff Janes wrote: On Thu, Jun 22, 2017 at 12:06 PM, Ray

Re: [GENERAL] 10beta1 role

On 06/22/2017 01:43 PM, Jeff Janes wrote: On Thu, Jun 22, 2017 at 1:39 PM, Jeff Janes > wrote: Correction, it can prove it started, because when it connects as the wrong user, it gets an error message which it would only get if the

Re: [GENERAL] 10beta1 role

On 06/22/2017 01:13 PM, Jeff Janes wrote: On Thu, Jun 22, 2017 at 12:06 PM, Ray Stell > wrote: I used "initdb -U" to specify an alternate superuser. On startup it throws these msgs: 2017-06-22 14:36:34 EDT,0,startup FATAL: 28000: role

Re: [GENERAL] 10beta1 role

On 06/22/2017 01:29 PM, Jeff Janes wrote: On Thu, Jun 22, 2017 at 1:22 PM, Adrian Klaver > wrote: On 06/22/2017 01:13 PM, Jeff Janes wrote: On Thu, Jun 22, 2017 at 12:06 PM, Ray Stell

Re: [GENERAL] 10beta1 role

On 06/22/2017 01:41 PM, Ray Stell wrote: On 6/22/17 4:36 PM, Adrian Klaver wrote: On 06/22/2017 01:16 PM, Ray Stell wrote: On 6/22/17 4:07 PM, Adrian Klaver wrote: On 06/22/2017 12:06 PM, Ray Stell wrote: I used "initdb -U" to specify an alternate superuser. On startup it Can you show

Re: [GENERAL] 10beta1 role

On Thu, Jun 22, 2017 at 4:07 PM, Adrian Klaver wrote: > On 06/22/2017 12:06 PM, Ray Stell wrote: > >> I used "initdb -U" to specify an alternate superuser. On startup it >> > > Can you show your complete initdb command? > > throws these msgs: >> >> 2017-06-22 14:36:34

Re: [GENERAL] 10beta1 role

Ray Stell writes: > I added -W to the initdb, but the startup has same msg. same. As I > said, the postmaster starts. I just thought the msgs might not be desired. In principle, we could add a -U option to pg_ctl to tell it to do test connections with a userid other than your

Re: [GENERAL] 10beta1 role

On 6/22/17 4:10 PM, Melvin Davidson wrote: On Thu, Jun 22, 2017 at 4:07 PM, Adrian Klaver > wrote: On 06/22/2017 12:06 PM, Ray Stell wrote: I used "initdb -U" to specify an alternate superuser. On startup it

Re: [GENERAL] 10beta1 role

On Thu, Jun 22, 2017 at 1:34 PM, Adrian Klaver wrote: > On 06/22/2017 01:29 PM, Jeff Janes wrote: > >> On Thu, Jun 22, 2017 at 1:22 PM, Adrian Klaver > > wrote: >> >> On 06/22/2017 01:13 PM, Jeff Janes

Re: [GENERAL] SPI_execute_plan and vardata

=?UTF-8?B?0JDRgNGB0LXQvSDQkNGA0YPRgtGO0L3Rj9C9?= writes: > Datum Values[2]; > Values[0]-is integer type  > but Values[1] is string type so  > Values[0] = SET_4_BYTES(227); This is really bad practice. It might accidentally work, but the right way to do it is more like

Re: [GENERAL] Suddenly - LOG: could not open file "postmaster.pid": No such file or directory

On Fri, Jun 23, 2017 at 1:43 PM, Tom Lane wrote: > Muhammad Hanif Abdul Hamid writes: >> Within this week, I have faced two times "postmaster.pid" went missing in a >> sudden. Nobody deleted it or shutdown the server. > > I'd lay very long odds that

Re: [GENERAL] Suddenly - LOG: could not open file "postmaster.pid": No such file or directory

Muhammad Hanif Abdul Hamid writes: > Within this week, I have faced two times "postmaster.pid" went missing in a > sudden. Nobody deleted it or shutdown the server. I'd lay very long odds that your second statement is false. *Something* removed that file, and it wasn't

[GENERAL] Suddenly - LOG: could not open file "postmaster.pid": No such file or directory

Hi, Within this week, I have faced two times "postmaster.pid" went missing in a sudden. Nobody deleted it or shutdown the server. May I know anybody who has ever experience this? Can please anybody can help me on this? 2017-06-20 13:10:10.261 MYT [24726] [unknown]@[unknown] LOG: incomplete

[GENERAL] londiste3: removing a node that does not exist

Hi, I'm using londiste3 for replication in postgres 9.3 I made a typo when registering a consumer and I changed the name of that consumer during the creation process. I now have a non-functional node in the producer database, that is mongering historical data. I have tried to use londiste

Re: [GENERAL] pglogical vs. built-in logical replication in pg-10

On 6/22/17 04:21, Andreas Joseph Krogh wrote: > 1. Why should one prefer built-in logical replication in pg-10 to > pglogical, does it do anything pglogical doesn't? > It seems pglogical is more feature-rich... You are right that pglogical has more functionality. Much of that functionality can

Re: [GENERAL] pglogical vs. built-in logical replication in pg-10

På torsdag 22. juni 2017 kl. 15:25:20, skrev Achilleas Mantzios < ach...@matrix.gatewaynet.com >: On 22/06/2017 13:38, Andreas Joseph Krogh wrote: På torsdag 22. juni 2017 kl. 11:43:02, skrev Achilleas Mantzios < ach...@matrix.gatewaynet.com

Re: [GENERAL] pglogical vs. built-in logical replication in pg-10

On 22/06/2017 13:38, Andreas Joseph Krogh wrote: På torsdag 22. juni 2017 kl. 11:43:02, skrev Achilleas Mantzios >: On 22/06/2017 11:21, Andreas Joseph Krogh wrote: Hi. 1. Why should one prefer built-in logical