[GENERAL] make postgresql 9.5 default on centos 7

Hi List, I loaded 9.5 on CentOS 7 but by default every thing wants to use the default 9.2 version that comes with CentOS 7. Is there a simple way to fix this so the 9.5 version of tools and libraries are used. Thanks, Steve -- Sent via pgsql-general mailing list (pgsql-general@postgresql.or

Re: [GENERAL] Schedule

On 06/20/2017 10:38 AM, Adrian Klaver wrote: > On 06/20/2017 07:00 AM, Steve Clark wrote: >> On 06/20/2017 09:02 AM, Adrian Klaver wrote: >>> On 06/20/2017 05:35 AM, Steve Clark wrote: >>>> Hello, >>>> >>>> We have customers whose equipment we

Re: [GENERAL] Schedule

On 06/20/2017 09:02 AM, Adrian Klaver wrote: > On 06/20/2017 05:35 AM, Steve Clark wrote: >> Hello, >> >> We have customers whose equipment we monitor. Some of the customers don't >> run a 24/7 operation >> and turn their equipment off when the go home. We

[GENERAL] Schedule

Hello, We have customers whose equipment we monitor. Some of the customers don't run a 24/7 operation and turn their equipment off when the go home. We need to create a schedule for them of when we can ignore alerts from their equipment. We use postgresql in our monitoring environment to mainta

Re: [GENERAL] Why so long?

On 04/19/2017 11:57 AM, Jeff Janes wrote: > On Wed, Apr 19, 2017 at 8:24 AM, Steve Clark <mailto:steve.cl...@netwolves.com>> wrote: > > Hello, > > I am confused. I have a table that has an incrementing primary key id. > > When I select max(id) from tab

Re: [GENERAL] Why so long?

Should add this is version 9.4.10 of postgresql On 04/19/2017 11:24 AM, Steve Clark wrote: > Hello, > > I am confused. I have a table that has an incrementing primary key id. > > When I select max(id) from table is returns almost instantly but > when I select min(id) from tab

[GENERAL] Why so long?

Hello, I am confused. I have a table that has an incrementing primary key id. When I select max(id) from table is returns almost instantly but when I select min(id) from table it takes longer than I want to wait. Shouldn't postgresql be able to quickly find the minimum id value in the index? p

Re: [GENERAL] psql - looking in wrong place for socket

On 03/17/2017 10:14 AM, Adrian Klaver wrote: > On 03/17/2017 06:58 AM, Steve Clark wrote: >> On 03/17/2017 09:49 AM, Adrian Klaver wrote: >>> On 03/17/2017 06:42 AM, Steve Clark wrote: >>>> Hi List, >>>> >>>> I am running postgresql 8.4.20

Re: [GENERAL] psql - looking in wrong place for socket

On 03/17/2017 09:49 AM, Adrian Klaver wrote: > On 03/17/2017 06:42 AM, Steve Clark wrote: >> Hi List, >> >> I am running postgresql 8.4.20 on CentOS 6. Things have been running fine >> for a long time >> then I rebooted. Postgres came up but when I tried to c

[GENERAL] psql - looking in wrong place for socket

Hi List, I am running postgresql 8.4.20 on CentOS 6. Things have been running fine for a long time then I rebooted. Postgres came up but when I tried to connect with psql on the local machine I got psql: could not connect to server: No such file or directory Is the server running locall

[GENERAL] Postgresql 94 from PostgreSQL RPM Repository (with Yum)

Hi I installed the following package: postgresql94-server-9.4.9-1PGDG.rhel6.x86_64 postgresql94-plperl-9.4.9-1PGDG.rhel6.x86_64 postgresql94-plpython-9.4.9-1PGDG.rhel6.x86_64 postgresql94-contrib-9.4.9-1PGDG.rhel6.x86_64 postgresql94-devel-9.4.9-1PGDG.rhel6.x86_64 postgresql94-libs-9.4.9-1PGDG.rh

Re: [GENERAL] deadlock error - version 8.4 on CentOS 6

On 10/28/2016 10:25 AM, Tom Lane wrote: Steve Clark writes: On 10/28/2016 09:48 AM, Tom Lane wrote: Retrying might be a usable band-aid, but really this is an application logic error. The code that is trying to do "lock table t_unit in exclusive mode" must already hold some lower-

Re: [GENERAL] deadlock error - version 8.4 on CentOS 6

On 10/28/2016 09:48 AM, Tom Lane wrote: Steve Clark writes: No. But I examined the pg_log/log_file and saw an error indicating it was autovacuum: 2016-10-27 09:47:02 EDT:srm2api:12968:LOG: sending cancel to blocking autovacuum PID 12874 2016-10-27 09:47:02 EDT:srm2api:12968:DETAIL: Process

Re: [GENERAL] deadlock error - version 8.4 on CentOS 6

On 10/28/2016 09:15 AM, Adrian Klaver wrote: On 10/28/2016 05:28 AM, Steve Clark wrote: Hello List, I am occasionally seeing the following error: ALERT 3 sqlcode=-400 errmsg=deadlock detected on line 3351 So what exactly is it doing at line 3351? from an application written using ecpg when

[GENERAL] deadlock error - version 8.4 on CentOS 6

Hello List, I am occasionally seeing the following error: ALERT 3 sqlcode=-400 errmsg=deadlock detected on line 3351 from an application written using ecpg when trying an update to the table. Can autovacuum be causing this, since no one else is updating this database table. Thanks, -- Stephen

Re: [GENERAL] dumb question

) from sometable where sts=0 -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Steve Clark Sent: Thursday, June 2, 2016 9:56 AM To: pgsql Subject: [GENERAL] dumb question Hi List, I am a noob trying to do something that

