Re: [ADMIN] Postgres shared memory error

On 04/28/2012 10:32 AM, Fernando Hevia wrote: On Sat, Apr 28, 2012 at 13:10, Kevin Kempter mailto:cs_...@consistentstate.com>> wrote: All; I just want to be sure that I'm not causing myself greif. I have a kvm in the cloud that is supposed to have access to

[ADMIN] Postgres shared memory error

All; I just want to be sure that I'm not causing myself greif. I have a kvm in the cloud that is supposed to have access to 32GB of ram. when I do a top I only see 1GB of ram, I've pinged the hosting provider, maybe it shows up as it's used? Anyway when I try and start postgres I see this:

Re: [ADMIN] psql: could not connect to server: No route to host

On 04/25/2012 10:50 PM, Tom Lane wrote: Kevin Kempter writes: I can scp files between the servers Really? $ psql -h 192.168.1.125 psql: could not connect to server: No route to host Because that is not a Postgres problem, that is a network connectivity problem. I'd bet that th

[ADMIN] psql: could not connect to server: No route to host

Hi all; I've setup PostgreSQL to talk across servers thousand of times... not sure what I'm doing wrong, maybe I'm just over-tired. I have 2 scientific linux VM's running in vmware workstation server 1 - 192.168.1.125 server 2 - 192.168.1.127 I've disabled selinux on both servers Ive insta

Re: [ADMIN] dropping constraints

] > Kevin Kempter writes: > > we have a few not null constraints we want to drop on very large tables. > > Unfortunately the drop's are taking hours. Is there a way to drop a not > > null constraint via the system catalogs? > > Dropping a NOT NULL constraint is a

[ADMIN] dropping constraints

Hi All; we have a few not null constraints we want to drop on very large tables. Unfortunately the drop's are taking hours. Is there a way to drop a not null constraint via the system catalogs? Thanks in advance -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes

[ADMIN] Postgresql 8.3 on OSX hangs

Hi all; we have a client experiencing the following scenario: - Postgresql 8.3.10 plus postgis 1.5.1 - Both databases stop responding to queries and several of the backend processes show as being in an uninterruptible state (state "Us" according to a ps aux) - The client killed the processes

[ADMIN] Error: missing chunk number for toast value

Hi All; We're seeing this error in our 8.3.9 database: # select * from comments; ERROR: missing chunk number 0 for toast value 1274882 in pg_toast_49234 I tried this: # reindex table pg_toast.pg_toast_49234; REINDEX but the error still persists. Thoughts? -- Sent via pgsql-admin mailing

[ADMIN] Partitioned table system info

Hi All; can anyone point me to a system catalog query that will show me the base table name, and all partition table names for any table that has children (inheritance) ? Thanks in advance -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription:

[ADMIN] insert OS command results into a table on a remote system ?

Hi All; I want to gather OS command based stats such as the results of commands like: 'df' 'iostat' 'free' etc and put the results into a temp table that I can then select from. I need to do this all from the db since I wont have OS/shell access, only 'psql -h' access. Is this possible? Ca

Re: [ADMIN] pg_dump errors

On Thursday 03 June 2010 11:45, Tom Lane wrote: > Kevin Kempter writes: > > On Thursday 03 June 2010 11:18, Tom Lane wrote: > >> Bizarre ... that command really oughtn't be invoking any non-builtin > >> operator, but the OID is too high for a builtin. What do

Re: [ADMIN] pg_dump errors

On Thursday 03 June 2010 11:18, Tom Lane wrote: > Kevin Kempter writes: > > pg_dump: Error message from server: ERROR: could not find hash function > > for hash operator 33639 > > Bizarre ... that command really oughtn't be invoking any non-builtin > operator,

[ADMIN] pg_dump errors

Hi all; I'm seeing these errors when running a pg_dump of the postgres database: Running: [pg_dump --schema-only postgres > postgres.ddl] pg_dump: SQL command failed pg_dump: Error message from server: ERROR: could not find hash function for hash operator 33639 pg_dump: The command was: SELECT

[ADMIN] default isolation level per user?

Hi all; is it possible to specify a default isolation level for a user/role ? Thanks in advance... -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Using Postgresql Replication

