Re: [GENERAL] Postgres processes getting stuck (bug?)

2016-04-29 Thread Bob Lunney
pg_terminate_backend() didn’t work, as the signal queued behind the kernel wait. We had to bounce the database to get rid of the problem. Immediately afterwards we disabled the trigger. HTH, Bob Lunney > On Apr 29, 2016, at 1:30 PM, Ciprian Grigoras > wrote: > > Hi guys, > > I had

Re: [GENERAL] Initdb --data-checksums by default

2016-04-22 Thread Bob Lunney
op > http://www.stuartbishop.net/ > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general +1 Bob Lunney Lead Data Architect MeetMe, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Postgresql 9.3.4 file system compatibility

2016-04-08 Thread Bob Lunney
XFS absolutely does. Its well supported on Redhat and CentOS 6.x and 7.x. Highly recommended. Don’t know about OCFS2. Bob Lunney Lead Data Architect MeetMe, Inc. > On Apr 8, 2016, at 8:56 AM, Marllius wrote: > > Hi guys! > > The OCFS2 and XFS have compatibility with p

Re: [GENERAL] PG 9.4.4 issue on French Windows 32 bits

2015-07-08 Thread Bob Lunney
| grep lc_ s'il vous plaît. Also check if any code is setting client_encoding or any of the lc_* options on the fly. Bob Lunney Senior Database Engineer AWeber Communications, LLC 1100 Manor Drive Chalfont, PA 18914 USA > On Jul 8, 2015, at 12:48 PM, Daniel Verite wrote: > >