[GENERAL] dumb question

Hi List, I am a noob trying to do something that seems like it should be easy but I can't figure it out. I have a table like so: id | ref_id | sts -- 1 || 0 2 | 1 | 1 3 || 0 4 || 0 5 | 4 | 1 6 || 0 7 | 6 | 1 I want t

Re: [GENERAL] dumb question

Thanks all the below seem to do the trick. On 06/02/2016 01:58 PM, David G. Johnston wrote: select max(id) from yourtable where sts=0 and id not in (select ref_id from yourtable); select max(id) from yourtable where sts=0 and id not in (select ref_id from yourtable); -- Stephen Clark

[GENERAL] dumb question

Hi List, I am a noob trying to do something that seems like it should be easy but I can't figure it out. I have a table like so: id | ref_id | sts -- 1 || 0 2 | 1 | 1 3 || 0 4 || 0 5 | 4 | 1 6 || 0 7 | 6 | 1 I want t

[GENERAL] Get sum of sums

Hi List, I have the following table that has netflow data. I can get the top ten receivers by the query below - but I would also like to get at the same time a grand total of the RX Bytes. I am not exactly sure how to do it. This is with version 8.4. select ip_dst as "Receiver" ,sum(bytes) as

Re: [GENERAL] noobie join question

On 05/11/2015 07:16 AM, Oliver Elphick wrote: On Mon, 2015-05-11 at 06:46 -0400, Steve Clark wrote: Hi List, I am having trouble trying to figure out how to get the result listed at the bottom. I have 3 tables units, types of units which has a description of the units, and a table that list

[GENERAL] noobie join question

Hi List, I am having trouble trying to figure out how to get the result listed at the bottom. I have 3 tables units, types of units which has a description of the units, and a table that list associations of the units. I can't figure out how to do the proper joins. Any pointers would be appreciat

Re: [GENERAL] order by question

On 08/07/2014 11:36 AM, Kevin Grittner wrote: Steve Clark wrote: I am confused by how postgres 8,4..13 is sorting my data. select * from test order by data; data -- - -- 1 11 11F 1F a b C F -F Feneric Generic (14 rows) The

[GENERAL] order by question

Hello, I am confused by how postgres 8,4..13 is sorting my data. \d test Table "public.test" Column | Type | Modifiers +--+--- data | text | select * from test order by data; data -- - -- 1 11 11F 1F a b C F -F Feneric Generic (14 rows) Th

Re: [GENERAL] Trouble finding libpq on Centos 6.5

On 05/08/2014 02:54 AM, Aqz wrote: Hi. I'm not sure if I should write here, or on a Centos mailing list... I have fresh, vanilla Centos 6.5 with postgresql yum repository added. I've successfully installed postgresql93 and postgresql93-libs packages, but still : $ ld -lpq ld: cannot find -lpq

