[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

, -- Stephen Clark -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

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

ic - -- -F 1 11 11F 1F a b C F (14 rows) client_encoding - SQL_ASCII lc_collate - en_US.UTF-8 foxboxconfig=# show lc_ctype; lc_ctype - en_US.UTF-8 Thanks for any clarification. -- Stephen Clark -- Sent via pgsql-general mailin

Re: [GENERAL] Trouble finding libpq on Centos 6.5

pointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv CFLAGS_SL = -fpic LDFLAGS = -L../../../src/common -L/usr/lib64 -Wl,--as-needed LDFLAGS_EX = LDFLAGS_SL = LIBS = -lpgport -lpgcommon -lxslt -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz -lreadline -lcrypt -ldl -lm VERSION = PostgreSQL 9.3.4 -- Stephen Clark *NetWolves Managed Services, LLC.* Director of Technology Phone: 813-579-3200 Fax: 813-882-0209 Email: steve.cl...@netwolves.com http://www.netwolves.com

[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

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

g the data, binaries, libraries etc. How do people deal with this when for years they have been using postgres and "stuff" is in standard directories not version specific directories? Thanks for any tips. Steve -- Stephen Clark *NetWolves Managed Services, LLC.* Director of Technology Phone:

[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

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

cable, etc you have data loss. With on-drive capacitor you only get data loss via physical damage or corruption on the drive. merlin Well we have dual redundant power supplies on separate UPS so could something go wrong yes, but a tornado could come along and destroy the building also. -

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

ing is the better option. Thanks all, didn't know about having - I am noobie with SQL. -- Stephen Clark

[GENERAL] limit based on count(*)

(*) as "restarts" from event_log where event_mesg ilike 'system sta%' and event_date > current_date - 7 group by serial_no order by restarts; So what I would like to see is only the serial_nos that had more than X restarts. Any ideas would be appreciated. -- Stephen Cla

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

to do this in postgresql without resulting to some external language? Thanks for your consideration. -- Stephen Clark -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

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

his, you can always write a proper program in a "real" language to do it. This can be easier to maintain. Cheers, Peter why not use the squeeze option of tr. tr -s " " -- Stephen Clark *NetWolves* Director of Technology Phone: 813-579-3200 Fax: 813-882-0209 Email: steve.cl...@netwolves.com http://www.netwolves.com

Re: [GENERAL] postmaster.pid file auto-clean up?

On Sun, Aug 26, 2012 at 1:25 PM, Alban Hertroys wrote: > > We back our client application with PG, > > > each OSX user gets their own instance of PG. > > Are you certain that's necessary? > > It was a decision made, weighing various trade-offs, 4 years ago now. > > In the wild this scenario has

Re: [GENERAL] postmaster.pid file auto-clean up?

On Sun, Aug 26, 2012 at 10:25 AM, Tom Lane wrote: > Michael Clark writes: > > PID 8574 is actually iTunes, not PG, > > iTunes? What is that doing running under PG's userid? > > > We back our client application with PG, each OSX user gets their own instance of

Re: [GENERAL] postmaster.pid file auto-clean up?

On Mon, Aug 20, 2012 at 11:30 PM, Tom Lane wrote: > Sebastien Boisvert writes: > > Is this mechanism documented anywhere (besides source code)? > > No, not really. > > > It looks like PG will only clean it up if there's no other process > running at all on the pid listed in the postmaster.pid fi

Re: [GENERAL] Problems with timestamp with time zone and old dates?

On Wed, Aug 22, 2012 at 5:00 AM, hubert depesz lubaczewski < dep...@depesz.com> wrote: > On Tue, Aug 21, 2012 at 05:29:14PM -0400, Michael Clark wrote: > > For example, if I insert like so: > > INSERT INTO sometable (startdate) values ('1750-08-21 21:17:00+00:00'

Re: [GENERAL] Problems with timestamp with time zone and old dates?

me on that and sending me down that road! Michael. On Wed, Aug 22, 2012 at 12:19 AM, Scott Marlowe wrote: > On Tue, Aug 21, 2012 at 10:12 PM, Scott Marlowe > wrote: > > On Tue, Aug 21, 2012 at 10:08 PM, Scott Marlowe > wrote: > >> On Tue, Aug 21, 2012 at 3:29 PM, Michael

Re: [GENERAL] Problems with timestamp with time zone and old dates?

Hello. Thanks for the response. The value being returned from PG, with the odd offset is expected? Thanks again, Michael. On Tue, Aug 21, 2012 at 5:50 PM, Steve Crawford < scrawf...@pinpointresearch.com> wrote: > On 08/21/2012 02:29 PM, Michael Clark wrote: > >> Hello a

[GENERAL] Problems with timestamp with time zone and old dates?

Hello all, I have a weird situation I am trying to work through, and could use some help if anyone can provide some. I have a table with a column to store timestamp with time zone, and when I store an older take (before 1895 or so), the value I get back from PG when doing a select seems odd and i

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

7;s what happened. This query should tell you the name of the database that used to be template1: SELECT datname FROM pg_database WHERE datistemplate; Regards, Marti -- Stephen Clark *NetWolves* Director of Technology Phone: 813-579-3200 Fax: 813-882-0209 Email: steve.cl...@netwolves.com http://www.netwolves.com

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 Technolog

Re: [GENERAL] CLONE DATABASE (with copy on write?)

ite infeasible since you'd have to touch every disk block to rewrite the transaction IDs. This feature was requested by Yang Zhang on April 6th as well. Best, Clark -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] CLONE DATABASE (with copy on write?)

On Sunday, November 13, 2011 7:33 AM, "Simon Riggs" wrote: > On Sat, Nov 12, 2011 at 9:40 PM, Clark C. Evans > > [We] should be using "CREATE DATABASE ... WITH TEMPLATE". > > However, this has two big disadvantages.  First, it only works > > if you ca

[GENERAL] CLONE DATABASE (with copy on write?)

x27;d be cloned in memory, and the clone would be flushed. I'm just imagining a world where "deploying" a new version of our software that makes very small catalog changes and tweaks a few rows would be... quick. Quick to try, check, test, and even deploy on live servers. Best,

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

-09-01 00:00:00' and event_date <= '2011-09-30 23:59:59' and unit_serial_no in (select unit_serial_no from t_unit where group_id='199' and activated='y') order by unit_serial_no) as foo where down_time < '5 days') as foo2 group by unit_serial_no; -

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

''' but none work. I have even tried exchanging the outer " with ' and the inner "select to 'select but still no success. Any ideas? With 8.x databases I use \$\$%cost 50%\$\$ which work great. -- Stephen Clark *NetWolves* Sr. Software Engineer III Phone: 813-579-3200 Fax: 813-882-0209 Email: steve.cl...@netwolves.com http://www.netwolves.com

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

shutdown, execute a full-database VACUUM in "debug". WARNING: database "debug" must be vacuumed within 84 transactions HINT: To avoid a database shutdown, execute a full-database VACUUM in "debug". WARNING: database "debug" must be vacuumed within 83 transactions HINT: To avoid a database shutdown, execute a full-database VACUUM in "debug". ERROR: could not access status of transaction 449971277 DETAIL: could not open file "pg_clog/01AD": No such file or directory Now what? Thanks in advance. -- Stephen Clark *NetWolves* Sr. Software Engineer III Phone: 813-579-3200 Fax: 813-882-0209 Email: steve.cl...@netwolves.com http://www.netwolves.com

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

. 255.255.128.0, to number of bits. I didn't see any way directly looking at the network functions in the PG documentation. Thanks in advance for your consideration. -- Stephen Clark *NetWolves* Sr. Software Engineer III Phone: 813-579-3200 Fax: 813-882-0209 Email: steve.cl...@netwolves.com

Re: [GENERAL] identifying local connections

t on linux. sockstat will do it on FreeBSD. What's OS X ? ;-) -- Stephen Clark *NetWolves* Sr. Software Engineer III Phone: 813-579-3200 Fax: 813-882-0209 Email: steve.cl...@netwolves.com http://www.netwolves.com

Re: [GENERAL] More then 1600 columns?

That's fine. PostgreSQL is a fantastic database -- it's welcome to have a few limitations. Best, Clark On Fri, 12 Nov 2010 17:10 -0500, "Tom Lane" wrote: > "Mark Mitchell" writes: > > I think it's very obvious that Postgres developers have no interest in

Re: [GENERAL] More then 1600 columns?

s quite deep in PostgreSQL and extends to tuples, including views and in-memory query results. I find that partitioning does work, but it requires extra care on the part of the application developer that really shouldn't be necessary. Best, Clark -- Sent via pgsql-general mailing list (p

Re: [GENERAL] More then 1600 columns?

. Instead, I'd absolutely love to see PostgreSQL add a variant scalar type (for when the type of a column changes over the lifetime of the instrument) and a column storage for Nth+ and additional columns. For now, the work-around above sort of works for us. Best, Clark -- Sent via pgsql-

Re: [GENERAL] Linux

nd you'll probably have a distro that you'll be happy with. We have used FreeBSD but are moving to CentOS. Main reason is longer support window. FreeBSD usually goes EOL in a year or two. CentOS 5.x is supported thru at least 2014. -- Stephen Clark *NetWolves* Sr. Software Engine

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

initdb to initialize the 9.x database system. HTH -- Stephen Clark *NetWolves* Sr. Software Engineer III Phone: 813-579-3200 Fax: 813-882-0209 Email: steve.cl...@netwolves.com http://www.netwolves.com

Re: [GENERAL] Should PQconsumeInput/PQisBusy be expensive to use?

On Thu, Oct 28, 2010 at 11:15 AM, A.M. wrote: > > On Oct 28, 2010, at 11:08 AM, Michael Clark wrote: > > > Hello all. > > > > Thanks a lot for the responses, they are appreciated. > > > > I think I now understand the folly of my loop, and how that

Re: [GENERAL] Should PQconsumeInput/PQisBusy be expensive to use?

cancelling...). Again, thanks so much for the help. Michael. On Wed, Oct 27, 2010 at 6:10 PM, Tom Lane wrote: > Michael Clark writes: > > In doing some experiments I found that using > > PQsendQueryParams/PQconsumeInput/PQisBusy/PQgetResult produces slower > > results t

[GENERAL] Should PQconsumeInput/PQisBusy be expensive to use?

Hello everyone. I have been investigating the PG async calls and trying to determine whether I should go down the road of using them. In doing some experiments I found that using PQsendQueryParams/PQconsumeInput/PQisBusy/PQgetResult produces slower results than simply calling PQexecParams. Upon s

Re: [GENERAL] Transposing rows and columns

ancer cell tissue cultures in 384-well plates, handled by robots. That's how we can do so many drug/dose combinations. We'll do even more in the future. -Aram -- Stephen Clark NetWolves Sr. Software Engineer III Phone: 813-579-3200 Fax: 813-882-0209 Email: steve.cl...@netwolves.c

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.

20 | 10.1.1.38 | 10.1.1.37 | 1.1.1.37| t | 1.1.1.38| 255.255.255.255 | | f | f gre21 | 10.1.1.40 | 10.1.1.39 | 1.1.1.39| t | 1.1.1.40| 255.255.255.255 | | f | f (20 rows) Thanks in advance, -- Stephen Clark NetWolves Sr. Software En

Re: [GENERAL] Feature proposal

turn fsync off, sychronous_commit off, increase work_mem, increase checkpoint_timeout, increase wal_segments. JD can these be changed on the fly via set commands or does the config file have to be changed and postgres stopped and restarted. postgres 8.3.7 on freebsd. -- Stephen Clark NetWolv

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

tio and dirty_background_ratio to try and improve things, but the congestion code will thwart any attempt to make them really low. You might monitor what shows up as "Dirty:" in /proc/meminfo to see if that lines up with the slow periods; example of what bad output looks like at http://notemagn

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

r Have you posted this problem/issue to the linux kernel mailing list? You may get some rude responses about the posting but someone will give you a tip or what is causing the problem. I know there are some sysctls that affect memory management. I use the following 2 based on recommendation

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

plications using those databases. -- Stephen Clark NetWolves Sr. Software Engineer III Phone: 813-579-3200 Fax: 813-882-0209 Email: steve.cl...@netwolves.com www.netwolves.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscrip

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

ra 12 - luckily I had been doing daily pg_dumps so all I had to do was initdb under 8.4 and psql < my backup. -- Stephen Clark NetWolves Sr. Software Engineer III Phone: 813-579-3200 Fax: 813-882-0209 Email: steve.cl...@netwolves.com www.netwolves.com -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] Possible causes for database corruption and solutions

On Wed, Dec 16, 2009 at 2:05 PM, Greg Smith wrote: > Michael Clark wrote: > > On Wed, Dec 16, 2009 at 11:25 AM, Greg Smith wrote: > >> Florian Weimer wrote: >> >>> I hope that Mac OS X turns off write caches on low battery. >>> >>> >> &

Re: [GENERAL] Possible causes for database corruption and solutions

On Wed, Dec 16, 2009 at 11:25 AM, Greg Smith wrote: > Florian Weimer wrote: > >> I hope that Mac OS X turns off write caches on low battery. >> >> > > I've never heard of such a thing. The best you can do is try to push the > system into hibernation instead of going down hard. That *should* cle

Re: [GENERAL] Possible causes for database corruption and solutions

On Wed, Dec 16, 2009 at 5:41 AM, Florian Weimer wrote: > * Craig Ringer: > > > On 16/12/2009 3:54 PM, Florian Weimer wrote: > >> * Michael Clark: > >>> and with no power protection, then I expect it does. Add laptop > > users with ageing/flakey batteries

Re: [GENERAL] Possible causes for database corruption and solutions

Hi Greg, thanks for the reply! On Tue, Dec 15, 2009 at 10:52 PM, Greg Smith wrote: > Michael Clark wrote: > >> >> Secondly, I ask about an alternative solution to the corruption problem >> because with preliminary testing we have seen a significant degradation in >

Re: [GENERAL] Possible causes for database corruption and solutions

Hi Scott and Craig, On Tue, Dec 15, 2009 at 9:45 PM, Craig Ringer wrote: > On 16/12/2009 9:07 AM, Scott Marlowe wrote: > > I'd also recommend moving off of OSX as you're using a minority OS as >> far as databases are concerned, and you won't have a very large >> community to help out when things

Re: [GENERAL] Possible causes for database corruption and solutions

Hello Craig - thanks for the reply. I will reply below. On Tue, Dec 15, 2009 at 9:34 PM, Craig Ringer wrote: > On 16/12/2009 6:39 AM, Michael Clark wrote: > >> Hello all, >> >> Over the past 6 months or so I have posted to the list a couple times >> looking for in

[GENERAL] Possible causes for database corruption and solutions

Hello all, Over the past 6 months or so I have posted to the list a couple times looking for information regarding recovering databases from corruption. At the time the incidents of corruption among our users was very low, but the frequency is starting to increase, most likely due to the increase

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

[GENERAL] Fwd: PQgetlength vs. octet_length()

On Tue, Aug 18, 2009 at 1:48 PM, Greg Stark wrote: > On Tue, Aug 18, 2009 at 6:39 PM, Michael Clark > wrote: > > But it seems pretty crazy that a 140meg bit of data goes to 1.3 gigs. > Does > > that seem a bit excessive? > > From what you posted earlier it looked lik

[GENERAL] PQgetlength vs. octet_length()

at 12:15 PM, Greg Stark wrote: > On Tue, Aug 18, 2009 at 4:04 PM, Michael Clark > wrote: > > Hello - am I in the wrong mailing list for this sort of problem? :- > > Probably but it's also a pretty technical point and you're programming > in C so it's kind of

Re: [GENERAL] filter duplicates by priority

This solved my problem. Now why didn't I think of that!? Thank you very much everybody. This list is an incredible resource. -Clark > AFAICS, changing it to ORDER BY part_number,priority would solve the > stated problem. If you really need the final result in priority rather

[GENERAL] filter duplicates by priority

Hello- I am trying to use DISTINCT ON to filter out *potential* duplicate values from a set of sub queries. There are certain cases where there can be repetitive part numbers that are priced differently. I'm trying to start with the full list, ordered by priority, and then remove any repeats tha

[GENERAL]

eans that all of the resulting tuples are unique, even though the part_number is the same. If anyone could suggest a solution or alternative approach, I would greatly appreciate it. Thank you, Clark -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

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_

[GENERAL] Porting from Oracle PL/SQL

While doing a Google search recently, I found a nice site located at http://www.redhat.com/docs/manuals/database/RHDB-2.0-Manual/prog/plpgsql-porting.html. The number and quality of Postgres related book titles has grown, and greatly improved over the years. With the increased popularity of Ope

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

  1   2   3   >