[GENERAL] archiver process problem

wake up the archiver process again so it starts copying files out, short of restarting postgres? Running PG 8.3.7. Thanks! Scot Kreienkamp skre...@la-z-boy.com

Re: [GENERAL] archiver process problem

Never mind, it picked up again. It took a few hours, not sure why. Scot Kreienkamp skre...@la-z-boy.com From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Scot Kreienkamp Sent: Monday, October 18, 2010 11:29 AM To: pgsql-general

Re: [GENERAL] Blocking access by remote users for a specific time period

o the change. Scot Kreienkamp -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Steve Atkins Sent: Sunday, December 14, 2014 1:02 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Blocking access by remote users

Re: [GENERAL] WAL and master multi-slave replication

Thanks, Scot Kreienkamp La-Z-Boy Inc. skre...@la-z-boy.com 734-242-1444 ext 6379 -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Alvaro Herrera Sent: Wednesday, June 24, 2009 1:51 PM To: Eduardo Morras Cc: Scott

[GENERAL] Idle in transaction help

develop against 8.4. Thanks for any help you can give me. Scot Kreienkamp

Re: [GENERAL] Idle in transaction help

are there locks acquired, sometimes on the row level, prior to the connection going to idle in transaction status? That makes me think it's not the JDBC driver. Thanks, Scot Kreienkamp -Original Message- From: John R Pierce [mailto:pie...@hogranch.com] Sent: Friday, July 10, 2009

Re: [GENERAL] Idle in transaction help

Thanks scott, but I wrote a cgi to combine all of the process info and allow me to kill errant queries. So I know how to track down the pid. Thanks for trying to help though. :-) - Original Message - From: Scott Marlowe To: Scot Kreienkamp Cc: pgsql-general@postgresql.org Sent: Fri

Re: [GENERAL] Idle in transaction help

performance and I don't like being reduced to sitting on the sidelines I'm trying to see what if anything else my skills can contribute. As for patting you on the head, I was being sincere. And trying not to come off sounding like a cocky SOB. :-) Thanks, Scot Kreienkamp -

Re: [GENERAL] VMWare file system / database corruption

ical disks backing the VMWare host and the size of the virtual machine and any existing snapshot. I've been told that in VSPhere (VMWare 4.0) this will be significantly improved. My .02 cents worth as we are a heavy VMWare user. Thanks, Scot Kreienkamp skre...@la-z-boy.com -O

Re: [GENERAL] VMWare file system / database corruption

We have fiber channel in production and iscsi in development. Both work well but iscsi is definitely slower. In our case the iscsi disks are slower too so that likely affects our speed on iscsi. Sent from my iPod On Sep 21, 2009, at 4:24 PM, "John R Pierce" wrote: Scot

[GENERAL] slightly off-topic: Central Auth

rvers running Linux. The Linux environment is growing too large not to do centralized authentication of some kind. At this point I'm open to suggestions or comments. SSH and X are required, PG would be nice to be able to auth centrally as well while I'm at it. Thanks, Scot Kreienkamp

Re: [GENERAL] slightly off-topic: Central Auth

These are all RH4 and 5, so they do all have PAM. I thought PAM had to interface with something else, which is where NIS and LDAP enter the picture, to authenticate to another server though. Otherwise I'm not sure how it works? Thanks, Scot Kreienkamp skre...@la-z-boy.com

Re: [GENERAL] slightly off-topic: Central Auth

On 16/10/2009 19:38, Scot Kreienkamp wrote: > Hey everyone, > > > > I apologize in advance for going slightly off topic, but I have never > setup a centralized authentication scheme under Linux. My question is, > what do most people do for centralized command line, X, an

[GENERAL] question about pg_dump

the documentation, any changes made during the backup would NOT be in the dumped datafile. That is very important for a monthend process where I need consistent data as of exactly the time the dump starts, which is why I'm confirming that is indeed the case. Thanks, Scot Kreienkamp skre...@la-z-boy.com

[GENERAL] table insert/primary key question

happening on the table? If so, is that because of the possible violation of the primary key by the following pending inserts? Just trying to confirm the behavior I'm seeing and make sure I understand what's going on. Thanks! Scot Kreienkamp | Senior Systems Engineer | La-Z-Boy Incorpora

[GENERAL] Help with ERROR: character 0xc280 of encoding "UTF8" has no equivalent in "WIN1252"

once I get it working so the end users can use the view. PG 8.3.7. Thanks for any help you can provide. Scot Kreienkamp This message is intended only for the individual or entity to which it is addressed. It may contain privileged, confidential information which is exempt from disclos

[GENERAL] idle in transaction query makes server unresponsive

upgrade to 9.2. That will take about 6-10 months. Thanks! Scot Kreienkamp This message is intended only for the individual or entity to which it is addressed. It may contain privileged, confidential information which is exempt from disclosure under applicable laws. If you are not the inte

Re: [GENERAL] idle in transaction query makes server unresponsive

