Re: [GENERAL] RemoveIPC problem

Yeah, not my style. fsync is on, no caching RAID controller, etc. Thanks. > On Aug 31, 2017, at 9:48 PM, Michael Paquier > wrote: > > As long as you don't run Postgres on scissors with things like fsync = > off or full_page_writes = off, there should be no risk with

Re: [GENERAL] RemoveIPC problem

On Fri, Sep 1, 2017 at 12:10 PM, scott ribe wrote: > Yeah, I was kind of thinking that PG detects the semaphore not existing, > bails immediately, restarts clean, thus no problem. I just wanted to hear > from people, like you, that know way more than I do about the

Re: [GENERAL] RemoveIPC problem

Yeah, I was kind of thinking that PG detects the semaphore not existing, bails immediately, restarts clean, thus no problem. I just wanted to hear from people, like you, that know way more than I do about the internals. > On Aug 31, 2017, at 9:08 PM, Tom Lane wrote: > >

Re: [GENERAL] RemoveIPC problem

scott ribe writes: > Thanks to a typo, I did not turn off systemd's RemoveIPC, and had many many > pg restarts before I figured out the problem. > Should my data be OK? Or do I need to dump & reload? I don't know of any reason to think that that poses a data

[GENERAL] RemoveIPC problem

Thanks to a typo, I did not turn off systemd's RemoveIPC, and had many many pg restarts before I figured out the problem. Should my data be OK? Or do I need to dump & reload? -- Scott Ribe scott_r...@elevated-dev.com (303) 722-0567 -- Sent via pgsql-general mailing list

Re: [GENERAL] Table create time

On Thu, Aug 31, 2017 at 11:46 AM, Melvin Davidson wrote: > > > On Thu, Aug 31, 2017 at 11:26 AM, Achilleas Mantzios < > ach...@matrix.gatewaynet.com> wrote: > >> On 31/08/2017 18:20, Melvin Davidson wrote: >> >> >you could just create an event trigger looking for CREATE

Re: [GENERAL] Problem with Lateral ?

"benj.dev" writes: > I Have a request that produce a bad result. I'm able to rewrite this > request in a form that always produce a good result. It's not at all clear from the amount of info provided whether you've hit a Postgres bug or are just misunderstanding the

[GENERAL] Problem with Lateral ?

I Have a request that produce a bad result. I'm able to rewrite this request in a form that always produce a good result. But I don't understand the real reason of the problem. I have tried to simplify the dataset but the problem doesn't appear with less data. The request produce 16 rows (but

Re: [GENERAL] pgadmin - import a CSV with nulls?

On Thu, 31 Aug 2017 13:20:27 -0700, "David G. Johnston" wrote: >On Thu, Aug 31, 2017 at 1:04 PM, George Neuner wrote: > >> Does anyone know a way to do this reliably? > >?The psql "\copy" meta-command should be capable of doing what you desire.

Re: [GENERAL] pgadmin - import a CSV with nulls?

On Thu, Aug 31, 2017 at 1:04 PM, George Neuner wrote: > Does anyone know a way to do this reliably? > ​The psql "\copy" meta-command should be capable of doing what you desire. David J.​

[GENERAL] pgadmin - import a CSV with nulls?

Hi all, I'm trying to move some data between databases that have different structure, and I'm stuck on how to import a CSV file that contains nulls. Both databases are remote, so COPY is not an option - I don't have shell or filesystem access to the servers. pgAdmin 4 seems useless: it

Re: [GENERAL] Table create time

On Thu, Aug 31, 2017 at 11:26 AM, Achilleas Mantzios < ach...@matrix.gatewaynet.com> wrote: > On 31/08/2017 18:20, Melvin Davidson wrote: > > >you could just create an event trigger looking for CREATE TABLE as > filter_value: > > I have tried that. Unfortunately, I have been unable to extract the

Re: [GENERAL] clustered index benchmark comparing Postgresql vs Mariadb

On Wed, Aug 30, 2017 at 9:03 PM, 유상지 wrote: > I want to get help with Postgresql. > > I investigated that Postgresql could be rather fast in an environment > using a secondary index. but It came up with different results on benckmark. > > The database I compared was mariadb, and

Re: [GENERAL] Table create time

On Thu, Aug 31, 2017 at 11:19 AM, Tom Lane wrote: > Melvin Davidson writes: > > Wolfgang, as David said, a column in pg_class for the creation time of a > > table does not exist. I long ago requested that feature as it is > > in other DB's (Oracle & MS

Re: [GENERAL] Table create time

On 31/08/2017 18:20, Melvin Davidson wrote: >you could just create an event trigger looking for CREATE TABLE as filter_value: I have tried that. Unfortunately, I have been unable to extract the table name from the event because TG_TABLE_NAME is not available during an event trigger, albeit

Re: [GENERAL] Table create time

On Fri, Sep 1, 2017 at 12:20 AM, Melvin Davidson wrote: > >you could just create an event trigger looking for CREATE TABLE as > >filter_value: > > I have tried that. Unfortunately, I have been unable to extract the table > name from the event because TG_TABLE_NAME is not >

Re: [GENERAL] Table create time

>you could just create an event trigger looking for CREATE TABLE as filter_value: I have tried that. Unfortunately, I have been unable to extract the table name from the event because TG_TABLE_NAME is not available during an event trigger, albeit perhaps I am missing something? That being said, I

Re: [GENERAL] Table create time