[GENERAL] reindexdb

Hello, We have a small (2GB) 8.4.20 database. The prior maintainer ran a reindexdb twice a day (originally started with 7.3.x). Can anybody see a reason why we need to continue to do this? Thanks, -- Stephen Clark *NetWolves Managed Services, LLC.* Director of Technology Phone: 813-579-3200 F

Re: [GENERAL] CentOS 6 and Postgresql 9.3.4 from PGDG

On 04/14/2014 09:02 AM, Moshe Jacobson wrote: On Mon, Apr 14, 2014 at 8:24 AM, Steve Clark mailto:scl...@netwolves.com>> wrote: CentOS 6 supplies 8.4.20 but I want to use hot standby - the issue is that the PGDG packages don't install into the "usual place"

[GENERAL] CentOS 6 and Postgresql 9.3.4 from PGDG

Hello, Don't know if this is better asked on the CentOS ML or here, but... CentOS 6 supplies 8.4.20 but I want to use hot standby - the issue is that the PGDG packages don't install into the "usual place" they are installed in version specific directories, including the data, binaries, librari

[GENERAL] what \ command actually run

Hello, I seem to recall seeing somewhere that you can turn on an option that will let you see what the \ command actually run, but googling and doing a quick scan of the docs didn't turn it up. Could someone assist me on this? Thanks, -- Stephen Clark *NetWolves* Director of Technology Phone: 81

Re: [GENERAL] Deploying PostgreSQL on CentOS with SSD and Hardware RAID

On 05/10/2013 12:46 PM, Merlin Moncure wrote: On Fri, May 10, 2013 at 11:34 AM, Evan D. Hoffman wrote: I'd expect to use a RAID controller with either BBU or NVRAM cache to handle that, and that the server itself would be on UPS for a production DB. That said, a standby replica DB on conventio

Re: [GENERAL] limit based on count(*)

On 02/22/2013 11:14 AM, Russell Keane wrote: > select serial_no, count(*) as "restarts" from event_log where event_mesg ilike 'system sta%' and event_date > current_date - 7 > group by serial_no > having count(*) > X > order by restarts I think having is the better option. Thanks all, did

[GENERAL] limit based on count(*)

Hello List, I have a query that counts how many time an event occurs in our event_log these are grouped by the serial number of the device that created the event. I would like to show only the rows where the number of events exceeds some threshold. simplified query: select serial_no, count(*) as

Re: [GENERAL] noobie question

On 01/24/2013 01:06 PM, Chris Angelico wrote: On Fri, Jan 25, 2013 at 4:45 AM, Steve Clark wrote: Thanks All, This is for a few very small tables, less 100 records each, that a user can delete and insert records into based on the "id" which is displayed in a php generated html s

Re: [GENERAL] noobie question

On 01/24/2013 12:36 PM, Jeff Janes wrote: On Thu, Jan 24, 2013 at 8:53 AM, Chris Angelico wrote: On Fri, Jan 25, 2013 at 3:47 AM, Steve Clark wrote: Say I have a table that has 2 columns like create table "foo" ( id integer not null, name text ); CREATE UNIQUE INDEX "fo

[GENERAL] noobie question

Hi list, This may be really simple - I usually do it using a procedural language such as php or a bash script. Say I have a table that has 2 columns like create table "foo" ( id integer not null, name text ); CREATE UNIQUE INDEX "foo_pkey" on "foo" using btree ( "id" "int4_ops" ); with 10

Re: [GENERAL] Need help for import of text file

On 12/16/2012 01:12 PM, Peter Bex wrote: On Sun, Dec 16, 2012 at 06:48:35PM +0100, Andreas wrote: With sed as startingpoint I figured it out. Those 3 steps make the input files consumable for COPY 1. dos2unix 2. sed -i 's/[ \t]*$//' 3. sed -i 's/ / /g' You can reduce this to one invocation by

Re: [GENERAL] Fixing the loss of 'template1'

On 03/07/2012 09:43 AM, Marti Raudsepp wrote: On Wed, Mar 7, 2012 at 16:23, Martin Gregorie wrote: Is it possible to reinstate 'template1' and all its works without reinitialising the database from scratch. It was suggested to me that running "initdb" might fix it while leaving my data in place