query makes server unresponsive > > On 09/25/12 12:23 PM, Scot Kreienkamp wrote: > > > > I have a problem that I've been struggling with for quite some time. > > Every once in a while I will get a connection that goes to idle in > > transaction on an in-house programmed a

Re: [GENERAL] idle in transaction query makes server unresponsive

query makes server unresponsive > > Scot Kreienkamp wrote on 25.09.2012 22:35: > > The application is using a pooler and generally runs around 100 > > connections, but I've seen it as high as 200 during the day for > > normal use. It's on a large server; 64 cores total

Re: [GENERAL] idle in transaction query makes server unresponsive

> -Original Message- > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@postgresql.org] On Behalf Of Albe Laurenz > Sent: Wednesday, September 26, 2012 5:15 AM > To: Scot Kreienkamp; pgsql-general@postgresql.org > Subject: Re: [GENERAL] idle in

[GENERAL] CIDR data type query help

cript. If there's no specific match for the IP of the originating workstation then it should return the /24 if it's there, then the /16 if it's there, etc. I have never worked with the CIDR type, and a novice when it comes to SQL query language, so I have no idea how to approach this. T

Re: [GENERAL] CIDR data type query help

Thanks Steve, that works nicely in the testing I've done so far. I'll keep in mind about the pgfoundry project. I don't see this growing overly large, but you never know. I didn't realize the CIDR type couldn't be indexed. Scot Kreienkamp skre...@la-z-boy.co

[GENERAL] help with error "unexpected pageaddr"

Hey everyone, We have a PG 8.3.7 server that is doing WAL log shipping to 2 other servers that are remote mirrors. This has been working well for almost two years. Last night we did some massive data and structure changes to one of our databases. Since then I get these errors on the two mirr

Re: [GENERAL] help with error "unexpected pageaddr"

"Scot Kreienkamp" writes: > We have a PG 8.3.7 server that is doing WAL log shipping to 2 other > servers that are remote mirrors. This has been working well for almost > two years. Last night we did some massive data and structure changes to > one of our databases.

Re: [GENERAL] help with error "unexpected pageaddr"

Shouldn't have, the only thing we did to the server was restart it and run our database queries. Clearing out all the wal files from pg_xlog along with a new base backup did fix it though. Thanks for the help Tom! Scot Kreienkamp skre...@la-z-boy.com -- Sent via pgsql-general mailing

Re: [GENERAL] pg_dump native format will not restore correctly

05, 2009 at 10:41:54AM -0500, Scot Kreienkamp wrote: > Here's the query in the sandbox: > psql -U postgres -d rms-prod -c "explain select * from soldtrx" > QUERY PLAN > &g

Re: [GENERAL] pg_dump native format will not restore correctly

file to psql for the restore. My native format restore I'm simply restoring from last nights native format backup of the database and using the schema only switch to pg_restore. Not sure if that makes the difference or not. Thanks for the help in trying to figure this out. I'm still look

[GENERAL] autovacuum question

so all I really need is an analyze --I think--. I'm on 8.3.7. Since 8.3.10 is due out I'll probably upgrade to it after it's shaken out a bit. Thanks for your help. Any suggestions are welcome. Scot Kreienkamp skre...@la-z-boy.com -- Sent via pgsql-general mailing list (pg

Re: [GENERAL] autovacuum question

On Mon, Mar 8, 2010 at 5:13 PM, Scot Kreienkamp wrote: Hi everyone, I have a database that is constantly getting reloaded several times per day from production backups and is used for reporting purposes. The problem I'm having with it is that the database seems to be much slower tha

Re: [GENERAL] autovacuum question

nd restart only takes 1-2 minutes right now. If you have any other ideas how I can accomplish or improve this I'm all ears. Thanks, Scot Kreienkamp skre...@la-z-boy.com -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Monday, March 08, 2010 10:32 PM To:

Re: [GENERAL] autovacuum question

I'm gonna take a scientific wild-assed guess that the real issue here is caching, or more specifically, lack thereof when you first start up your copy of the db. [Scot Kreienkamp] That is definitely one of the problems. No way to help that that I'm aware of. -- Sent via pgs

Re: [GENERAL] autovacuum question

ISTM that 9.0's read-only standby feature may be of use to you. I know it doesn't help you *today* but have you looked at it yet? Okay, so the RO database won't work. How much data are we talking? How much growth do you see between snapshots? The initial database size is 31 gigs.

Re: [GENERAL] autovacuum question

Would the stats come across in WAL log shipping to a physically separate server? My understanding is that they won't. Thanks, Scot Kreienkamp skre...@la-z-boy.com -Original Message- From: gsst...@gmail.com [mailto:gsst...@gmail.com] On Behalf Of Greg Stark Sent: Tuesday, Mar

Re: [GENERAL] autovacuum question

ISTM that 9.0's read-only standby feature may be of use to you. I know it doesn't help you *today* but have you looked at it yet? [Scot Kreienkamp] I had considered it and it will make my life easier for my reporting server, but unfortunately in this case I need a read-write copy.

[GENERAL] initdb with lc-collate=C

