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 <ciprian.grigo...@vitals.com> > wrote:

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

2016-04-22 Thread Bob Lunney
(a one way > operation). > > -- > Stuart Bishop <stu...@stuartbishop.net> > 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-

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 <marll...@gmail.com> wrote: > > Hi guys! > > The OCFS2 and X

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

2015-07-08 Thread Bob Lunney
login -c show all | 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 dan