Re: [GENERAL] Developer GUI tools for PostgreSQL

See dbeaver. http://dbeaver.jkiss.org community and Enterprise editions are free and it's very good -- 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] IDE for function/stored proc development.

On Sat, 2016-09-03 at 21:36 +1200, Tim Uckun wrote: > Does anybody use an IDE for doing heavy duty stored proc development?  PGadmin > is decent but I am looking for something better. >  > I have tried jetbrains with the db browser plugin and on the surface it seems > like a good choice but it's re

Re: [GENERAL] Processing data from table using awk.

On Tue, 2015-10-06 at 09:04 -0500, John McKown wrote: > I'm wanting to do some reporting on data which I have an a PostgreSQL table. > For lack of anything better, I've decided to see if I can do it in GNU awk. perhaps... note the 4th extension... https://www.gnu.org/software/gawk/manual/html_n

Re: [GENERAL] SQL pre-processor, like ecpg, for other languages?

On Tue, 2015-08-11 at 14:32 -0400, an unknown sender wrote: > On Tue, 2015-08-11 at 07:20 -0500, John McKown wrote: > > > PostgreSQL comes with ecpg which is a "pre-processor" to handle embedded > > EXEC > > SQL startements in C (OK, you already know that). I am wondering if anyone > > knows of

Re: [GENERAL] SQL pre-processor, like ecpg, for other languages?

On Tue, 2015-08-11 at 07:20 -0500, John McKown wrote: > PostgreSQL comes with ecpg which is a "pre-processor" to handle embedded EXEC > SQL startements in C (OK, you already know that). I am wondering if anyone > knows of any such program for other compiled languages, in particular GNU > COBOL or

Re: [GENERAL] Re: Remote PostgreSQL database - C/C++ program / Unix / Required Libraries

On Sun, 2014-11-30 at 12:51 -0700, Léa Massiot wrote: > Me again. Sorry. > > This looks good too: "Building libpq Programs": > http://www.postgresql.org/docs/9.1/static/libpq-build.html > > But what do I need to install on B? > > Best regards. > > > > -- > View this message in context: > htt

Re: [GENERAL] Junk date getting uploaded into date field

On Tue, 2013-11-05 at 04:14 -0800, bsreejithin wrote: > Not able to post the attached details as a comment in the reply box, so > attaching it as an image file : > > > > > -- > View this message in context: > http://postgresql.

Re: [GENERAL] bloating vacuum

On Tue, 2013-05-14 at 14:51 +, S H wrote: > I am doing some experiment to understand the behaviour of manual > vacuum. > > I created small table and started doing insertion/deletion/updation on > 2 rows in infinite loop. It started bloating around 844 times, but > after it stopped bloating.. w

Re: [GENERAL] Is it even possible?

On Tue, 2012-03-20 at 09:22 -0500, Sam Loy wrote: > I have now tried at least 7 different install methods to get pg up and > running on Lion. I fear that my system is now thoroughly inoculated and will > never be able to run postgres/postgis. > > I started with the pg mac installer / stack build

[GENERAL] PG9.1.2 -- 3 day old orphaned/non-responsive query -- pg_(cancel)(terminate)_backend has no effect

Looking for some quidance or suggestions. PostgreSQL 9.1.2 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.5 20110214 (Red Hat 4.4.5-6), 64-bit $ uname -a Linux db1.hw.ateb.com 2.6.32-131.21.1.el6.x86_64 #1 SMP Tue Nov 22 19:48:09 GMT 2011 x86_64 x86_64 x86_64 GNU/Linux datid| d

Re: [GENERAL] Enumeration of tables is very slow in largish database

On Wed, 2012-01-11 at 20:50 +0100, Kirill Müller wrote: > that would > allow tracing the queries and their runtime while they are executed \ http://www.postgresql.org/docs/8.4/static/auto-explain.html -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Is this safe to perform on PostgreSQL 8.3.7 -> Resize a column in a PostgreSQL table without changing data

On Tue, 2011-11-22 at 15:55 +, Gregg Jaskiewicz wrote: > for the future it is better to just use text type, and: check > length(field) < 35; thanks to all for the respones. The above seems a prudent way to go in my future. My assumption is that converting varchar(n) to text would still force

[GENERAL] Is this safe to perform on PostgreSQL 8.3.7 -> Resize a column in a PostgreSQL table without changing data