On Friday 19 February 2010 06:27:10 Brad Nicholson wrote: > On Fri, 2010-02-19 at 05:49 -0500, Manasi Save wrote: > > Hi All, > > > > > > I am very new to Postgres in that I have to setup replication. For > > Which I am very confused between Postgres's replication types. > > > > I want a sychronize

[ADMIN] "effective_io_concurrency" cannot be changed error when starting 8.4.2 instance

Hi All; I get the below error when trying to start an 8.4.2 instance Anyone know what might be causing this? FATAL: parameter "effective_io_concurrency" cannot be changed Thanks in advance -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription

[ADMIN] query to list all user tables and related constraints

Hi All; anyone have a query that will list all user tables and their related constraints (i.e. for each table list any FK's for and any tables/columns that reference the table) Thanks in advance. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your

[ADMIN] last insert/update for a table

Hi all; is there a system catalog query or function that will show me the last time an insert or update occurred for a specified table ? Thanks in advance -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [ADMIN] dupes for PK and other UNIQUE indexes

On Sunday 01 November 2009 16:25:58 Tom Lane wrote: > Kevin Kempter writes: > > On Sunday 01 November 2009 15:50:20 you wrote: > >> Kevin Kempter writes: > >>> Anyone have any Idea how this could happen? > >> > >> Corrupt indexes. What PG ver

[ADMIN] dupes for PK and other UNIQUE indexes

Hi all; I have a client with a table which has an exeedingly large amount of bloat, so we plan to rebuild the table. However in setting up a test box I've found that both the PK and another UNIQUE index column have duplicate values. In theory the INDEX/PK should refuse to build if dupes exist

[ADMIN] select actual data size for a relation?

Hi all; Anyone know how to select / calculate the actual data size for a table or index? NOT the disk usage as in: pg_class.relpages -- shows disk usage including bloat pg_relation_size() -- same as pg_class.relpages but in bytes or pg_total_relation_size() -- total disk usage inclusive of b

[ADMIN] drop table error

Hi all; anyone know what would cause errors like this (postgres version 8.1.15): drop table bigtab1; ERROR: could not find tuple for constraint 373617 drop sequence bigtab2_id_seq;

[ADMIN] munin plugin for bloat

Hi all; I have an sql query I like to run that shows the top 10 bloated tables. I'm wanting to turn it into a munin graph however the issue is that the list of tables (the top 10) are not constant which seems to indicate that I need something more dynamic than what's available as a standard mu

[ADMIN] sql to show tablespace for indexes

Hi all; How / where can I find which tablespace the indexes live in? Thanks in advance -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] cannot read block errors !

On Wednesday 09 September 2009 12:22:29 Tom Lane wrote: > Kevin Kempter writes: > > we're getting these errors on our system today: > > > > Sep 9 00:53:45 ux-rqs04-atl2 ri_load[5846]: Caught Exception! > > Shutting down: ERROR: could not read block 703769 o

[ADMIN] cannot read block errors !

Hi All; we're getting these errors on our system today: Sep 9 00:53:45 ux-rqs04-atl2 ri_load[5846]: Caught Exception! Shutting down: ERROR: could not read block 703769 of relation 37698/17627/38565: Input/output error CONTEXT: SQL statement "SELECT 1 FROM ONLY "our_schema"."big_table" x WH

[ADMIN] partitioning and set statistics

