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 the data
> consistency.
--
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 internals.
As long as you don
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:
>
> scott ribe writes:
>>
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 corruption
risk. (But I've been wro
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 (pgsql-general@postgr
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 TABLE as
>> filter_value:
"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 semantics of your
query. Howe
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 onl
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.
>
>David J.?
I wasn't aware that psql could copy r
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.
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 neither
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
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 the benchmark too
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 SQL Server), but the main reason that it wa
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 per
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
> available during an ev
>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
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 interested in doing it.
No
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 not
> done was that no
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
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 to search the archives
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
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 resulted in patches.
David J.
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 n
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, 09:42:17 GMT+1
Subject: Re: [GENERAL] How to check streaming replication status
My question is: How I can check th
>> 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)
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 -W
>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 check streaming replication status
>>> My question is: How I can check the replication status when the
>> sl
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 archive
LOG: restored log file "0001008B000
> 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 file "0001008B00DD" from archive
> cp: c
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
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.
In
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
33 matches
Mail list logo