reporting=# select version(); version -- PostgreSQL 8.3.7 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20071124 (Red Hat 4.1.2-4

Re: [GENERAL] Solaris 10u9, PG 8.4.6, 'c' lang function, fails on 1 of 5 servers

On Thu, 2011-09-29 at 12:08 -0500, dennis jenkins wrote: > ERROR: could not load library "/db/pgsql_micr_parser_64.so": ld.so.1: > postgres: fatal: /db/pgsql_micr_parser_64.so: Permission denied for a different shared object, but may provide clues... Error: "- adding iplike database function...

[GENERAL] Is libpq version indifferent? I.E. can 8.3.x compiled binaries run without issue against a 9.1 backend, or are clients required to be re-compiled against the 9.1 libpq

I believe that there should be no issue, but am asking to be sure. Thanks, reid -- 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] Re: Need help with what I think is likely a simple query - for each distinct val, return only one record with the most recent date.

On Tue, 2011-09-13 at 16:39 +0200, Hannes Erven wrote: > Reid, > > > > where any one of these 3 > > > > 11 2011-01-01 > > 11 2011-01-01 > > 13 2011-01-01 > > > > or any one of these 2 > > 31 2011-01-05 > > 32 2011-01-05 > > > > are suitable for va

[GENERAL] Need help with what I think is likely a simple query - for each distinct val, return only the record with the most recent date.

Could someone point me in the right direction.. Thanks - reid Given the example data, how do I write a query that will give me the resultset: 12011-01-01 22011-01-06 32011-01-05 42011-01-09 52011-01-05 62011-01-08 I.E. for each distinct val, return the record with the mo

[GENERAL] Re: Need help with what I think is likely a simple query - for each distinct val, return only one record with the most recent date.

2011-01-08 where any one of these 3 11 2011-01-01 11 2011-01-01 13 2011-01-01 or any one of these 2 31 2011-01-05 32 2011-01-05 are suitable for val = 1, val = 3 respectively. On 9/12/2011 8:54 PM, Reid Thompson wrote: Could someone

[GENERAL] Re: Need help with what I think is likely a simple query - for each distinct val, return only one record with the most recent date.

On 9/12/2011 9:54 PM, Reid Thompson wrote: Ack -- i flubbed the subject and sample. The sample data should be val val2date 11 2011-01-01 22 2011-01-02 33 2011-01-03 41 2011-01-04 52 2011-01-05 53 2011-01-01 41 2011-01-02

Re: [GENERAL] interesting finding on order by behaviour

