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
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,
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
> 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
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: 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
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
>> 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)
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
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 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.
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 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 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 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
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
>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
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
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 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 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: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
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 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.
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
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
"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
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:
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
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
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:
>>
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, 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.
--
33 matches
Mail list logo