7;t it stick setting it server-wide with initdb? Thanks! Scot Kreienkamp Senior Systems Engineer skre...@la-z-boy.com This message is intended only for the individual or entity to which it is addressed. It may contain privileged, confidential information which is exempt from disclosure under a

Re: [GENERAL] initdb with lc-collate=C

. Scot Kreienkamp Senior Systems Engineer skre...@la-z-boy.com -Original Message- From: Adrian Klaver [mailto:adrian.kla...@gmail.com] Sent: Monday, December 12, 2011 3:26 PM To: Scot Kreienkamp Cc: Postgres General (pgsql-general@postgresql.org) Subject: Re: [GENERAL] initdb with lc-collate

Re: [GENERAL] initdb with lc-collate=C

rvice: [ OK ] Scot Kreienkamp Senior Systems Engineer skre...@la-z-boy.com -Original Message- From: Adrian Klaver [mailto:adrian.kla...@gmail.com] Sent: Monday, December 12, 2011 3:56 PM To: Scot Kreienkamp Cc: Postgres General (pgsql-general@postgresql.org) Subject: Re: [GE

Re: [GENERAL] initdb with lc-collate=C

I didn't catch the error message before it rolled off the screen. The initdb on the initscript used to honor the extra switches. That's how I've been doing it since 8.2. I'll run it with SU from now on. Thanks! Scot Kreienkamp Senior Systems Engineer skre...@la-z-boy.co

[GENERAL] list blocking queries

ed/blocking PID's doesn't work on 9.1 or if it's the way I'm testing it. That query is a bit above my head for now as I'm only a part time DBA at my job. Thank you for any insights you can give me. BTW, the streaming replication and hot standby on 9.1 rocks!!! Than

Re: [GENERAL] list blocking queries

g something in one of the joins. Thanks! Scot Kreienkamp Senior Systems Engineer skre...@la-z-boy.com -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Monday, January 30, 2012 9:49 PM To: Scot Kreienkamp Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] list b

Re: [GENERAL] Vacuum problems

er except maybe once or twice per year. I'll try adding a reindex for tonight's vacuum run. Thanks, Scot Kreienkamp La-Z-Boy Inc. skre...@la-z-boy.com -Original Message- From: Scott Marlowe [mailto:scott.marl...@gmail.com] Sent: Monday, January 05, 2009 11:35 AM To: Sco

[GENERAL] Vacuum problems

oon as possible, but I need to get this figured out first unless it's a bug that the upgrade fixes. I'd appreciate any advice or explanations you guys can send my way. Thanks, Scot Kreienkamp La-Z-Boy Inc. skre...@la-z-boy.com 734-242-1444 ext 6379

Re: [GENERAL] Vacuum problems

Nothing. I ran a query to see what other queries were running and what other locks existed at the time. No queries running, no locks. Nothing running at that time of night except dump, which is finished before the vacuum job starts. Thanks, Scot Kreienkamp La-Z-Boy Inc. skre...@la-z-boy.com

Re: [GENERAL] Vacuum problems

Nope, on RHEL5. This is the backend of an application that's not available or visible to the public. Thanks, Scot Kreienkamp La-Z-Boy Inc. skre...@la-z-boy.com 734-242-1444 ext 6379 -Original Message- From: Grzegorz Jaśkiewicz [mailto:gryz...@gmail.com] Sent: Monday, Janua

Re: [GENERAL] Vacuum problems

rms-prod" I get this: ERROR: syntax error at or near "-" LINE 1: REINDEX SYSTEM rms-prod The user tables run fine. Should I reindex the system tables also? If so, how do I get around the dash in the db name? Thanks, Scot Kreienkamp La-Z-Boy Inc. skre...@la-z-boy.com 734-

Re: [GENERAL] Vacuum problems

Yep... dummy me. That works. I tried that before with the reindexdb command, that doesn't work. I didn't try it with the psql command. Thanks, Scot Kreienkamp La-Z-Boy Inc. skre...@la-z-boy.com -Original Message- From: Adrian Klaver [mailto:akla...@comcast.net] Sen

Re: [GENERAL] Warm Standby question

tabase. Thanks, Scot Kreienkamp La-Z-Boy Inc. skre...@la-z-boy.com 734-242-1444 ext 6379 -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Thomas Kellerer Sent: Sunday, February 01, 2009 7:47 AM To: pgsql-general@postgre

Re: [GENERAL] Postgres with phpScheduleIt

nt version; the database usage is fairly simple. The setup script never did work properly though. Still using phpscheduleit with Postgres 8.3, I haven't touched it since I built it some months ago. Thanks, Scot Kreienkamp La-Z-Boy Inc. skre...@la-z-boy.com 734-242-1444 ext 6379 -

Re: [GENERAL] Postgres Clustering

my constraints. Thanks, Scot Kreienkamp -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Alan McKay Sent: Wednesday, May 27, 2009 1:57 PM To: pgsql-performa...@postgresql.org; pgsql-general@postgresql.org Subject: [GE