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] 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] 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] 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

[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] 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)--

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] 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] 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] 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] 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] 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 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 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] 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

[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] 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

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 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.

[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] 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 >

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

[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] 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

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] 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] 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] 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] 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] 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

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] 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

[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

[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] 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

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

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 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

[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] 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

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] 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] 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

[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] 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

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] 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] 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

[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

[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] 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

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] 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] 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...

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] 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

[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] 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

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] 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] 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] 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] 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] 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] 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

[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] 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.

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] 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] 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]

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] 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/

[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] 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

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

[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] 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

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] [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] 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

[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] 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] pg_dump: ERROR: Memory exhausted in AllocSetAlloc(875574064)

Is there any solution to this other than adding memory, or am I mis-understanding the error? pg_dump: ERROR: Memory exhausted in AllocSetAlloc(875574064) pg_dump: lost synchronization with server, resetting connection pg_dump: SQL command to dump the contents of table "table_name" failed: PQendco

Re: [GENERAL] pg_dump: ERROR: Memory exhausted in AllocSetAlloc(875574064)

Tom Lane wrote: > "Reid Thompson" <[EMAIL PROTECTED]> writes: >> Is there any solution to this other than adding memory, or am I >> mis-understanding the error? > >> pg_dump: ERROR: Memory exhausted in AllocSetAlloc(875574064) >> pg_dump: lost syn

[GENERAL] DB/clog corruption

I've a db table generating the error below on pg_dump. Per the archives, i've tried creating a clog file 1559 but w/o success ( continue to get the same error) even when i extended the clog file to > 64K. Are there other options to recovering this table? Do i need to extend clog 1559 to a greate

Re: [GENERAL] DB/clog corruption

Tom Lane wrote: > "Reid Thompson" writes: >> $ pg_dump -f table_dump.sql -t table_with_error dbname >> FATAL 2: read of clog file 1559, offset 0 failed: Success > > You've got a clobbered tuple header in that file (ridiculous > xmin or xmax value). Alterna

Re: [GENERAL] Insert ImageFile in PostgreSQL

[EMAIL PROTECTED] wrote: I'm sorry, but I know only the basics about DBMs, but I think is not possible to put a image file INSIDE a database. You can put in a database the path of the file... (Maybe I'm wrong...) See ya! ---(end of broadcast)--

[GENERAL] postgresql hosting

Someone questioned a while back about hosting providers for PostgreSQL -- a recent post led to finding http://www.planetargon.com/hosting/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Select gives the wrong results

> Crystle Numan wrote: >> Dear all: >> >> I am fairly knowledgeable about PostgreSQL but this behaviour is >> stumping me. Any help would be wonderful. If you think it is a bug, >> let me now and I'll file one. >> >> (select values in DB (date stamps) between Jan 1, 2000 and Jan 1, >> 2005, no

Re: [GENERAL] newbie - postgresql or mysql

Michael Fuhr wrote: > [Please copy the mailing list on replies so others can > contribute to and learn from the discussion. Also, please > don't top-post, as it destroys the flow of the discussion; > I've moved your questions to a more logical place.] > > On Wed, Aug 31, 2005 at 03:49:57PM -0600,

Re: [GENERAL] ECPG examples...

Title: Message see the contrib directory,,, i think there is also a simple example in the docs...     reid -Original Message-From: Cristian Prieto [mailto:[EMAIL PROTECTED] Sent: Thursday, September 01, 2005 4:10 PMTo: pgsql-general@postgresql.orgSubject: [GENERAL] ECPG

Re: [GENERAL] ECPG examples...

Title: Message http://tutorials.findtutorials.com/read/id/185/headline/Professional+Linux+Programming+Part+3+-+ECPG      reid -Original Message-From: Cristian Prieto [mailto:[EMAIL PROTECTED] Sent: Thursday, September 01, 2005 4:10 PMTo: pgsql-general@postgresql.orgSubject:

[GENERAL] If an index is based on 3 columns will a query using two of the columns utilize the index?

Example: assume a table of 10 columns, three of which are fname, lname, and dob. If an index is created on (fname, lname, dob), will a query that utilizes two of the columns ( select 'data' from table where fname = 'X' and lname = 'Y') utilize the index? thanks, reid --

Re: [GENERAL] If an index is based on 3 columns will a query using two of the columns utilize the index?

Alvaro Herrera wrote: > On Mon, Sep 12, 2005 at 09:43:57AM -0400, Reid Thompson wrote: >> Example: >> assume a table of 10 columns, three of which are fname, lname, and >> dob. If an index is created on (fname, lname, dob), will a query that >> utilizes two of the c

Re: [GENERAL] Utility that creates table schema from csv data?

Richard Huxton wrote: > CSN wrote: >> Probably wishful thinking, but who knows - maybe >> there's something in contrib! I have a bunch of csv >> data with the field names specified on the first line >> of the various files. Is there any such utility that >> will create a table schema using the fiel

Re: [GENERAL] Arrrr... date formatting.

Title: Message provide an example of what you're trying to do.   test=>  select date_part('month',current_date);    date_part --- 9(1 row)   test=> select length(date_part('month',current_date)); length   1(1 row)         reid -Original Message-Fr

Re: [GENERAL] character varying == text?

Scott Marlowe wrote: > On Mon, 2005-09-19 at 12:54, Alex Turner wrote: >> I thought a char field was supposed to return a padded string, and >> varchar was supposed to return a non-padded string? >> >> I just checked though: >> >> create table test ( >> stuff char(10) >> ); >> >> insert into tes

[GENERAL] Does copy abort on a failed insertion?

If i have a pg_dump that is using COPY, and midway through the copy an insert fails due to a unique constraint, will the COPY continue with the rest of the records, or will it abort? If it aborts, will it perform a rollback on the inserts up to that point? thanks, reid --

  1   2   >