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 your second statement is false. *Something* >

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 the postmaster.

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

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 Values[0] = Int3

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 OS name. Nobody'

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 database is up. But in the pro

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 y

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

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 thes

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 wrote: >> >> >> >> But he is seeing the message when he s

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 mailto:adrian.kla...@aklaver.com>> wrote: On 06/22/2017 01:13 PM, Jeff Janes wrote: On Thu, Jun 22, 2017 at 12:06 PM, Ray Stell mailto:ste...@vt.edu>

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 F

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 mailto:adrian.kla...@aklaver.com>> wrote: On 06/22/2017 01:13 PM, Jeff Janes wrote: On Thu, Jun 22, 2017 at 12:06 PM, Ray Stell mailto:ste...@vt.edu>

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 >> throws these msgs: >> >> 2017-06-22

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 "postgresql" does no

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 mailto:adrian.kla...@aklaver.com>> 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 comp

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

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 EDT,0,startup FATAL: 28000

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 L

[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 -- Арсен Арутюнян

[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) Thi

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

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

På torsdag 22. juni 2017 kl. 19:30:49, skrev Andres Freund mailto:and...@anarazel.de>>: 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 t

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 su

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] 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 ON

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 | Description +--+---

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 standard. And I used the fo

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 be

[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 drop-n

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 mailto: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 mailto:ach...@matrix

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

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 postgresql

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 d

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 2016-02-05 6 That's the res

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 large-objec

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: >> >> >> >> 2017-06-22 13:54 GMT+12:00 hvjunk > >: >> H

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