Re: [GENERAL] " " around fields with psql

On 02/13/2012 02:13 PM, Merlin Moncure wrote: On Sat, Feb 11, 2012 at 2:03 AM, Jasen Betts wrote: On 2012-02-10, Steve Clark wrote: Is there a way with psql to get column output to be "data1","data2",...,"datan" assuming you are trying to be compatible with

Re: [GENERAL] " " around fields with psql

On 02/10/2012 02:12 PM, Scott Marlowe wrote: On Fri, Feb 10, 2012 at 11:26 AM, Steve Clark wrote: Hello, Is there a way with psql to get column output to be "data1","data2",...,"datan" I tried -F "," but that left off the first and last quote. I

[GENERAL] " " around fields with psql

Hello, Is there a way with psql to get column output to be "data1","data2",...,"datan" I tried -F "," but that left off the first and last quote. I can't seem to find a way in the man page. Thanks, -- Stephen Clark *NetWolves* Director of Technology Phone: 813-579-3200 Fax: 813-882-0209 Email:

Re: [GENERAL] Ideas for query

On 10/13/2011 08:31 AM, Raymond O'Donnell wrote: On 13/10/2011 12:17, Steve Clark wrote: Hello List, I am a not very experienced writing sql and I have a problem I can't readily solve, so I was hoping to get some help from this great list. Here is my problem I have a table that has

[GENERAL] Ideas for query

Hello List, I am a not very experienced writing sql and I have a problem I can't readily solve, so I was hoping to get some help from this great list. Here is my problem I have a table that has event data about the status of units in the field. It has many kinds of events one of which has down

Re: [GENERAL] 7.4 quoting

On 03/31/2011 02:06 PM, Arjen Nienhuis wrote: On Thu, Mar 31, 2011 at 20:05, Arjen Nienhuis wrote: On Thu, Mar 31, 2011 at 18:56, Steve Clark wrote: Hi List, I am having a problem trying to do the following: ssh postgres@192.168.198.93 'psql -Atc "select a.interface, a.source_ip

[GENERAL] 7.4 quoting

Hi List, I am having a problem trying to do the following: ssh postgres@192.168.198.93 'psql -Atc "select a.interface, a.source_ip,a.dest_ip from kernel_gre a, ospfd_interface b where a.interface = b.interface and config ilike '%cost 50%';" config.db' bash turns it into this: ssh postgres@192.

Re: [GENERAL] how to vacuum from standalone backend

On 12/14/2010 01:04 PM, Steve Clark wrote: Help! This is postgresql 8.1.3 also the database debug can easily be recreated if I have to drop it but I can't seem to do that either. vacuumdb debug vacuumdb: could not connect to database debug: FATAL: database is not accepting comman

[GENERAL] how to vacuum from standalone backend

Help! This is postgresql 8.1.3 also the database debug can easily be recreated if I have to drop it but I can't seem to do that either. vacuumdb debug vacuumdb: could not connect to database debug: FATAL: database is not accepting commands to avoid wraparound data loss in database "debug" H

Re: [GENERAL] dotted quad netmask conversion

On 12/07/2010 11:43 AM, Tom Lane wrote: Steve Clark writes: Thanks for the response Jon. I should have stated this PG 8.1.x and '&' doesn't exist for network functions. I don't think& does what you want anyway. It just does a bit AND on the two addr

Re: [GENERAL] dotted quad netmask conversion

On 12/07/2010 10:30 AM, Jon Nelson wrote: On Tue, Dec 7, 2010 at 9:17 AM, Steve Clark wrote: Hello All, I am working with a postgresql database that has two columns. One for an ip address and another for the netmask. Both of these columns are char varying(30). I would like to convert to

[GENERAL] dotted quad netmask conversion

Hello All, I am working with a postgresql database that has two columns. One for an ip address and another for the netmask. Both of these columns are char varying(30). I would like to convert to just one column as inet. Any one know a slick way to convert the dotted quad netmask, E.G. 255.255.128

Re: [GENERAL] identifying local connections

