[ADMIN] 8.4 process killed- what sort of recovery options do I have?

, what's the best way to track down the reason for the crash? Just get into /var/log/postgresql and poke around? Thanks. -- Wells Oliver Developer, Baseball Systems San Diego Padres | 100 Park Boulevard | San Diego CA 92101 619-795-5359

[ADMIN] Logging questions

over the logging options in the documentation and they are legion. What are my key options to reduce logging to the lowest, most vital sort of messages? Thanks for tips! -- Wells Oliver Developer, Baseball Systems San Diego Padres | 100 Park Boulevard | San Diego CA 92101

[ADMIN] Dump/restore casts

? Thanks. -- Wells Oliver wellsoli...@gmail.com

[ADMIN] Server crash... trying to figure it out

to 6GB, work_mem is 64MB, maintenance_work_mem is 128MB, effective_cache_size is 4GB. max_connections is set to 200. Any ideas here? The system has 12GB; raising the shared_buffers seems reasonable but 6GB also feels like it should be sufficient. Any thoughts appreciated. Thanks! -- Wells

Re: [ADMIN] Server crash... trying to figure it out

food for thought. Do you have any recommendations on a pg connection pooler? -- Wells Oliver Architect, Baseball Systems 619-795-5359 San Diego Padres | 100 Park Boulevard | San Diego CA 92101 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription

[ADMIN] Unique operator error w/ concatenation

explicit type casts. But on another postgres 8.4 server, it properly returns a concatenated string. Any tips on how/where I can track down why/where there might be duplicate operators? -- Wells Oliver Architect, Baseball Systems 619-795-5359 San Diego Padres | 100 Park Boulevard | San Diego CA

[ADMIN] Setting up streaming replication w/ a big ole database

everything? I could also do a pg_restore to the new slave from last night's DB backup, but I understand (at least, I seem to read it) that you can't bring a slave up using pg_restore. Are there any other options I am missing? Thanks for any tips. -- Wells Oliver wellsoli...@gmail.com

Re: [ADMIN] Setting up streaming replication w/ a big ole database

I admit to being scared as crap of rsync'ing a live database to another server. Like chills are running down my spine even typing it. Is this an approved, safe thing? On Tue, Apr 10, 2012 at 11:38 AM, Scott Marlowe scott.marl...@gmail.comwrote: On Tue, Apr 10, 2012 at 12:34 PM, Wells Oliver

[ADMIN] Writing to a database or schema on a slave

Hey everyone. I'd like to create a schema on my slave so that users who do not have access to the master can create some data. Clearly this data won't be replicated, since it's on the slave, but will it cause any problems w/ data integrity to have it on the slave? -- Wells Oliver wellsoli

Re: [ADMIN] Writing to a database or schema on a slave

I am using the WAL method w/ 9.1. On Tue, Apr 10, 2012 at 4:29 PM, Kevin Grittner kevin.gritt...@wicourts.gov wrote: Wells Oliver wellsoli...@gmail.com wrote: I'd like to create a schema on my slave so that users who do not have access to the master can create some data. Clearly this data

[ADMIN] Recovery mode for a WAL-based slave

Is the server perpetually in recovery mode? Looking at PGAdmin, in recovery? is yes, but replay location is the same as receive location, and the data is absolutely up to date. Is the recovery bit an issue, or just SOP? Thanks. -- Wells Oliver wellsoli...@gmail.com

[ADMIN] Definitive logrotate solution?

. -- Wells Oliver wellsoli...@gmail.com

Re: [ADMIN] Definitive logrotate solution?

How do you ensure you're not keeping logs from 35+ days ago, or whatever? Just a find -mtime +10 -exec rm {}\; kind of thing? On Wed, Apr 11, 2012 at 4:03 PM, Tom Lane t...@sss.pgh.pa.us wrote: Wells Oliver wellsoli...@gmail.com writes: Might anyone share theirs? My log_rotation is set

[ADMIN] Changing max_connections after WAL slave configured not allowed?

, it _was_ 200 but now it's definitely 100. Is there a reason this change cannot be made now? -- Wells Oliver wellsoli...@gmail.com

[ADMIN] Trouble w/ COPY command

this? There are properly quoted string values elsewhere in the final, so I'm reticent to strip out double quote characters or anything. Thank you. -- Wells Oliver wellsoli...@gmail.com