On Fri, 2011-07-22 at 10:11 -0700, Samuel Hwang wrote: > I ran the same tests in SQL Server 2008R2, Oracle10 and PostgreSQL > 9.0.4 and found something interesting... > results > = > SQL Server 2008 R2 (with case insensitive data, the ordering follows > ASCII order) > > Oracle 10 (data is cas

Re: [GENERAL] Contrib source

On Thu, 2011-06-30 at 10:46 -0400, gnuo...@rcn.com wrote: > I'll need the contrib source, and I don't find it anywhere. I must not be > looking in the right place. > > Where might that be? http://www.postgresql.org/ftp/source/ -- Sent via pgsql-general mailing list (pgsql-general@postgresq

Re: [GENERAL] to_timestamp() and timestamp without time zone

On Thu, 2011-06-23 at 13:26 -0700, Adrian Klaver wrote: > On 06/23/2011 01:07 PM, Steve Crawford wrote: > > On 06/23/2011 12:30 PM, hernan gonzalez wrote: > >> > >> > >> On Thu, Jun 23, 2011 at 4:15 PM, Adrian Klaver > >> mailto:adrian.kla...@gmail.com>> wrote: > >> > >> On 06/23/2011 11:40 AM

Re: [GENERAL] Relative path specified for data_directory is not working as expected

On 06/23/2011 11:08 AM, Eduard-Cristian Stefan wrote: D:\me\usr\PostgreSQL\bin/pg_ctl.exe runservice -N "pgsql" -D "d:/me/etc/PostgreSQL" not very familiar with the windows version, but I think -D is supposed to point to the data directory which in your later info is listed as data_direct

[GENERAL] Can I safely remove what appear to be obsolete temp files

My postgresql instance was last started on Apr21. In my temp space directory, I have various files that I believe are orphaned. Given the information below, can I safely rm the files in /mnt/iscsi/psql_tmp/tmpdata/41099 that are older than Jun 22? If yes, should these files have been cleaned up b

Re: [GENERAL] Postgresql CBT

On 05/24/2011 01:02 PM, fork wrote: A psql prompt and the excellent postgresql documentation? if you're concerned about mucking something up, download a postgresql livecd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.po

Re: [GENERAL] Postgresql CBT

On 05/24/2011 10:49 AM, Scott Marlowe wrote: Oh good. My first response from google, with safe search turned off, was much more distressing... in other news, google trends for cbt just jumped -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscri

Re: [GENERAL] Web Hosting

On 3/5/2011 4:08 PM, matty jones wrote: I already have a domain name but I am looking for a hosting company that I can use PG with. The few I have contacted have said that they support MySQL only and won't give me access to install what I need or they want way to much. I don't need a dedicated

[GENERAL] orphaned?? tmp files

Given the below information, is it reasonable to assume that files in pgsql_tmp dated prior to 10 days ago can be safely removed? postgres@hw-prod-repdb1> uptime 15:01:35 up 10 days, 13:50, 3 users, load average: 1.23, 1.15, 0.63 postgres@hw-prod-repdb1> pwd /mnt/iscsi/psql_tmp/tmpdata postgr

Re: [GENERAL] select to_timestamp('02/26/2011 14:50', 'MM/DD/YYYY HH24MI')

On 02/25/2011 09:30 AM, akp geek wrote: Hi all - I have recently upgraded from 8.3 to 9.0.2. when I run the following sql in 9.0.2 "select to_timestamp('02/26/2011 14:50', 'MM/DD/ HH24MI') " I am getting the following error and the sql runs fine in older version Is it my installation

Re: [GENERAL] work_mem = 900MB but Sort Method: external merge Disk: 304008kB

On 02/22/2011 12:06 PM, Tom Lane wrote: > Reid Thompson writes: >> What am I missing that causes this to resort to sorting on disk? > > The in-memory space required to sort N tuples can be significantly > larger than the on-disk space, because the latter representation is >

[GENERAL] work_mem = 900MB but Sort Method: external merge Disk: 304008kB

What am I missing that causes this to resort to sorting on disk? obc=# select version(); version -- PostgreSQL 8.3.7 on x86_64-redhat-linux-gnu,

Re: [GENERAL] Tuning Postgres for single user manipulating large amounts of data

On Thu, 2010-12-09 at 17:40 +, Paul Taylor wrote: > what > have I got to be careful of. I think that was in reference to turning fsync off, not work_mem values.

Re: [GENERAL] Tuning Postgres for single user manipulating large amounts of data

On 12/09/2010 12:36 PM, Paul Taylor wrote: > On 09/12/2010 15:12, Reid Thompson wrote: >> On 12/09/2010 09:59 AM, Andy Colson wrote: >>> On 12/9/2010 8:50 AM, Andy Colson wrote: >>>> On 12/9/2010 6:25 AM, Paul Taylor wrote: >>>> You need to bump up your

Re: [GENERAL] Tuning Postgres for single user manipulating large amounts of data

On 12/09/2010 09:59 AM, Andy Colson wrote: > On 12/9/2010 8:50 AM, Andy Colson wrote: >> On 12/9/2010 6:25 AM, Paul Taylor wrote: >> You need to bump up your SHMMAX is your OS. > > sorry: SHMMAX _in_ your OS. > > its an OS setting not a PG one. > > -Andy > > scroll down to the section on OSX

[GENERAL] Group by and limit

Reposting as I noticed that the original was in reply to a different subject. Hey Folks – have a coded myself into a corner yet? I have a situation with a select count / group by / order by query that I need to limit each group to 500 entries. Not seeing a way to do this in a single query, do

Re: [GENERAL] Full Text Search - Slow on common words

On Thu, 2010-10-28 at 12:08 -0700, sub3 wrote: > Hi, > > I have a small web page set up to search within my domain based on keywords. > One of the queries is: > SELECT page.id ts_rank_cd('{1.0, 1.0, 1.0, 1.0}',contFTI,q) FROM page, > to_tsquery('steve') as q WHERE contFTI @@ q > > My pro

Re: [GENERAL] Cannot Start Postgres After System Boot

On Thu, 2010-10-21 at 11:45 -0700, Rich Shepard wrote: > On Thu, 21 Oct 2010, Scott Marlowe wrote: > > > So a postgres IS running on your machine. I put it to you it's not > > running where you think it is. > >When I run 'ps ax | grep post' I found a few postgres processes. I tried > '/etc/r

Re: [GENERAL] Cannot Start Postgres After System Boot

On Thu, 2010-10-21 at 11:38 -0700, Rich Shepard wrote: > On Thu, 21 Oct 2010, Reid Thompson wrote: > > > what does > > $ netstat -an |grep 5432 > > return? > > > > something is running on tcp port 5432 > >Doesn't show that. > > [rsh

Re: [GENERAL] Cannot Start Postgres After System Boot

On Thu, 2010-10-21 at 10:35 -0700, Rich Shepard wrote: > On Thu, 21 Oct 2010, Scott Marlowe wrote: > > > So, what do > > > > telnet localhost 5432 > > Scott, > >That port's clear: > > [rshep...@salmo ~]$ telnet localhost 5432 > Trying 127.0.0.1... > Connected to localhost. > Escape characte

Re: [GENERAL] Cannot Start Postgres After System Boot

On 10/20/2010 6:53 PM, Rich Shepard wrote: For reasons I do not understand, the Slackware start-up file for postgres (/etc/rc.d/rc.postgresql) fails to work properly after I reboot the system. (Reboots normally occur only after a kernel upgrade or with a hardware failure that crashes the system

Re: [GENERAL] list of databases in C ? libpq ?

On 5/7/2010 1:48 PM, Alex Hunsaker wrote: On Fri, May 7, 2010 at 11:18, Joao Ferreira gmail wrote: Hello all, I need to write an application in C to read the list of databases currently in the server. very much like a "psql -l"... The first example in the online docs does exactly that... h

Re: [GENERAL] how to clear server log

On Tue, 2010-02-23 at 13:49 -0500, Amy Smith wrote: > All > > do you clean up the server file by removing them > use google logrotate man logrotate -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/

Re: [GENERAL]

On Tue, 2010-02-23 at 13:50 -0500, Shu Ho wrote: > All > > do you clean up the server file by removing them > use > > find $logfile -mtime +$NUMBER_DAYS_TO_KEEP -type f -print -exec rm -f > {} \; > > in postgres ? > > How to remove the archive log files in postgres ? is the same way as

Re: [GENERAL] PostgreSQL fails to start

On 2/20/2010 4:42 PM, John Gage wrote: I have had the same/similar problem on a Mac. Postgres creates a user "postgres" and the only way that user can see files is for them to exist outside of any other particular user's home directory. I placed the files in the root directory!? I would like, I

Re: [GENERAL] PostgreSQL fails to start

On 2/20/2010 4:42 PM, John Gage wrote: I have had the same/similar problem on a Mac. Postgres creates a user "postgres" and the only way that user can see files is for them to exist outside of any other particular user's home directory. I placed the files in the root directory!? I would like, I

Re: [GENERAL] SQL select return into PSQL variables.

On Thu, 2010-02-18 at 09:33 -0600, Little, Douglas wrote: > psql p1gp1 <>$LOGFile 2>&1 > > \set ON_ERROR_STOP > > select da_test.QATestBuild(false) > > QUIT mod to your needs... $ cat dummy.sql #MYTESTID=`psql -t -c "select da_test.QATestBuild(false)" dbname` MYTS=`psql -t -c "select to

Re: [GENERAL] pg_database_size(oid)

On Wed, 2010-02-17 at 11:59 -0500, Dhimant Patel wrote: > > I have created a database, which I plan to load with several tables. I > am trying to find the size of the databases and came > across pg_database_size(oid) function. Since it requires databse oid, > I thought there must be a view where

Re: [GENERAL] number of page slots needed (1576544) exceeds max_fsm_pages (204800)]

On Mon, Jan 18, 2010 at 02:43:11PM -0500, Vick Khera wrote: > On Mon, Jan 18, 2010 at 1:47 PM, Reid Thompson wrote: > > Does this max_fsm_pages value seem OK for a 46GB database? > > I've clustered all the tables that seemed to be exhibiting large amounts > > of bloat.

[GENERAL] number of page slots needed (1576544) exceeds max_fsm_pages (204800)]

