Re: [GENERAL] 9.5 CentOS 7 setting PGDATA for systemctl

2016-05-22 Thread Tory M Blue
On Sun, May 22, 2016 at 9:10 AM, Adrian Klaver wrote: > On 05/22/2016 09:06 AM, Tory M Blue wrote: >> >> >> >> >>> On May 22, 2016, at 07:50, Adrian Klaver >>> wrote: >>> > >>> >>> So where did you get the 'stock&#x

Re: [GENERAL] 9.5 CentOS 7 setting PGDATA for systemctl

2016-05-22 Thread Tory M Blue
> On May 22, 2016, at 07:50, Adrian Klaver wrote: > >> On 05/21/2016 10:27 PM, Tory M Blue wrote: >> Evening, morning, or afternoon, >> >> So I'm trying to go back to a stock rpm package (vs my full custom, >> builds). This is a learning curve, not

[GENERAL] 9.5 CentOS 7 setting PGDATA for systemctl

2016-05-21 Thread Tory M Blue
Evening, morning, or afternoon, So I'm trying to go back to a stock rpm package (vs my full custom, builds). This is a learning curve, not only because it's all "whacked pathing (in my eyes:)) but rhel7 is a #$%$# with all the things they changed. Sooo I've got servers built and I've got the co

Re: [GENERAL] index build faster on 8G laptop than 30G server

2016-04-19 Thread Tory M Blue
On Tue, Apr 19, 2016 at 2:30 PM, John R Pierce wrote: > On 4/19/2016 2:28 PM, Bill Ross wrote: >> >> I've been running an index build for almost an hour on my 30G server that >> takes ~ 20 mins on my puny old macbook. >> >> It seems like I've tuned all I can.. what am I missing? > > > > > maintena

[GENERAL] ERROR: missing chunk number 0 for toast value 1821556134 in pg_toast_17881

2015-05-27 Thread Tory M Blue
Sorry I think I posted this to the wrong group, sent to performance vs General. My apologies to everyone in perf! Greetings and salutations. > > I've got some weirdness. > > Current: > Postgres 9.3.4 > Slony 2.2.3 > CentOS 6.5 > > Prior running Postgres 9.1.2 w/slony 2.1.3 CentOS 6.2 > > I found t

[GENERAL] pgstat wait timeout

2011-03-14 Thread Tory M Blue
I know you can't do much with this information, but maybe you can help me acquire the information that is needed. This started in 8.4 and trying to figure it out Fedora 12, Postgres 8.4.4 with slony. Although I don't see any panics or errors other then these Warnings, but I did see a dead lock t

Re: [GENERAL] For production: 8.4 or 8.3?

2009-07-27 Thread Tory M Blue
On Mon, Jul 27, 2009 at 12:51 PM, Phoenix Kiula wrote: > Just looking for experiences of people. Are people already using 8.4 > in serious live hosting environments? Thanks. > Wait.. 8.3 is running fine and dandy. Lots of decent sized changes in 8.4 with awaiting fixes. So wait. And those that

Re: [GENERAL] Postgres Pg_connect PHP

2009-06-09 Thread Tory M Blue
On Tue, Jun 9, 2009 at 11:31 AM, Vyacheslav Kalinin wrote: >> however the COPY >> command requires superuser and I really don't want to open up the DB >> from a remote system with Superuser access. > > COPY FROM STDIN does not need superuser privileges. > Thanks guys, the problem with copy from or

[GENERAL] Postgres Pg_connect PHP

2009-06-09 Thread Tory M Blue
Good day, I'm having one heck of a time here. I'm looking for a clean solution to issue a COPY statement from a remote system. (because I really don't want to play the ssh, sudo spiel). It's evident that pg_connect doesn't like the \copy command (it's a no go), however it is okay with the COPY co