[ADMIN] Getting that starts a week of the year

Is there a way to get the date that starts week 14, or 15 (etc)? -- Wells Oliver wellsoli...@gmail.com

[ADMIN] Calling a plpgsql function with an array of results?

Trying to call my function like so: select myschema.myfunction(select myid from mytable); myfunction has the signature: myfunction(integer[]) myid is an integer; I am trying to select them as an array to pass to the function. Where am I going wrong? Thanks! -- Wells Oliver wellsoli

[ADMIN]

-- Wells Oliver wellsoli...@gmail.com

[ADMIN] Massive insert created 975 WAL segments.. what?

/postgresql-logs/%f' max_wal_senders = 3 wal_keep_segments = 16 So, now I have 16GB of WAL segments, 974 of them. Will postgresql clean this up? Will it remove these files? Will it create more with big inserts? What is the best way to manage this? -- Wells Oliver wellsoli...@gmail.com

[ADMIN] Upgrading from 9.1 to 9.2 in place, same machine

, then switch it over. Is there a better idea? Thanks for any tips. -- Wells Oliver wellsoli...@gmail.com

Re: [ADMIN] Upgrading from 9.1 to 9.2 in place, same machine

. My original idea was to make 9.2 a slave of 9.1, then switch it over. Is there a better idea? Thanks for any tips. have you looked at simply using pg_upgrade ? http://www.postgresql.org/docs/9.2/static/pgupgrade.html -- Wells Oliver wellsoli...@gmail.com -- Sent via pgsql

Re: [ADMIN] Upgrading from 9.1 to 9.2 in place, same machine

to 9.2. It took all of 10 minutes to complete, which didn't count for running the analyze afterward. However, if you are going to run the analyze DB afterward, your mileage may vary. On Wed, Jul 10, 2013 at 11:52 AM, Wells Oliver wellsoli...@gmail.comwrote: Can anyone speak to the speed

Re: [ADMIN] Upgrading from 9.1 to 9.2 in place, same machine

, Wells Oliver wrote: Hard linking means that you must maintain 8.2's data directory though, even after upgrade, correct? Since it's a link and not a copied file. I think it only hard links the files to the new 9.2 data directory so you can delete the old data directory and the files

[ADMIN] Upgrading from 9.1 to 9.2 - master AND slave

that the WAL is still being created and the master/slave relationship properly maintained? Thanks. -- Wells Oliver wellsoli...@gmail.com

[ADMIN] Building an extension for a different version of Postgres

I have 9.1 and 9.2 installed, and I am trying to build the PLR extension: http://www.joeconway.com/plr/doc/plr-install.html I'm using the USE_PGXS=1 method. But it's building for 9.1: gcc -I/usr/include/postgresql/9.1/server ... I want to build for 9.2. How can I do this? -- Wells

Re: [ADMIN] Building an extension for a different version of Postgres

What is the proper way to repoint pg_config? I'm on Ubuntu Server, so it's in /usr/bin/pg_config, which references 9.1. On Thu, Jul 11, 2013 at 10:52 AM, Raghavendra raghavendra@enterprisedb.com wrote: On Thu, Jul 11, 2013 at 11:14 PM, Wells Oliver wellsoli...@gmail.comwrote: I have 9.1

[ADMIN] Creating new cluster by copying directory?

Is this viable? If not, is there another way to create a duplicate cluster in a timely fashion? -- Wells Oliver wellsoli...@gmail.com

Re: [ADMIN] Creating new cluster by copying directory?

-- Wells Oliver wellsoli...@gmail.com

[ADMIN] Couldn't start postgres, got no logging, ran postgres manually for info-- help?

? It would have saved me a lot of time. -- Wells Oliver wellsoli...@gmail.com

[ADMIN] pg_upgrade (9.1 to 9.2) bombing on casts

? -- Wells Oliver wellsoli...@gmail.com

Re: [ADMIN] Couldn't start postgres, got no logging, ran postgres manually for info-- help?

been helpful to have that from the start. -- Wells Oliver wellsoli...@gmail.com On Jul 12, 2013, at 2:23 AM, Giuseppe Broccolo giuseppe.brocc...@2ndquadrant.it wrote: Hi Oliver, Il 12/07/2013 04:07, Wells Oliver ha scritto: I ran: pg_ctlcluster 9.1 main start Received