Does this max_fsm_pages value seem OK for a 46GB database? I've clustered all the tables that seemed to be exhibiting large amounts of bloat. reporting=# SELECT pg_size_pretty(pg_database_size('reporting')); pg_size_pretty 46 GB (1 row) NOTICE: number of page slots needed

Re: [GENERAL] Data Directory size increasing abnormally

utsav wrote: Dear All, I am using postgres 7.3 version on RHEL 4.0. You should upgrade to a newer/the latest stable release The commanddata field consists of binary data of a txt file whose size is between 1kb to 4kb and there is a high frequecy of updates on this table (approx twice in a

Re: [GENERAL] Partitioned table question

So we know have data in ~30 partitioned tables. Our requirements now necessitate adding some columns to all these tables ( done ) which will get populated via batch sql for the older tables and by normal processing as we move forward. The batch update is going to result in dead tuples in the older

[GENERAL] what is the best way to concat fields that may contain null as if they were empty strings

In the case where a_text is null, I essentially want the same result as the case when a_text = ''. would this: select a_int || coalesce(a_text,'') from test1 where a_int = 102; be the proper way? postgres=# \d test1 Table "public.test1" Column |

Re: [GENERAL] computed values in plpgsql

On Tue, 2009-09-29 at 07:54 -0400, Merlin Moncure wrote: > you are missing some quotes in there. also, don't use 'values', use > select. see my example above: > execute 'insert into foo_something select (''' || new::text || '''::foo).*'; > > the actual query should look like: > insert into paym

Re: [GENERAL] computed values in plpgsql

On Mon, 2009-09-28 at 11:05 -0400, Reid Thompson wrote: > We have a set of tables that we're partitioning by year and month - > We can't seem to quite get it right... This is our quick stub test. -- -- Tables: -- CREATE TABLE payments ( id seria

Re: [GENERAL] computed values in plpgsql

On Mon, 2009-09-28 at 12:42 -0400, Merlin Moncure wrote: > the best way to do this is very version dependent. the basic trick is > to use text cast to pass a composite type into the query sting. > > one way: > execute 'insert into foo_something select (' || new::text || '::foo).*'; > > you can

[GENERAL] computed values in plpgsql

We have a set of tables that we're partitioning by year and month - e.g. payments_parent, partitioned into payments_200901, payments200902, ... and inquiries_parent, partitioned into inquiries_200901, inquiries_200902, ... Each table has a timestamp field import_ts that can be used to partition

[GENERAL] Partitioned table question

Assuming the examples on http://www.postgresql.org/docs/8.3/static/ddl-partitioning.html where measurement has children as noted CREATE TABLE measurement ( city_id int not null, logdate date not null, peaktempint,

[GENERAL] iGen with PostgreSQL 8.4 on Sun Fire X4140

may be of interest -- http://blogs.sun.com/jkshah/entry/igen_with_postgresql_8_4 -- 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] Does anyone know of a job scheduler that uses PostgreSQL?

On Wed, 2009-07-01 at 16:16 -0500, Anthony Caduto wrote: > I am looking for something similar to: > http://www.arcanadev.com/adtempus/ but without the MS SQL server > dependency. > > Thanks, > > Tony > http://www.opensymphony.com/quartz/ might fit the bill -- Sent via pgsql-general mailing

Re: [GENERAL] running postgresql on a private machine accessing it from public web pages

Keith D. Evans wrote: We usually run postgresql on a private machine (gravity) but due to space, we have moved the database to a different machine through afs (a local network at the university). We do not want the private machine to be accessible to outside users, so our web pages are on the u

[GENERAL] how can i migrate just the users from one db to a new one

I've a DB and I want to migrate the users to a new empty DB. How do I dump/reload just the users? Thanks, reid -- 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] Matching against a field case in-sensitive.

James Dooley wrote: Hi, Since PostgreSQL is by default case sensitive, I would like to know if it is possible to do a search or somehow set the column in a relation to be case insensitive (on search at least). I would however like to store it case sensitive so I can display it as it was sto

Re: [GENERAL] [findings] minimal open source e-commerce software for pg

Ivan Sergio Borgonovo wrote: On Sat, 7 Feb 2009 01:43:10 +0100 Ivan Sergio Borgonovo wrote: I need to build up a minimal e-commerce website on a host that is already running postgresql. Requirement is minimal. Usual configurable pretty standard couple of paying/shipping system and popular eno

Re: [GENERAL] Use PSQLFS for photo storage

On Tue, 2009-01-13 at 18:22 -0600, Jason Long wrote: > Never used Python or Perl. I use primarily Java. I was thinking of > doing something like > INSERT INTO pictures (filename,data) VALUES > ('filename','/path/to/my/image/img0009.jpg'); > > But, this syntax doesn't seem to be supported. > >

Re: [GENERAL] db backup script in gentoo

Scott Marlowe wrote: On Sun, Nov 30, 2008 at 1:18 PM, Andrus <[EMAIL PROTECTED]> wrote: Sorry, I'm no gentoo expert. It's certainly not the first distro I'd recommend to someone just starting out with linux / unix. Time to break out the google. I also found quite a few example scripts for lft

Re: [GENERAL] Database access over the Internet...

Michelle Konzack wrote: Am 2008-11-08 19:07:35, schrieb Scott Marlowe: No, your histrionics aside, it's the way this list works by default, and for good reason. If you need it to work differently, there's a setting which has been pointed out to you at two times now. Please take responsibility

Re: [GENERAL] Piping CSV data to psql when executing COPY .. FROM STDIN

Allan Kamau wrote: Reid Thompson wrote: Allan Kamau wrote: Sam, I have been unable to understand your shell script well enough to use it. Seems am slow this afternoon :-) On this list I saw a message detailing using copy as illustrated below (see )when I run this command I get the following

Re: [GENERAL] Piping CSV data to psql when executing COPY .. FROM STDIN

Allan Kamau wrote: Sam, I have been unable to understand your shell script well enough to use it. Seems am slow this afternoon :-) On this list I saw a message detailing using copy as illustrated below (see )when I run this command I get the following output (see ) COPY abc FROM STDIN WIT