If I want to set the statistics target for a column in a partitioned table to a higher value, say 250, do I need to alter each partition? or can I just alter the base table (and the partitions will inherit the change)? Thanks in advance -- Sent via pgsql-admin mailing list (pgsql-admin@postgr

Re: [ADMIN] server disk space

ally large > pg_toast_4643492 index... > > (I'm using this to find out which are the largest relations: > SELECT relname, reltuples, relpages FROM pg_class ORDER BY relpages DESC;) > > How do I force a reindex hitting just that pg_toast_ relation? > > 2009/9/6 Kevin Kemp

Re: [ADMIN] server disk space

On Sunday 06 September 2009 00:05:04 Brian Modra wrote: > Hi, > I'm maintaining a fairly large online database, and am trying to free > up disk space. Its got to 98% full. > I am certain that the postgresql data files are responsible for more > than 97% of this partition's usage. > The WAL logs for

[ADMIN] pg_tblspc links question

Hi all; I'm moving a db install from one server to another. the source box had 2 tablespaces and I see this in the pg_tblspc dir: lrwxrwxrwx 1 postgres postgres 20 2009-08-10 19:23 17261 -> /san_B/pwreport_3000 lrwxrwxrwx 1 postgres postgres 20 2009-08-11 17:20 17625 -> /san_A/pwreport_1000 lr

[ADMIN] help tuning query

Hi all; we've been fighting this query for a few days now. we bumped up the statistict target for the a.id , c.url_hits_id and the b.id columns below to 250 and ran an analyze on the relevant tables. we killed it after 8hrs. Any suggestions? $ psql -ef expl.sql pwreport

[ADMIN] vacuum full questions

I'm running a vacuum full on a table due to excessive updates/deletes. It's been running for more than an hour (it's about 3Gig in size) 2 questions: 1) is there any way to gain some visibility per the progress of the vacuum full 2) can I safely kill the vacuum full and do a dump, drop table,

Re: [ADMIN] vacuum question

On Tuesday 18 August 2009 13:37:12 Tom Lane wrote: > Kevin Kempter writes: > > INFO: "action_rollup_notifier": found 0 removable, 34391214 nonremovable > > row versions in 152175 pages > > DETAIL: 22424476 dead row versions cannot be removed yet. > > > >

[ADMIN] vacuum question

Hi all; we have a large table that gets a lot of churn throughout the day. performance has dropped off a cliff. A vacuum verbose on the table showed us this: INFO: "action_rollup_notifier": found 0 removable, 34391214 nonremovable row versions in 152175 pages DETAIL: 22424476 dead row vers

[ADMIN] insert a backslash into a bytea field?

Hi all; we want to insert a single backslash into a bytea column (running postgres v 8.3.5) this works to insert 2 backslashes (but we only want one): insert into test_bytea_tab (id, bytea_test_col) values(99, 'testdata'::bytea) However none of these work: insert into test_bytea_tab (

Re: [ADMIN] replay WAL segments without a "base backup" ?

On Tuesday 11 August 2009 09:49:14 Tom Lane wrote: > Kevin Kempter writes: > > due to operator error at one of my client sites we're trying to restore a > > deleted db. > > > > We did a restore with a pgdump that went fine but the dump is 3weeks old. > > th

[ADMIN] replay WAL segments without a "base backup" ?

Hi all; due to operator error at one of my client sites we're trying to restore a deleted db. We did a restore with a pgdump that went fine but the dump is 3weeks old. they do have WAL segments and they claim that the WAL segments are exactly in line with the needed transactions - from a timin

[ADMIN] force varchar column to be lowercase

Can I use a check constraint, or something other than a function to force a column to be lowercase only? Thx in advance -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] pg_stat_activity reporting of VACUUM in 8.1

Hi all; looking at a system running 8.1.15 via a select from pg_stat_activity I see a row where the vcurrent_query = 'VACUUM' I see also that autovacuum is on. Would autovacuum be running a vacuum on the entire db? I didn't think autovacuum did that. If not, how do I know in version 8.1 what t

Re: [ADMIN] Cannot connect to postgresql

On Tuesday 21 July 2009 10:35:46 Carol Walter wrote: > Hello, > > I emailed to the group last week about being able to access one of my > postgres databases from other machines on my network. I thought the > problem was a installation of 8.2.10 that I had been testing an > upgrade on had clobbered

[ADMIN] convert an Insert Into... select from... to use COPY ?

Hi All; I have an sql stmt that runs: insert into x ( a.col1, a.col2, a.col3,b.col1,b.col2) select blah,blah,blah ... from giant_table a, even_bigger_table b where. I wonder, could I convert this to use COPY into the table (x) instead of the select stmt? Thanks in advance -- Se

[ADMIN] how much memory (work_mem) is a query using?

Hi all; is it possible to see how much work_mem memory a particular session is using? -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] vacuum tx id wraparound issues

On Thursday 25 June 2009 10:08:16 Greg Stark wrote: > On Thu, Jun 25, 2009 at 4:39 PM, Kevin > > Kempter wrote: > > we're inserting an average of 70-100 rows per second into these tables. > > Hm. And every row is a separate transaction? That's still only a few >

Re: [ADMIN] vacuum tx id wraparound issues

On Thursday 25 June 2009 08:25:53 Tom Lane wrote: > Kevin Kempter writes: > > I'm seeing a number of vacuum's in one of our db's that has a notation > > (to prevent wraparound). > > This is a normal condition. There isn't anything you can do that will &

[ADMIN] vacuum tx id wraparound issues

Hi all; I'm seeing a number of vacuum's in one of our db's that has a notation (to prevent wraparound). I've tried a number of things to fix it. last nite during the off hours we ran a "vacuumdb -a" The vacuumdb did vacuum every db in the cluster but I'm still seeing the vacuums to prevent w

[ADMIN] Connection Issue

Hi all; I cannot connect to a postgres (8.3) cluster locally (via ssh onto the server). The postgresql.conf file has this: # - Connection Settings - listen_addresses = '*' #listen_addresses = '0.0.0.0' # what IP address(es) to listen on; # comma-separated list of addr

[ADMIN] HW recommendatons

So, if price were not an option and you had a system that needed to average 10K+ inserts per second what HW would you recommend? (Obviously there's mega architectural issues here) Server? (Dell PowerEdge 905? , HP Proliant DL700?) Direct Attached Storage: (Dell MD3000? HP MSA70?) RAID/Storage

[ADMIN] Security question UNIX Sockets vs CIDR style access

Hi All; I'm looking for thoughts/feedback on the use of UNIX Sockets vs standard CIDR style access (i,e, Ident, MD5, etc) to a Postgres Cluster. What are the pros/cons, which is more secure and why, etc... Thanks in advance

Re: [ADMIN] User table porting

On Tuesday 10 March 2009 11:13:54 Carol Walter wrote: > I want to recreate users with their passwords from one database > cluster on another database cluster. What would be the best way for > me to do this? > > Thanks, > Carol from the "old" server run this (where is the new server): pg_dumpal

[ADMIN] triggers on system tables ?

Hi All; Is it possible to add triggers to system catalog and/or statistics collector tables ? Thanks in advance -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] pg_buffercache - usagecount info

Hi All; Can someone point me in the direction of more info per the usagecount value in the pg_buffercache view, or send me a description beyond "Page LRU count" There's no README in my postgresql-8.3.5/contrib/pg_buffercache dir and I've found nothing more in the online manual. Thanks in adva

[ADMIN] check to see when tables were last vacummed

Hi all; Anyone know where to look to see when tables were last vacuumed via autovacuum ? Also, can I run this check only in 8.3+ or did it work also in 8.2, 8.1 ? Thanks in advance -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://

[ADMIN] query to find out # of buffer hits vs. # of disk reads ?

Hi all; Anyone know what system catalogs I need to query to find out # of disk reads and # of memory / buffercache reads ? Thanks in advance -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] vacuum monitoring question

On Wednesday 24 December 2008 09:56:29 Scott Marlowe wrote: > On Wed, Dec 24, 2008 at 9:31 AM, Kevin Kempter > > wrote: > > Hi All; > > > > I'm working on a vacuum monitor script to alert us when tables start to > > grow out of control per dead space. Initi

[ADMIN] vacuum monitoring question

Hi All; I'm working on a vacuum monitor script to alert us when tables start to grow out of control per dead space. Initially I excluded the system catalog schemas (pg_catalog, pg_toast, etc) however I wonder if maybe I should monitor these as well. PLus I'm looking for any input as to specific

[ADMIN] Logging autovacuum

Hi All; I wonder is there a way to force autovacuum events to be logged to the postgres log ? Thanks in advance -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] 'invalid command \N' during restore from pg_dump

On Oct 17, 2008, at 3:20 PM, Jan-Peter Seifert wrote: Hello, kevin kempter wrote: I'm trying to run a restore from a pg_dump and I get loads of these: invalid command \N I see lots of \N char's in the data for some of the tables (NULL's ?) Are you using pgAdmin&#

[ADMIN] 'invalid command \N' during restore from pg_dump

Hi all; I'm trying to run a restore from a pg_dump and I get loads of these: invalid command \N I see lots of \N char's in the data for some of the tables (NULL's ?) Thoughts? Thanks in advance -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscri

[ADMIN] Select all table column names for a specified tablename (per the system catalogs)

Hi List; I want to pull the list of column names from the system catalogs for a specified table. I only want column names, I want to exclude any index names, or other non-column name rows. I got this far (see below) however this query produces additional rows with attname's like tableoid

Re: [ADMIN] Errors installing contrib

On Sep 19, 2008, at 4:18 PM, Jeff Frost wrote: kevin kempter wrote: ok so I have more info. a pg_config --libdir shows me /usr/lib64 however the make install installs the pg_buffercache in /pgmoveable/ lib/postgresql How was postgresql installed on the machine in the first place

Re: [ADMIN] Errors installing contrib

ok so I have more info. a pg_config --libdir shows me /usr/lib64 however the make install installs the pg_buffercache in /pgmoveable/ lib/postgresql Thoughts ? On Sep 19, 2008, at 3:51 PM, kevin kempter wrote: Hi All; I've gone into contribs/pg_buffercache and run this: mak

[ADMIN] Errors installing contrib

Hi All; I've gone into contribs/pg_buffercache and run this: make (as postgres) make install (as root) psql -f pg_buffercache.sql when I run the psql command against my database I get this: BEGIN SET psql:pg_buffercache.sql:9: ERROR: could not access file "$libdir/ pg_buffercache": No such

[ADMIN] Setting Effective Cache Size

Hi All; Is there an easy way to determine the actual OS disk cache size or at least a set of guidelines based on the OS and disk subsystem type ? Thanks in advance... /Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.

Re: [ADMIN] shared_buffers setting

Thanks ! On Sep 15, 2008, at 7:10 PM, Tom Lane wrote: kevin kempter <[EMAIL PROTECTED]> writes: I'm unclear per the docs what the effect is of specifying a shared buffers value without a kB or an MB at the end. For example if I specify shared buffers as: shared_buffers = 5000

[ADMIN] shared_buffers setting

Hi All; I'm unclear per the docs what the effect is of specifying a shared buffers value without a kB or an MB at the end. For example if I specify shared buffers as: shared_buffers = 5000 would this equate to 5000 8K pages, or 5000K, 5000bytes? I usually specify the buffers in MB but I w

[ADMIN] Triggers & BLOB's

Hi All; Can I put an update/insert/delete trigger on a BLOB (lo_* style) column, It looks like the trigger should actually live on the data column of the pg_largeobject table to be effective. Is this correct ? Thanks in advance... -- Sent via pgsql-admin mailing list (pgsql-admin@postgres

[ADMIN] exporting/importing BLOB's (lo_* style)

Hi All; I want to dump a set of BLOB's from one db/server and import to another. I assume I cannot do a pg_dump unless I also dump related pg_largeobject rows for the referenced OID I assume I'll need to export via distinct lo_export commands and use lo_import to insert into the second dat

Re: [ADMIN] Dupes inserted that violate the PK

appened, I think the rule needs to be that we only execute a failover based on bringing the master down as opposed to simply creating the trigger file. I'm trying to test this theory out now - I'll update the list with my findings. /Kevin On Jul 8, 2008, at 10:52 AM, Alvaro He

[ADMIN] Dupes inserted that violate the PK

Hi All; Sorry f this is a duplicate post, my first post from yesterday never showed up. we have a table that has a PK as follows: CREATE TABLE btx ( id integer NOT NULL, url character varying(256) NOT NULL, "password" character varying(50), btx_counter integer, ... size do

[ADMIN] strange drop errors

Hi List; in trying to drop an index I get this: # drop index sl_pf_fact_tmp11_ep_idx11; ERROR: could not open relation with OID 3666815 I even dropped the associated table and still get this error. Likewise we cannot create an index with the same name. Thoughts ? -- Sent via pgsql-admi

Re: [ADMIN] pg_tables query issue

OK. Thanks for the info. On Jun 30, 2008, at 5:48 PM, Stephan Szabo wrote: I've found that if I run this select (below) I get a table returned named 'dma' een though I specified like 'dm_%' : Underscore is a special character for like matching any single character so I don't think that'

[ADMIN] pg_tables query issue

Hi List; I've found that if I run this select (below) I get a table returned named 'dma' een though I specified like 'dm_%' : select tablename from pg_tables where tablename like 'dm_%'; tablename -- dm_service_provider_dim dma Am I missing somethi

Re: [ADMIN] select current UTC time ? (SOLVED)

On Jun 5, 2008, at 1:01 PM, kevin kempter wrote: Hi List; How could I select the current UTC time ? now() cast as a timestamp at UTC is wrong because it takes now() and says: if it were now() time UTC what would it be here (timezone) and returns that. I want to return 'what time

[ADMIN] select current UTC time ?

Hi List; How could I select the current UTC time ? now() cast as a timestamp at UTC is wrong because it takes now() and says: if it were now() time UTC what would it be here (timezone) and returns that. I want to return 'what time is it now in UTC ?' Thanks in advance... /Kevin -- Sen

[ADMIN] postgres, syslog and freeBSD

Hi list; I'm trying to get postgres & syslog to get along with no luck. I'm running freeBSD7 and postgres 8.3.1 Here's my postgres setup log_destination = 'syslog' #logging_collector = off syslog_facility = 'LOCAL0' syslog_ident = 'postgres' silent_mode = on log_min_duration_statement = 0

Re: [ADMIN] insert a -1 into a bigint ?

wow, good catch. Thanks for taking the time to look. On May 20, 2008, at 1:22 PM, Shane Ambler wrote: kevin kempter wrote: Hi All: I want to insert some data along with a -1 for two of the bigint columns. like this: insert into seg_id_tmp7 ( customer_srcid, show_srcid

Re: [ADMIN] insert a -1 into a bigint ?

I forgot to mention - I'm running version 8.3.1 On May 20, 2008, at 12:14 PM, kevin kempter wrote: Hi All: I have this table: # \d seg_id_tmp7 Table "public.seg_id_tmp7" Column |Type

[ADMIN] insert a -1 into a bigint ?

Hi All: I have this table: # \d seg_id_tmp7 Table "public.seg_id_tmp7" Column |Type | Modifiers -+-+--- customer_srcid | bigint | show_srcid | bigint

[ADMIN] Global / cluster-wide functions

Hi List; Can I install a PL/pgSQL function so it's global to all databases within a cluster or do I need to install per database ? Thanks in advance -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgs

Re: [ADMIN] Deadlocks ?

On May 13, 2008, at 5:00 PM, Tom Lane wrote: Tino Schwarze <[EMAIL PROTECTED]> writes: On Tue, May 13, 2008 at 01:18:24PM -0600, kevin kempter wrote: ProgrammingError: deadlock detected DETAIL: Process 23098 waits for ShareUpdateExclusiveLock on relation 428126 of database 427376; bloc

[ADMIN] Deadlocks ?

Hi All; we seem to be getting deadlock quite a lot. We have a python process that does the following and we keep getting deadlocks. Is this a real deadlock or maybe a wait condition? Any help in debugging / resolving this would be much appreciated. Thanks in advance cursor.execute("

[ADMIN] warm standby issues

Hi List; I'm setting up a warm standby server on version 8.1.9 I setup a recovery.sh script to keep the standby cluster in recovery mode waiting for the next WAL segment. everything works fine as long as the standby server is in recovery mode. I see the recovery taking place in the postg

Re: [ADMIN] weird network issue

wherereject- with icmp-ho st-prohibited [EMAIL PROTECTED] ~]# On Mar 28, 2008, at 11:45 AM, Shane Ambler wrote: kevin kempter wrote: Can you point me where to look for firewall/iptables/SE issues? Start with the output of iptables -L on both machines (you may need to run th

Re: [ADMIN] weird network issue

92.168.111.11 but it might eliminate some layer of issues. If you're familiar with nmap or similar programs you can accomplish the same thing to ping .11 on port 5432 -Original Message- From: kevin kempter [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2008 12:56 To: Jonatha

Re: [ADMIN] weird network issue

ewall/iptables/SE issues? Thanks in advance On Mar 28, 2008, at 10:45 AM, Jonathan Nalley wrote: are you running any kind of firewall/iptables/SELinux where the settings are perhaps not the same on the two machines? From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ] On Behalf Of

[ADMIN] weird network issue

Hi LIst; I have 2 Linux servers: 192.168.111.11 192.168.111.13 Both are running postgres v 8.2.6 I can ping the .11 box from .13 and vice versa I can connect remotely from the .11 box to the .13 box but I cannot connect to the .11 box from the .13 box. I can do this: on the 192.168.111.11

[ADMIN] Deferred Constraints Issues

Hi List; I've placed this sql in a script: psql my_db

[ADMIN] I/O error ?

Hi List; Anyone have any insight for the error below ? (we got it in a phgAdmin session) I checked the logs and didn't see anything, however the logging levels are at the defaults. Were running version 8.2.4 "An I/O error occured while sending to the backend." Thanks in advance /Kevi

[ADMIN] last analyze / vacuum

Hi List; Is there a system catalog, or other means where I can find out the last time a table was analyzed and the last time a table was vacuumed? Thanks in advance, /Kevin ---(end of broadcast)--- TIP 4: Have you searched our list archives?

[ADMIN] src equivelant of postgresql-python

Hi List; What's the source equivelant of postgresql-python. Is it a client interface ? Is it the same as "./configure --with-python" ? Thanks in advance. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http:

[ADMIN] pg_restore errors

Hi List; Trying to restore a pg_dump I get this: pg_restore: ERROR: invalid byte sequence for encoding "UTF8": 0xae HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding". CONTEXT: COPY imm_lookup, lin

[ADMIN] more blob questions

Hi List; Suppose I have a table with say an integer key, a char column and a large object column. can I simply delete a row from the table (delete from bigtable where...), then run a vacuum (or vacuum full) ? If so, in this scenario will postgres release the space back to the OS or must I firs

[ADMIN] large objects & space usage

Hi List; I'm engaging with a client who is trying to solve what sounds like a bloat issue. However in further conversations they told me this: 1) we have a table that is an integer key and a blob column 2) the table was at 30Gig, we went in and deleted the last 2 months of data and it's still a

Re: [ADMIN] PITR warm-standby with 8.2 setup questions

On Thursday 10 January 2008 12:27:37 David Wall wrote: > I'm trying to get WAL file copying working across two systems. It seems > pretty straightforward to handle this in the "archive_command" of the > primary, in which I am able to copy the files easily to a staging area > for the backup system.

Re: [ADMIN] Postgres replication

On Thursday 10 January 2008 00:38:38 nalini wrote: > Dear All > > I have a application running at various locations with backend as postgres > Slony is configured at all locations for replication at local site anda > central server where each site has its own database instance. > > Now we wish to m

[ADMIN] strftime pattern list ?

Anyone know where I can find a full list of the strftime patterns that can be used for log_filename ? Thanks in advance.. /Kevin ---(end of broadcast)--- TIP 6: explain analyze is your friend

[ADMIN] pg_restore error

Hi list; We're seeing this error whern trying to restore a pg_dump file: - pg_restore: ERROR: invalid byte sequence for encoding "UTF8": 0x9f CONTEXT: COPY log_customer_api, line 4551 pg_res

[ADMIN] How to correlate an index relname to it's table

Hi List; I've got an index name in pg_class and I want to figure out which table it belongs to, any suggestions? Thanks in advance /Kevin ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choo

Re: [ADMIN] Get a list of ALL tables

from the list, then run the vacuum on the remaining tables once a week to avoid transaction ID wraparound failures. /Kevin > Kevin Kempter <[EMAIL PROTECTED]> writes: > > I'm working with a client with several highly active 8.1.4 servers. I > > want to run a week

[ADMIN] Get a list of ALL tables

Hi List; I'm working with a client with several highly active 8.1.4 servers. I want to run a weekly cron that will vacuum ALL db tables except those with entries in pg_autovacuum (where we've setup manual/cron vacuums) in order to eliminate transaction ID wraparound failure warnings (which come

  1   2   >