On 11/15/2010 11:00 AM, Scott Ribe wrote: On Nov 15, 2010, at 8:50 AM, Tom Lane wrote: netstat will probably work for this, depending on what platform you're on. OS X. I can see the connections, but I don't see an option to display PIDs. netstat -an will do it on linux. sockst

Re: [GENERAL] Linux

On 11/04/2010 11:10 AM, Bill Moran wrote: In response to Michael Gould: I know that this is probably a "religion" issue but we are looking to move Postgres to a Linux server. We currently have a Windows 2008 R2 active directory and all of the other servers are virtualized via VMWare ESXi.

Re: [GENERAL] 8.4 Data Not Compatible with 9.0.1 Upgrade?

On 11/01/2010 02:49 PM, Carlos Mennens wrote: On Mon, Nov 1, 2010 at 2:27 PM, Steve Crawford wrote: I'm guessing you are missing an initdb. Move your old data directory somewhere else for now and do a new initdb so you can start up version 9. When you say 'old data' can you be more

Re: [GENERAL] Transposing rows and columns

On 09/16/2010 05:26 PM, Aram Fingal wrote: On Sep 16, 2010, at 4:37 PM, John R Pierce wrote: On 09/16/10 10:44 AM, Aram Fingal wrote: I have thought about that but later on, when we do the full sized experiments, there will be too many rows for Excel to handle. if you insist on this transpo

Re: [GENERAL] alter column to inet get error.

On 09/03/2010 09:38 AM, A. Kretschmer wrote: In response to Steve Clark : Hello List, I want to change some columns in a database that were originally created as char varying to inet. When I try I get an error. Is there anyway to work around this? See below for table definition

[GENERAL] alter column to inet get error.

Hello List, I want to change some columns in a database that were originally created as char varying to inet. When I try I get an error. Is there anyway to work around this? See below for table definition. Table "public.kernel_gre" Column | Type | M

Re: [GENERAL] Feature proposal

On 08/25/2010 12:30 PM, Joshua D. Drake wrote: On Wed, 2010-08-25 at 12:20 -0400, Eric Comeau wrote: Without even changing any line of data or code in sql ! Incredible, isn't it ? Curious- what postgresql.conf settings did you change to improve it? The most obvious would be to turn fsync

Re: [GENERAL] PG_DUMP very slow because of STDOUT ??

On 07/13/2010 10:35 AM, Andras Fabian wrote: Hi Greg, hmmm, thats true. Thos settings for example were much higher too (on the Ubuntu server), than on our old machine. New machine has: - dirty_ratio = 20 (old has 10) - dirty_background_ratio = 10 (old has 5) But obviously setting vm.zone_recla

Re: [GENERAL] PG_DUMP very slow because of STDOUT ??