Re: [GENERAL] Cannot connect to server

On Fri, 2008-09-05 at 11:44 +0200, Filip Rembiałkowski wrote: > > is the server running (see process list, ps ax | grep postgres) > does the socket file exist? (see filesystem, ls -l /tmp/.s.PGSQL.5432) Since you say things work for several days, then stop -- make sure there's no braindead automa

Re: [GENERAL] Regression failing on build -> ERROR: could not access file "$libdir/plpgsql": No such file or directory

On Fri, 2008-08-15 at 16:37 -0400, Tom Lane wrote: > Reid Thompson <[EMAIL PROTECTED]> writes: > > Would plpgsql.so get built with.. > > > ./configure --prefix=/usr/local/pgsql833 --without-r

Re: [GENERAL] Regression failing on build -> ERROR: could not access file "$libdir/plpgsql": No such file or directory

On Fri, 2008-08-15 at 11:03 -0400, Tom Lane wrote: > Reid Thompson Woulwrites: > > I'm getting this failure on compilation. Could someone point me in the > > direction of a fix? > > You probably ought to inquire into the cause of these: > > gmake[2]: stat:regre

[GENERAL] Regression failing on build -> ERROR: could not access file "$libdir/plpgsql": No such file or directory

I'm getting this failure on compilation. Could someone point me in the direction of a fix? Thanks, reid System: AIX 5.3 $ uname -a AIX aix53-dev-1 3 5 000B357F4C00 Configuration params: ./configure --prefix=/usr/local/pgsql833 --without-readline --disable-shared The Error: ...SNIP... /usr/bi

