Hi Blair, Pavel,
we are using procedure described in https://access.redhat.com/solutions/4896
to automate crash detail collection for our production systems on RHEL 7.
Perhaps something like this can help on your side.
Kind Regards,
Jan
On 2018-03-09 04:35:05+10:00 Pavel Stehule wrote:
2018
You should be using the latest version of the driver. What version are you
using ?
Even though you have a 9.4 database the latest version is the correct
version to use.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 8 March 2018 at 22:14, David G. Johnston
wrote:
> On Thu, Mar 8,
On Thu, Mar 8, 2018 at 2:30 PM, chris wrote:
> Given that the syntax looks correct for the url, how would we go about
> debugging that it's not seeing the comma?
First thing I'd do is ensure the version of the driver I'm using supports
the feature I'm trying to use.
David J.
On 03/08/2018 01:30 PM, chris wrote:
Given that the syntax looks correct for the url, how would we go about
debugging that it's not seeing the comma?
From previous post:
Can you provide more information about the JDBC version you are using
and the app code you are using?
On 03/08/2018 02
Thanks David and Achilleas. This is no longer an issue. The table
previously went to the public schema. I'm not sure what I did. Anyway,
without a prefix, it defaults to the current schema.
On Thu, Mar 8, 2018 at 2:02 AM, Achilleas Mantzios <
ach...@matrix.gatewaynet.com> wrote:
> On 08/03/2018 0
Adrian Klaver writes:
> When I restore using 10.2 I see:
> pg_restore: creating ACL "public.TABLE wl_week"
> Do you see something similar?
> My suspicion is that this might have something to do with the commits below:
Yeah, this evidently changed in commits 3eb9a5e7c et al, which made ACL
restor
Given that the syntax looks correct for the url, how would we go about
debugging that it's not seeing the comma?
On 03/08/2018 02:27 PM, Adrian Klaver wrote:
On 03/08/2018 01:12 PM, chris wrote:
Hi,
I have a JDBC temping to connect to 2 postgres nodes in a hot standby
configuration. Running
On 03/08/2018 01:12 PM, chris wrote:
Hi,
I have a JDBC temping to connect to 2 postgres nodes in a hot standby
configuration. Running postgres 9.4 on centos6.
What we are trying to accomplish is in an event of a failover, to first
try to connect to the master. If that fails to then reach out
My interpretation of that error is slightly different. I think what it is
saying is that for the first IP address, it thinks the port number is the
full string "5432,10.16.10.13:5432" and fails when it tries to convert that
into a port number. Are you positive the URL format you are trying to use
i
On 03/08/2018 01:12 PM, chris wrote:
Hi,
I have a JDBC temping to connect to 2 postgres nodes in a hot standby
configuration. Running postgres 9.4 on centos6.
What we are trying to accomplish is in an event of a failover, to first
try to connect to the master. If that fails to then reach out
Hi,
I have a JDBC temping to connect to 2 postgres nodes in a hot standby
configuration. Running postgres 9.4 on centos6.
What we are trying to accomplish is in an event of a failover, to first
try to connect to the master. If that fails to then reach out to the
standby.
I looked online an
On 03/08/2018 09:06 AM, Alexandru Lazarev wrote:
client_min_messages GUC didn't change
Commands are:
pg_dump --host 127.0.0.1 --port 5432 --username postgres --format custom
--blobs --file /tmp/postgresql.backup -Z9 my_db
pg_restore -h 127.0.0.1 -p 5432 -U postgres -Fc -v -j$(nproc) -d my_db
On Thu, Mar 08, 2018 at 03:05:36PM -0500, Tom Lane wrote:
> Justin Pryzby writes:
> > On Thu, Mar 08, 2018 at 01:57:06PM -0500, Tom Lane wrote:
> >> PID 20488 is evidently waiting for PID 6471 to finish its transaction.
> >> What's that one doing?
>
> > Um, I thought I had kept track of all two p
Justin Pryzby writes:
> On Thu, Mar 08, 2018 at 01:57:06PM -0500, Tom Lane wrote:
>> PID 20488 is evidently waiting for PID 6471 to finish its transaction.
>> What's that one doing?
> Um, I thought I had kept track of all two pids but looks not..
> query| SELECT pg_export_snapshot();
On Thu, Mar 08, 2018 at 01:57:06PM -0500, Tom Lane wrote:
> Justin Pryzby writes:
> > Running pg10.2, I have a handful of maintenance jobs run in the middle of
> > the
> > night, which appear to have gotten stuck waiting on each other..
>
> > ts=# SELECT granted, pid, mode, virtualtransaction, v
We're on centos 7.0, glibc-2.17-55. Current centos is
7.4, glibc-2.17-196. We have some hosts on the newer centos, I'll ask our
sysadmin about upgrading.
Do you know of glibc issues that would be of relevance?
Our main production database has been running the same centos and pg 9.4.4
without an
Justin Pryzby writes:
> Running pg10.2, I have a handful of maintenance jobs run in the middle of the
> night, which appear to have gotten stuck waiting on each other..
> ts=# SELECT granted, pid, mode, virtualtransaction, virtualxid FROM pg_locks
> WHERE virtualxid='22/4317099' ORDER BY 1,2,3;
2018-03-08 19:16 GMT+01:00 Blair Boadway :
> Hi Pavel,
>
>
>
> I don’t have a core yet, the only way I have now is to intentionally crash
> the prod system a couple of times. Haven’t resorted to that yet.
>
hard to help without backtrace - and then you need core dump
>
>
> Interesting you ment
On Wed, Mar 7, 2018 at 3:50 PM, Alvaro Herrera
wrote:
>
> Scott Frazer wrote:
>
> > It's only happening on the read replicas, though. I've just set my
master
> > to handle all the traffic, but that's not really sustainable
>
> I failed to notice at start of thread that these were replicas. I
> su
Running pg10.2, I have a handful of maintenance jobs run in the middle of the
night, which appear to have gotten stuck waiting on each other..
. reindex - loop around pg_repack or psql -c REINDEX $table for those which
can't
be repacked)
. vacuum - mostly runs ANALYZE, like on empty parent t
Hi Pavel,
I don’t have a core yet, the only way I have now is to intentionally crash the
prod system a couple of times. Haven’t resorted to that yet.
Interesting you mentioned pgaudit—it is installed on this system because that
is a our standard installation but on this particular system we ha
Hi
2018-03-08 18:40 GMT+01:00 Blair Boadway :
> Hello,
>
>
>
> We’re seeing an occasional segfault on a particular database
>
>
>
> Mar 7 14:46:35 pgprod2 kernel:postgres[29351]: segfault at 0 ip
> 00302f32868a sp 7ffcf1547498 error 4 in libc-2.12.so[302f20+
> 18a000]
>
> Mar 7 14:4
Hello,
We’re seeing an occasional segfault on a particular database
Mar 7 14:46:35 pgprod2 kernel:postgres[29351]: segfault at 0 ip
00302f32868a sp 7ffcf1547498 error 4 in libc-2.12.so[302f20+18a000]
Mar 7 14:46:35 pgprod2 POSTGRES[21262]: [5] user=,db=,app=client= LOG: server
pr
client_min_messages GUC didn't change
Commands are:
pg_dump --host 127.0.0.1 --port 5432 --username postgres --format custom
--blobs --file /tmp/postgresql.backup -Z9 my_db
pg_restore -h 127.0.0.1 -p 5432 -U postgres -Fc -v -j$(nproc) -d my_db
/tmp/postgresql.backup 2>&1 | tee /tmp/restore.txt
Kelly Burkhart writes:
> Hello, I've had two core dumps in the last couple of weeks. The most
> recent, yesterday was on version 10.2:
> (gdb) bt
> #0 0x7f317a043886 in get_next_seq () from /lib64/libc.so.6
> #1 0x7f317a044acc in strcoll_l () from /lib64/libc.so.6
> #2 0x007ce
Hello, I've had two core dumps in the last couple of weeks. The most
recent, yesterday was on version 10.2:
(gdb) bt
#0 0x7f317a043886 in get_next_seq () from /lib64/libc.so.6
#1 0x7f317a044acc in strcoll_l () from /lib64/libc.so.6
#2 0x007ced5f in varstrfastcmp_locale ()
#3 0
Jacek:
On Thu, Mar 8, 2018 at 1:53 PM, Łukasz Jarych wrote:
> maybe somebody wrote SP to invert update statement?
Maybe, but if you are going to ask for it you better define the
problem a little.
Francisco Olarte.
Hello:
On Thu, Mar 8, 2018 at 1:51 PM, Łukasz Jarych wrote:
> what do you mean use external program to build inverted queries. Do you have
> any examples?
Please, do not top quote, or the thread will get difficult to follow fast.
That being said. Capturing a DML in a trigger is relatively easy
On 03/08/2018 01:49 AM, Alexandru Lazarev wrote:
Hi PG community,
I have questions about pg_restore output.
At some point of time in pg_restore output was such phrase
"*/pg_restore: setting owner and privileges for /*", then
it disappeared, it seems, when upgraded from PG 9.6.2 to 9.6.6
Other
On Thursday, March 8, 2018, Francisco Olarte wrote:
>
> On Thu, Mar 8, 2018 at 1:26 PM, Łukasz Jarych wrote:
> > i have a table when i have string in each row,
> > for example "DELETE FROM t_test WHERE ID = 3".
> >
> > I want to execute for each row this command.
> > It is possible?
>
> I supose
maybe somebody wrote SP to invert update statement?
Best,
Jacek
2018-03-08 13:51 GMT+01:00 Łukasz Jarych :
> thank you,
>
> what do you mean use external program to build inverted queries. Do you
> have any examples?
>
> Best,
> Jacek
>
> 2018-03-08 13:44 GMT+01:00 Francisco Olarte :
>
>> Hello:
thank you,
what do you mean use external program to build inverted queries. Do you
have any examples?
Best,
Jacek
2018-03-08 13:44 GMT+01:00 Francisco Olarte :
> Hello:
>
> On Thu, Mar 8, 2018 at 1:32 PM, Łukasz Jarych wrote:
>
>>
>>
>> i have a trigger which is added log history:
>>
>>
>>
>>
Hello Francisco,
thank you !
Jacek is the same as Łukasz. Is my second name and my artist's nickname ;-)
love your answer,
thank you!
Best,
Jacek
2018-03-08 13:40 GMT+01:00 Francisco Olarte :
> Hello:
>
>
>
> On Thu, Mar 8, 2018 at 1:26 PM, Łukasz Jarych wrote:
> > i have a table when i have
Hello:
On Thu, Mar 8, 2018 at 1:32 PM, Łukasz Jarych wrote:
>
>
> i have a trigger which is added log history:
>
>
>
>
I'll trust it is, but I cannot really see any thing in there, it may be
better if in the future you used something like psql and pasted the data in
a text format, which people
Hello:
On Thu, Mar 8, 2018 at 1:26 PM, Łukasz Jarych wrote:
> i have a table when i have string in each row,
> for example "DELETE FROM t_test WHERE ID = 3".
>
> I want to execute for each row this command.
> It is possible?
I supose you mean execute the command contained in each row. Anyway,
Hello,
i have a trigger which is added log history:
It is possible to create additional column here with string with inversed
SQL statement?
So in this case: "Delete FROM t_trig WHERE ID=1".
And what i want is to have possibility to loop through table and execute
inversed sql statement for ea
Hello,
i have a table when i have string in each row,
for example "DELETE FROM t_test WHERE ID = 3".
I want to execute for each row this command.
It is possible?
Best wishes,
Jacek
Thanks! That fixed the issue.
-Original Message-
From: Michael Paquier [mailto:mich...@paquier.xyz]
Sent: Thursday, 8 March 2018 6:41 PM
To: Yavuz Selim Sertoğlu
Cc: Dylan Luong ; pgsql-generallists.postgresql.org
Subject: Re: Resync second slave to new master
On Thu, Mar 08, 2018 at
Hi PG community,
I have questions about pg_restore output.
At some point of time in pg_restore output was such phrase "*pg_restore:
setting owner and privileges for *", then it disappeared, it
seems, when upgraded from PG 9.6.2 to 9.6.6
Other phrases "pg_restore: processing *item *3615 DEFAULT id
On Thu, Mar 08, 2018 at 10:48:29AM +0300, Yavuz Selim Sertoğlu wrote:
> If not set, could you add recovery.conf file
> recovery_target_timeline='latest'
> parameter?
> https://www.postgresql.org/docs/devel/static/recovery-target-settings.html
Yes, that's visibly the issue here.
--
Michael
signat
40 matches
Mail list logo