On 07/13/2010 07:29 AM, Andras Fabian wrote: Now, I have found an unorthodox way, to make a slow machine run COPY-to-STDOUT fast. I empty the cache memory of the server, which makes "free" in "free -m" jump up to 14 GBytes (well, I just noticed, that most of the memory on the server is in "cach

Re: [GENERAL] postgreSQL not working after upgrade to Ubuntu 10.4

On 05/07/2010 01:22 PM, Alan Hodgson wrote: On Friday 07 May 2010, AllieH wrote: Yesterday I upgraded from Ubuntu 9.10 to 10.4. Unfortunately this has caused me serious problems with everything related to postgreSQL. It seems as though the new version of ubuntu is requiring me to use Post

Re: [GENERAL] postgreSQL not working after upgrade to Ubuntu 10.4

On 05/07/2010 12:10 PM, AllieH wrote: Yesterday I upgraded from Ubuntu 9.10 to 10.4. Unfortunately this has caused me serious problems with everything related to postgreSQL. It seems as though the new version of ubuntu is requiring me to use PostgreSQL 8.4 instead of 8.3 which I was previously u

Re: [GENERAL] checkpoints/bgwriter tuning verification

On 10/29/2009 04:42 PM, Scott Marlowe wrote: On Thu, Oct 29, 2009 at 12:46 PM, Vick Khera wrote: On my primary DB I'm observing random slowness which just doesn't make sense to me. The I/O system can easily do 40MB/sec writes, but I'm only seeing a sustained 5MB/sec, even as the application is

Re: [GENERAL] When to use cascading deletes?

David wrote: Thanks for the tips, those make sense. I was thinking through this some more after sending my mail, and came to similar conclusions. It would be nice though if this info was more available to people doing research on the subject. Where did you pick up these ideas? At least this thr

Re: [GENERAL] easy entry forms on a pg database

Scott Mead wrote: On Fri, May 15, 2009 at 1:11 PM, Raphael Bauduin > wrote: Hi, Are there any tool/libs to easily and rapidly generate web-based entry forms for tables in a postgresql database? I used this once for a quick project: http://www.sqlmae

Re: [GENERAL] recover corrupt DB?

Craig Ringer wrote: Peter Eisentraut wrote: On Thursday 23 April 2009 18:30:27 Dan Armbrust wrote: I had a test system (read as not backed up, sigh) which had the disk go full while PostgreSQL was loaded, consequently, PostgreSQL will no longer start. It is logging an error about detecting an

Re: [GENERAL] cast needed - but where and why?

Tom Lane wrote: Steve Clark writes: I am getting the following error after upgrading from 7.4.6 to 8.3.6 and can't figure out what is wrong. Any help would be greatly appreciated. 2009-04-02 10:45:10 EDT:srm2api:ERROR: column "event_ref_log_no" is of type integer but expres

[GENERAL] cast needed - but where and why?

Hello list, I am getting the following error after upgrading from 7.4.6 to 8.3.6 and can't figure out what is wrong. Any help would be greatly appreciated. from our program: sqlcode=-400 errmsg='column "event_ref_log_no" is of type integer but expression is of type text' in line 4138. from pg_

Re: [GENERAL] 8.3.x log maintenance

Tom Lane wrote: Steve Clark <[EMAIL PROTECTED]> writes: I have postgres logging into data/pg_log/ which works great. My question is there and option that tells postgres to only keep the last "n" log files? The usual solution is to choose a filename pattern that will

[GENERAL] 8.3.x log maintenance

Hi, I have postgres logging into data/pg_log/ which works great. My question is there and option that tells postgres to only keep the last "n" log files? Or does someone have a script that be run daily to remove the older log files so that I only end up with "n" log files? Thanks, Steve log_

Re: [GENERAL] setting Postgres client

Markova, Nina wrote: Thanks Richard. I specified the host IP ( I use the default 5432 port), got error: psql: could not connect to server: Connection refused Is the server running on host "192.168.XX.XXX" and accepting TCP/IP connections on port 5432? The only tcp lines in my

Re: [GENERAL] Backend timeout

Scott Marlowe wrote: On Tue, Sep 16, 2008 at 7:21 AM, Dragan Ciric <[EMAIL PROTECTED]> wrote: Hi! We need some help. Sometimes we have broken connections with backend ( postgresql server ). When this occurs, we have "idle in transaction" indication on server side. Can you answer us, how long

Re: [GENERAL] MERGE: performance advices

Tom Lane wrote: "Richard Broersma" <[EMAIL PROTECTED]> writes: There is one possible alteration that may or many not improve performance. This would be to replace the EXISTS with a LEFT JOIN WHERE IS NOT NULL; That changes the behavior, doesn't it? Or is event_log_no a unique key for Myeve

Re: [GENERAL] MERGE: performance advices

Richard Broersma wrote: On Tue, Sep 2, 2008 at 9:47 AM, Steve Clark <[EMAIL PROTECTED]> wrote: srm2=# explain srm2-# INSERT INTO Myevents srm2-# SELECT * ERROR: INSERT has more expressions than target columns srm2=# explain srm2-# INSERT INTO Myevents srm2-# SELECT *

Re: [GENERAL] MERGE: performance advices

Richard Broersma wrote: On Tue, Sep 2, 2008 at 8:10 AM, Steve Clark <[EMAIL PROTECTED]> wrote: Is there a way to do something similar with the following? I am an SQL noob and the following takes longer to run than is reasonable, on the order of hours. insert into myevents select

Re: [GENERAL] MERGE: performance advices

Richard Broersma wrote: On Tue, Sep 2, 2008 at 4:19 AM, Ivan Sergio Borgonovo <[EMAIL PROTECTED]> wrote: insert into d (pk, c1, c2, ...) select pk, c1, c2, c3 from s where s.pk not in (select pk from d); This insert statement might be faster: INSERT INTO d (pk, c1, c2, ... ) SELECT pk, c1

Re: [GENERAL] 8.3.1 query plan

Tom Lane wrote: Steve Clark <[EMAIL PROTECTED]> writes: Tom Lane wrote: Consider testing the conditions on A at the top level, instead of redundantly checking them inside the sub-query on B. Thanks for the response Tom, I am a SQL neophyte, so I'll try to rework the query

Re: [GENERAL] 8.3.1 query plan

Tom Lane wrote: Steve Clark <[EMAIL PROTECTED]> writes: explain insert into myevents select * from t_unit_event_log a where exists (select b.event_log_no from myevents b where a.event_status = 1 and a.event_ref_log_no IS NOT NULL and a.event_ref_

Re: [GENERAL] 8.3.1 query plan

Martijn van Oosterhout wrote: On Wed, Aug 27, 2008 at 11:00:54AM -0400, Steve Clark wrote: So I did an explain and I see it is doing a seq scan in the last sub plan - there are about 375,000 rows in myevent - why isn't it using the index instead of doing a seq scan? create unique

[GENERAL] 8.3.1 query plan

Hello List, I have inherited an existing application. It has a table of events and some events may reference an earlier event. We have a script that saves the first N number of events for each device, but we also want to save any additional event that is referenced by one of the first N events.

[GENERAL] default postgresql.conf

Hello List, When an initdb is done where do the default postgresql.conf and pg_hba.conf come from? Are they copied from some template file? Thanks, Steve -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailp

Re: [GENERAL] renumber table

only one row was deleted. update meh set id = id - 1 where id > 5; At this point, if you've got a sequence that populates the id field, you'll need to set its nextval. Dave On Thu, Jun 19, 2008 at 7:54 AM, Steve Clark <[EMAIL PROTECTED] <mailto:[EMAIL P

Re: [GENERAL] renumber table

Scott Marlowe wrote: On Wed, Jun 18, 2008 at 3:50 PM, Steve Clark <[EMAIL PROTECTED]> wrote: I realize this is certainly not the best design - but at this point in time it can't be changed. The table is rarely updated and never concurrently and is very small, typically less than

Re: [GENERAL] renumber table

Scott Marlowe wrote: On Wed, Jun 18, 2008 at 2:58 PM, Steve Clark <[EMAIL PROTECTED]> wrote: Hello List, I have acquired the task of maintaining and existing application that uses postgresql. I am only lightly versed in sql and have the following problem I need to solve. I have a ta

[GENERAL] renumber table

Hello List, I have acquired the task of maintaining and existing application that uses postgresql. I am only lightly versed in sql and have the following problem I need to solve. I have a table in which each row has a column - row_number. The row_numbers need to be sequential. Everything is fi

Re: [GENERAL] --enable-thread-safety bug

Michael Meskes wrote: On Sat, Mar 22, 2008 at 04:58:28PM -0400, Steve Clark wrote: Not exactly sure what you are asking about - descriptors and auto allocating. So I guess you don't use either feature. :-) The program processes about 80 packets a day, which can update se

Re: [GENERAL] --enable-thread-safety bug

Craig Ringer wrote: Steve Clark wrote: I guess the real question is why we are running out of memory when this option is enabled. Since my app doesn't use threads that points to a memory leak in the ecpg library when enable thread safety is turned on. It might be worth building ecpg

Re: [GENERAL] --enable-thread-safety bug

Steve Clark wrote: Michael Meskes wrote: On Sat, Mar 22, 2008 at 12:51:30PM -0400, Steve Clark wrote: My program had no threads - as I pointed out if I change the default Makefile in the FreeBSD ports system to not enable thread safety my programs runs just fine for days on end. It

Re: [GENERAL] --enable-thread-safety bug

Michael Meskes wrote: On Sat, Mar 22, 2008 at 12:51:30PM -0400, Steve Clark wrote: My program had no threads - as I pointed out if I change the default Makefile in the FreeBSD ports system to not enable thread safety my programs runs just fine for days on end. It appears to me without any

Re: [GENERAL] --enable-thread-safety bug

Martijn van Oosterhout wrote: On Sat, Mar 22, 2008 at 11:28:24AM -0400, Steve Clark wrote: Retry - the malloc - maybe there is a memory leak when --enable-thread-saftey is enabled, send an out of memory message to the postgres log, abort the transaction - I don't know I am not a pos

Re: [GENERAL] --enable-thread-safety bug

Tom Lane wrote: Martijn van Oosterhout <[EMAIL PROTECTED]> writes: Note this is your in application, not the server. Only your program died. Ofcourse the transaction got aborted, since the client (you) disconnected. There is no way for this to write to the server log, since it may be one anothe

Re: [GENERAL] --enable-thread-safety bug

Tom Lane wrote: Steve Clark <[EMAIL PROTECTED]> writes: The return from malloc should be checked to make sure it succeeds - right??? Probably, but what do you expect the code to do if it doesn't succeed? This function seems not to have any defined error-return

[GENERAL] --enable-thread-safety bug

Hello List, I am running 8.3.1 on FreeBSD 6.2 patch-7. The ports for Freebsd turn on --enable-thread-safety during configure of pg. When running my app after some time I have been getting a core dump - sig 11. #0 0x28333b96 in memcpy () from /lib/libc.so.6 (gdb) bt #0 0x28333b96 in memcp

Re: [GENERAL] ecpg program getting stuck

Tom Lane wrote: Steve Clark <[EMAIL PROTECTED]> writes: I have a program that worked fine in 7.4.19. I am in process of upgrading to 8.3.1 and my program runs for a while and then hangs. I used gdb to attach to the process and it shows the following backtrace which shows it going in

[GENERAL] ecpg program getting stuck

Hello List I have a program that worked fine in 7.4.19. I am in process of upgrading to 8.3.1 and my program runs for a while and then hangs. I used gdb to attach to the process and it shows the following backtrace which shows it going into the libpq library and getting stuck. Anybody have any

Re: [GENERAL] cast problem 8.3.1

Charles Simard wrote: |> |> postgres error log: |> ERROR: operator does not exist: text = integer |> HINT: No operator matches the given name and argument type(s). You |> might need to add explicit type casts. |> STATEMENT: update T_MON_DEVICE_STATUS set device_ip = $1 :: inet |> , s

[GENERAL] cast problem 8.3.1

Hello List, I can't seem to figure out what is this code that worked on 7.4.x. I've added cast to everything but still get: postgres error log: ERROR: operator does not exist: text = integer HINT: No operator matches the given name and argument type(s). You might need to add explicit type c

Re: [GENERAL] ecpg problem

Michael Meskes wrote: I just committed the attached small fix to CVS HEAD and the 8.3 branch. This should fix your problem. Michael diff --exclude CVS -ru /home/postgres/pgsql-ecpg/preproc/type.c preproc/type.c --- /hom

Re: [GENERAL] ecpg problem

Michael Meskes wrote: On Fri, Feb 29, 2008 at 11:27:25AM -0500, Steve Clark wrote: Actually it appears to work in 8.2.5 but be broken in 8.2.6 and 8.3.0. Are you really sure? It appears to me that there was no change between 8.2.5 and 8.2.6 that could affect ecpg's handling of arra

Re: [GENERAL] ecpg problem

Steve Clark wrote: Hello List, Don't know whether anyone here can help but... We have some code that has compiled and ran just fine from postgresql 7.3.x thru 8.2.6. It uses embedded sql. I just yesterday upgraded our test system to 8.3.0 and this code will no longer compile. Below

[GENERAL] ecpg problem

Hello List, Don't know whether anyone here can help but... We have some code that has compiled and ran just fine from postgresql 7.3.x thru 8.2.6. It uses embedded sql. I just yesterday upgraded our test system to 8.3.0 and this code will no longer compile. Below is a standalone code fragment

Re: [GENERAL] warm standby examples.

Erik Jones wrote: On Jan 31, 2008, at 10:04 AM, Steve Clark wrote: Hello List, I am going to be setting up a warm standby postgresql 8.2.5 high availability 2 server system. I was wondering if anybody that has done this can share some scripts, pertinent postgresql.conf entries, etc so I

  1   2   >