Re: [GENERAL] Disk space occupied by a table in postgresql

On Sat, 2008-08-09 at 04:59 -0400, Fouad Zaryouh wrote: > Hi Aravind, > > Run the following query > > SELECT relname, reltuples, relpages * 8 / 1024 AS "MB" FROM pg_class > ORDER BY relpages DESC; > > > > relname = table name > relpages = size in MB > reltuples = number of rows. > > Hope this

Re: [GENERAL] loading a psql input file on win xp

On Mon, 2008-03-10 at 06:55 +, Raymond O'Donnell wrote: > On 09/03/2008 22:33, Reid Thompson wrote: > > On Sun, 2008-03-09 at 19:41 +, Raymond O'Donnell wrote: > >> On 09/03/2008 15:34, Reid Thompson wrote: > >> > >>> you'll also pro

Re: [GENERAL] loading a psql input file on win xp

On Sun, 2008-03-09 at 19:41 +, Raymond O'Donnell wrote: > On 09/03/2008 15:34, Reid Thompson wrote: > > > you'll also probably have to add the parameter -h 127.0.0.1 > > psql defaults to connecting to the local machine unless you tell it > otherwise,

Re: [GENERAL] loading a psql input file on win xp

akshay bhat wrote: HELLO i have psql file which is to be used for loading a database it was downloaded from this link http://conceptnet.media.mit.edu/ the description says The ConceptNet 3 database, as a PostgreSQL input file. You will need to be running a PostgreSQL server to install ConceptNe