Melvin Davidson writes: > Wolfgang, as David said, a column in pg_class for the creation time of a > table does not exist. I long ago requested that feature as it is > in other DB's (Oracle & MS SQL Server), but the main reason that it was not > done was that no one was

Re: [GENERAL] Table create time

On Thu, Aug 31, 2017 at 10:21 PM, Melvin Davidson wrote: > Wolfgang, as David said, a column in pg_class for the creation time of a > table does not exist. I long ago requested that feature as it is > in other DB's (Oracle & MS SQL Server), but the main reason that it was

Re: [GENERAL] Table create time

On 31/08/2017 16:12, Achilleas Mantzios wrote: On 31/08/2017 14:03, haman...@t-online.de wrote: On 31/08/2017 09:56, haman...@t-online.de wrote: Hi, is there a way to add a table create (and perhaps schema modify) timestamp to the system? I do occasionally create semi-temporary tables (meant

Re: [GENERAL] Table create time

On Thu, Aug 31, 2017 at 8:29 AM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wednesday, August 30, 2017, wrote: > >> >> Hi, >> >> is there a way to add a table create (and perhaps schema modify) >> timestamp to the system? >> >> > There is not. You may wish

Re: [GENERAL] Table create time

On 31/08/2017 14:03, haman...@t-online.de wrote: On 31/08/2017 09:56, haman...@t-online.de wrote: Hi, is there a way to add a table create (and perhaps schema modify) timestamp to the system? I do occasionally create semi-temporary tables (meant to live until a problem is solved, i.e. longer

Re: [GENERAL] Table create time

On Wednesday, August 30, 2017, wrote: > > Hi, > > is there a way to add a table create (and perhaps schema modify) timestamp > to the system? > > There is not. You may wish to search the archives for discussions as to why previous requests for this feature have not

[GENERAL] Try pglogical with postgres 9.6

Hello, i try to use pglogical with postgres 9.6 i have used this guide https://github.com/2ndQuadrant/pglogical#replication-sets provider: cat /etc/postgresql/9.6/main/local.conf # local postgres conf listen_addresses = '*' wal_level = 'logical' max_worker_processes = 10 # one per database

Re: [GENERAL] How to check streaming replication status

On 31-08-2017 12:14, Glyn Astill wrote: From: Condor To: Glyn Astill Cc: "pgsql-general@postgresql.org" ; "pgsql-general-ow...@postgresql.org" Sent: Thursday, 31 August 2017,

Re: [GENERAL] Table create time

>> On 31/08/2017 09:56, haman...@t-online.de wrote: >> > Hi, >> > >> > is there a way to add a table create (and perhaps schema modify) timestamp >> > to the system? >> > I do occasionally create semi-temporary tables (meant to live until a >> > problem is solved, i.e. longer >> > than a

[GENERAL] ERROR: Undefined Reference to

It seems im missing some References but I don't know where to add them. Here is my Error Code while using $source/configure --host=x86_64-w64-mingw32 --prefix=$dist && make && make install:   x86_64-w64-mingw32-gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement

Re: [GENERAL] How to check streaming replication status

>From: Condor >To: Glyn Astill >Cc: "pgsql-general@postgresql.org" ; >"pgsql-general-ow...@postgresql.org" >Sent: Thursday, 31 August 2017, 09:42:17 GMT+1 >Subject: Re: [GENERAL] How to

Re: [GENERAL] How to check streaming replication status

On 31-08-2017 11:24, Glyn Astill wrote: From: Condor To: "pgsql-general@postgresql.org" Sent: Thursday, 31 August 2017, 08:36:19 GMT+1 after a hour I get error message on slave server: LOG: restored log file "0001008B00DC" from

Re: [GENERAL] How to check streaming replication status

> From: Condor > To: "pgsql-general@postgresql.org" > Sent: Thursday, 31 August 2017, 08:36:19 GMT+1 > > after a hour I get error message on slave server: > > LOG:  restored log file "0001008B00DC" from archive > LOG:  restored log

[GENERAL] How to check streaming replication status

Hello, I have a question about master - slave replication. My version on both servers is : PostgreSQL 9.6.4 on x86_64-slackware-linux-gnu, compiled by x86_64-slackware-linux-gcc (GCC) 7.2.0, 64-bit Here is the story: Today I create a table space and move all indexes on nvmi drives. So far

Re: [GENERAL] Table create time

On 31/08/2017 09:56, haman...@t-online.de wrote: Hi, is there a way to add a table create (and perhaps schema modify) timestamp to the system? I do occasionally create semi-temporary tables (meant to live until a problem is solved, i.e. longer than a session) with conveniently short names.

Re: [GENERAL] Table create time

Hello > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of hamann.w@t- > online.de > Sent: Donnerstag, 31. August 2017 08:56 > To: pgsql-general@postgresql.org > Subject: [GENERAL] Table create time > > > Hi, > > is

[GENERAL] Table create time

Hi, is there a way to add a table create (and perhaps schema modify) timestamp to the system? I do occasionally create semi-temporary tables (meant to live until a problem is solved, i.e. longer than a session) with conveniently short names. Also, is there a simple query to identify tables

Re: [GENERAL] clustered index benchmark comparing Postgresql vs Mariadb

유상지 schrieb am 31.08.2017 um 04:03: > Cluster secondary indexes were faster than those without cluster indexes in > pg, but slower than mariadb. There is no such thing as a "clustered index" in Postgres. The Postgres "cluster" command physically sorts the rows of a table according to the sort