Re: [GENERAL] Auto incrementing primary keys

On Mon, 2008-02-18 at 17:46 +, Raymond O'Donnell wrote: > On 18/02/2008 13:14, pgsql_user wrote: > > so wouldnt I run out of ids one day, if there are lot of failed insert > > statements, lets say for every successful insert there are 50 > > unsuccessful inserts, so ids would be 1, 50, 100, an

Re: [GENERAL] reporting tools

On Wed, 2007-08-22 at 18:57 -0400, Geoffrey wrote: > We are looking for a reporting tool that will enable users to generate > their own reports. Something like Crystal Reports. > > Anyone using something like this with Postgresql? > agata, datavision, jasper reports, birt, openRPT -- google s

Re: [GENERAL] Linux distro

Andrej Ricnik-Bay wrote: On 8/2/07, Reid Thompson <[EMAIL PROTECTED]> wrote: If it's a dedicated production server, look at UBUNTU 6.10 server. If you're planning to connect a monitor and run X-windows ( i.e. I bought a server, but i'm going to use it as a learning

Re: [GENERAL] Linux distro

On Wed, 2007-08-01 at 13:29 +0200, [EMAIL PROTECTED] wrote: > Hello, > > I bought a Dell server and I am going to use it for installing PostgrSQL > 8.2.4. I always used Windows so far and I would like now to install a > Linux distribution on the new server. Any suggestion on which distribution >

Re: [GENERAL] Help with date math

Chris Hoover wrote: I need some help. I am trying to replicate a function from Sybase ASA, and am having difficulty. I need to be able to subtract 2 date (or timestamps) and return the results expressed in days, weeks, month, quarters, or years. How do I do this? I believe Postgres is ret

Re: [GENERAL] Help with date math

Chris Hoover wrote: I need some help. I am trying to replicate a function from Sybase ASA, and am having difficulty. I need to be able to subtract 2 date (or timestamps) and return the results expressed in days, weeks, month, quarters, or years. How do I do this? I believe Postgres is ret

Re: [GENERAL] free scheduled import utility

On Tue, 2007-07-10 at 14:32 +0200, Zlatko Matic wrote: > Hello. > Is there any free program/utility for batch imports from .csv files, that > can be easily scheduled for daily inserts of data to PostgreSQL tables? > Regards, > > Zlatko > > > ---(end of broadcast)--

[GENERAL] PostgreSQL question re select for update (locking??)

Hello list, We are using PostgreSQL 8.0.3. Some background, and a couple of questions.. We have a database table called "jobq" on the database machine, and 2 networked server machines. One of the network server machines has around 20 server processes connecting over the network using ODBC. These

Re: [GENERAL] Postgres data/form entry tool

On Thu, 2007-04-19 at 10:05 -0500, Tony Caduto wrote: > David Potts wrote: > > Can any body recommend a generic opensource data entry tool that can be > > used to make some simple forms for entering data in to postgres? > > > > > > ---(end of broadcast)-

Re: [GENERAL] Acces via applets

Marc wrote: what version of PostgreSQL? what version of the jdbc driver? The bottom line question is can an applet served to a client machine other than the one the postrgres db resides on read that db? I can't see why not. An applet I’ve written and tested on the same box as my database

Re: [GENERAL] Shell script to determine if PostgreSQL is accepting connections?

On 10:44 Sun 18 Mar , Jeff Ross wrote: > Hi, > > Is there a simple way to determine with a shell script if PostgreSQL is > ready to accept connections? > > PostgreSQL is started and controlled by daemontools. This shell script > is called by the /etc/netstart script as a part of bringing up t

Re: [GENERAL] proper export table to csv? multilineproblem.

On Mon, 2007-02-26 at 13:20 -0500, Reid Thompson wrote: > On Mon, 2007-02-26 at 14:54 +0100, peter pilsl wrote: > > I need to export several tables as csv. I use the \f-command to set the > > seperator and pipe the output of my select directly to a file. > > > >

Re: [GENERAL] proper export table to csv? multilineproblem.

On Mon, 2007-02-26 at 14:54 +0100, peter pilsl wrote: > I need to export several tables as csv. I use the \f-command to set the > seperator and pipe the output of my select directly to a file. > > Unfortunately thats all the control I have over the created csv-file. I > cannot > set the field-d

Re: [GENERAL] Testing embedded SQL in C

On Mon, 2007-02-12 at 15:16 -0500, HT NB wrote: > Hi, > > How are you doing? > > First, I am testing if this email address is valid. It is the first > time that I am using this account. I have a question about how to > start write embedded SQL in C programming code. What are the basic > requireme

Re: [GENERAL] Sample C++ code using libpqxx/Postgresql sought

On Fri, 2007-01-26 at 12:16 -0800, [EMAIL PROTECTED] wrote: > I am looking for some sample code using the libpqxx (C++) API for > Postgresql. I have found some tutorials > > (http://thaiopensource.org/devprojects/libpqxx/doc/2.6.8/html/Tutorial/ > http://www.cs.wisc.edu/~ajkunen/libpqxx-2.4.2/Tut

Re: [GENERAL] GUI tool that can reverse engineering schemas

John McCawley wrote: Here's a little tool I wrote: http://www.hardgeus.com/projects/pgdesigner/ I have a Windows binary up there. The build process is currently a mess, sorry. It's a pretty decent little tool for quick-and-dirty visualization, which is all I really use it for. nyenyec wrot

Re: [GENERAL] function for current date-time

On Mon, 2006-10-16 at 14:56 -0400, Harpreet Dhaliwal wrote: > Hi, > I have a timestamp field in my table and want to set a default value > of current date/time for it. > What should i enter as its default value? is there any function like > now() in postgres? > > Thanks, > ~Harpreet test=# selec

[GENERAL] [Fwd: Realizing the Value of Enterprise Open Source Databases] -- May be of interest -- re Sony Online's use of Enterprise DB

Ziff Davis Media eSeminars: The Online Seminar Standard Realizing the Value of Enterprise Open Source Databases: How Sony Online Entertainment Replaced Oracle with EnterpriseDB October 12, 2006 @ 12:00 p.m. Eastern/9:00 a.m. Pacific Duration: 60 minutes Register & Attend Online http://ct.enews.e

Re: [GENERAL] postmaster: StreamConnection: accept: No such device

Larry Rosenman wrote: Reid Thompson wrote: Using a legacy installation ( 7.2.3 ). Occasionally the system will reach a state where attempted psql connection attempts fail, with the following error in the postgresql log: postmaster: StreamConnection: accept: No such device or address Will

[GENERAL] postmaster: StreamConnection: accept: No such device or address

Using a legacy installation ( 7.2.3 ). Occasionally the system will reach a state where attempted psql connection attempts fail, with the following error in the postgresql log: postmaster: StreamConnection: accept: No such device or address Will also occasionally get "no connection to server" erro

Re: [GENERAL] ECPG usage

Jasbinder Bali wrote: Hi Can anyone help me with the usage of ECPG?? Like how to go about it, what all header files to include in my C file and other things that i need to give due considerations before using ECPG ~Jas see /src/interfaces/ecpg ( test has several examples ) --

Re: [GENERAL] problemas con psql -l

Eliana Providel wrote: Hola a todos Estoy trabajando con postgresql y tengo el siguiente problema cuando intento listar todas las bases de datos existentes con "psql -l" me sale el siguiente error: ERROR: no existe la relación "pg_catalog.pg_user" Puedo crear bases de datos y acceder a ellas

Re: [GENERAL] SOLVED - background writer process (PID 1400) exited

Reid Thompson wrote: PG_VERSION 8.1 - windows XP - 1GB RAM -- Desktop workstation, PG used for test/dev. This installation has been working fine for quite a while. I've used it minimally. I rebooted yestderday- log file from reboot 2006-05-18 12:24:32 LOG: database system was shut do

[GENERAL] background writer process (PID 1400) exited with exit code 0 -- repeatedly && incomplete startup packet

PG_VERSION 8.1 - windows XP - 1GB RAM -- Desktop workstation, PG used for test/dev. This installation has been working fine for quite a while. I've used it minimally. I rebooted yestderday- log file from reboot 2006-05-18 12:24:32 LOG: database system was shut down at 2006-05-18 12:23:08 E

  1   2   >