[GENERAL] Broken after upgrade

2016-07-06 Thread Jerry LeVan
> I am left today, after an upgrade I think (Fedora 23 --> 24) with a > broken postgresql. > > It used to work very well. The service is started with the systemd > unit file. I have now this error: > > - > postgres@thetradinghall 筐、筐、 systemd/system % > /usr/libexec/postgresql-ctl

[GENERAL] Is it safe...( Upgrade questions)

2010-11-01 Thread Jerry LeVan
I am trying to screw up the courage to update my systems ( 2 macs, 2 fedora ) from the last 8.4 postgresql updates to the latest 9.0.1 versions. I have a couple of concerns... 1) I have developed my own gui apps using tcl/tk and wxpython for accessing and maintaining my db's. I use psyco

[GENERAL] Pgadmin for Fedora 14?

2010-11-29 Thread Jerry LeVan
Hi, Is there a Fedora 14 rpm for pgadmin that works out of the box for pg 8 and pg 9? Thanks, Jerry Trapped in Steve Jobs Reality Distortion Field -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgs

[GENERAL] iPad and Postgresql...

2011-01-16 Thread Jerry LeVan
Hi, I have an iPad and a small network of macs and fedora/windoze machines at home. I am running pg 8.4.4 on all of the 'real' computers. I have been hoping that some developer would create an iPad app that would allow me to access my home database ( i am getting a bit long in the tooth and re

Re: [GENERAL] iPad and Postgresql...

2011-01-17 Thread Jerry LeVan
On Jan 17, 2011, at 10:48 AM, John DeSoi wrote: > > On Jan 16, 2011, at 7:40 PM, Andrej wrote: > >>> Is there an idiot installable package for MacOsX Snow Leopard that will >>> provide a 'better' user experience for accessing Pg via the web, especially >>> when viewed on the iPad? >> >> It's n

Re: [GENERAL] iPad and Postgresql...

2011-01-17 Thread Jerry LeVan
On Jan 17, 2011, at 11:30 AM, Gary Chambers wrote: > Jerry, > >>> http://www.gnegg.ch/2009/08/snow-leopard-and-php/ >> It sorta looks like the above might blow away the existing php stuff... > > Have you considered using the MacPorts version? That's what I use for > development on my Macs and

[GENERAL] How can I find a schema that a table belong to?

2011-01-19 Thread Jerry LeVan
Hi, I am trying to tidy up my perl script that runs as a cgi and allows remote users (aka me) to interact with my Pg database. I primarily want to use this tool as a way for my iPad to browse my data base. It seems to be working quite well but one certainly does not want to 'select * from ginor

[GENERAL] How can I find the schema that a table belongs to?

2011-01-19 Thread Jerry LeVan
Hi, I am trying to tidy up my perl script that runs as a cgi and allows remote users (aka me) to interact with my Pg database. I primarily want to use this tool as a way for my iPad to browse my data base. It seems to be working quite well but one certainly does not want to 'select * from ginorm

Re: [GENERAL] How can I find the schema that a table belongs to?

2011-01-19 Thread Jerry LeVan
On Jan 19, 2011, at 3:12 PM, DM wrote: > one of the way to find out schema name is like below > > select * from pg_tables where tablename like '%xyz%'; > schemaname | tablename | tableowner | tablespace | hasindexes | hasrules | > hastriggers > +---++-

[GENERAL] iPad and Pg revisited...

2011-01-24 Thread Jerry LeVan
I have cleaned up my simple Perl cgi script for accessing Postgresql db's... Thanks to Tom Lane's (aka the Wizard) hints the 'describe ' function now works :) The url: http://homepage.mac.com/levanj/Perl I also found a mac php package that has postgresql support ( My mac php systems do *not

Re: [GENERAL] iPad and Pg revisited...

2011-01-30 Thread Jerry LeVan
Trapped in Steve Jobs Reality Distortion Field On Jan 25, 2011, at 8:21 AM, John DeSoi wrote: > > On Jan 24, 2011, at 3:25 PM, Jerry LeVan wrote: > >> I assume that if I were to jump to Pg 9.x.x that phpPgAdmim would die, yes? > > I have not tried it, but my guess is

[GENERAL] Create Table Question...

2011-01-31 Thread Jerry LeVan
The docs ( 9.0.2) for create table asserts that a data type representing a row of the table is automatically created. Tain't clear to me what this means... Here is a fragment of sql that I frequently use: * insert into checks (select * from dblink('select * from checks where date

[GENERAL] Yosemite (OSX 10.0) problems with Postgresql

2014-10-20 Thread Jerry Levan
I just upgraded one of my Mac computers to Yosemite and am having a small problem. 1) The upgrade evidently *deletes* directories pg_tblspc, pg_twophase, and pg_stat_tmp from the postgresql data directory. Google said to recreate the missing directories and indeed Postgresql then was able

Re: [GENERAL] Yosemite (OSX 10.0) problems with Postgresql

2014-10-20 Thread Jerry Levan
On Oct 20, 2014, at 7:45 AM, Michael Paquier wrote: > > > On Mon, Oct 20, 2014 at 9:26 PM, Jerry Levan wrote: > 1) The upgrade evidently *deletes* directories pg_tblspc, pg_twophase, and > pg_stat_tmp from >the postgresql data directory. Google said to re

[GENERAL] configure can't find libcrypto on MacOS Sierra for pg 9.6.2

2017-02-12 Thread Jerry LeVan
Hello, I am trying to build pg 9.6.2 on my MacOS Sierra but configure is being balky configure:9494: checking for CRYPTO_new_ex_data in -lcrypto configure:9519: gcc -o conftest -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-for mat-attribute -Wfo

Re: [GENERAL] configure can't find libcrypto on MacOS Sierra for pg 9.6.2

2017-02-12 Thread Jerry LeVan
Sigh, I will try to build without OpenSSL… My database is seventeen years old, I don’t even remember which Postgresql I started out with... Jerry > On Feb 12, 2017, at 10:53 AM, Tom Lane wrote: > > Jerry LeVan writes: >> Hello, I am trying to build pg 9.6.2 on my M

[GENERAL] 64 and 32 bit libpq

2017-02-12 Thread Jerry LeVan
Hello, I am trying to upgrade my postgresql ‘stuff’ to 64 bits from 32 bits. I am running MaxOS Sierra. I have built the 64 bit version of the server and have loaded my database into the new server ( 9.6.2 ). Everything seems to be working. I have some legacy apps that are 32 bit and talk to the

[GENERAL] Strange Errors...

2017-02-22 Thread Jerry LeVan
Sorry I accidentally posted this to pgsql-general-owners earlier today… How can this happen ( from the postgresql.log file) LOG: statement: select * from knives where manufacturer=‘Boker’ ERROR: column "‘boker’" does not exist at character 41 Some background: I am trying to move from 3

Re: [GENERAL] Strange Errors...

2017-02-22 Thread Jerry LeVan
> On Feb 22, 2017, at 9:20 AM, Adrian Klaver wrote: > > On 02/22/2017 07:09 AM, Jerry LeVan wrote: >> Sorry I accidentally posted this to pgsql-general-owners earlier today… >> >> How can this happen ( from the postgresql.log file) >> >> LOG:

Re: [GENERAL] Strange Errors...

2017-02-22 Thread Jerry LeVan
> On Feb 22, 2017, at 9:49 AM, Adrian Klaver wrote: > > On 02/22/2017 07:32 AM, Jerry LeVan wrote: >> >>> On Feb 22, 2017, at 9:20 AM, Adrian Klaver >>> wrote: >>> >>> On 02/22/2017 07:09 AM, Jerry LeVan wrote: >>>> Sorry I

Re: [GENERAL] Strange Errors...

2017-02-22 Thread Jerry LeVan
> On Feb 22, 2017, at 10:08 AM, Jerry LeVan wrote: > >> >> On Feb 22, 2017, at 9:49 AM, Adrian Klaver wrote: >> >> On 02/22/2017 07:32 AM, Jerry LeVan wrote: >>> >>>> On Feb 22, 2017, at 9:20 AM, Adrian Klaver >>>> wrote: >

[GENERAL] phpPgAdmin 6 on a MAC (High Sierra)

2017-10-06 Thread Jerry Levan
Apple has added PostgreSQL support to php in High Sierra. PhpPgAdmin seems to have died at Version 5.1 and it does not play nice with php 7.x. There is a fork called phpPgAdmin 6. I have been able to get the interface up but selecting a database results in an error. My php-foo is weak...has a

[GENERAL] Universal libpq.a ?

2008-02-04 Thread Jerry LeVan
Hi, I am trying to bring one of my Cocoa based Postgresql browsers up to date. I would like to create a "universal", ie works on PPC and Intel Macintosh platforms, version of the application. I guess the initial task would be to build a universal version of libpq.a. In the past I have cr

Re: [GENERAL] Universal libpq.a ?

2008-02-04 Thread Jerry LeVan
On Feb 4, 2008, at 1:25 PM, Tom Lane wrote: "Dave Page" <[EMAIL PROTECTED]> writes: The Mac build of EDB Postgres is universal throughout, Yeah? How painful is it? We've had more than one request to enable universal builds. regards, tom lane Here is a config file

[GENERAL] Snow Leopard and PG 8.4 problems....

2009-08-29 Thread Jerry LeVan
Gh, Last week postgresql was working fine, yesterday I upgraded to Snow Leopard... Everything seemed to be working and then I tried to move some rows to another machine via dblink. I am getting a variety of failures on dblink_connect.. mbp is my main machine let me connect to my home serve

Re: [GENERAL] Snow Leopard and PG 8.4 problems....

2009-08-29 Thread Jerry LeVan
On Aug 29, 2009, at 2:40 PM, Martin Gainty wrote: for superusers only dblink-connect takes a libpq style connection string with hostaddr as first attribute dblink("hostaddr=127.0.0.1 port=5432 dbname=mydb user=postgres password=mypasswd"); http://www.postgresql.org/docs/current/static/c

[GENERAL] Snow Leopard and plpython problem

2009-09-03 Thread Jerry LeVan
Hi I am having a problem building Postgresql 8.4.0 in Snow Leopard. I cannot get plpython to build... I have installed MacPython 2.6.2 in /Library/Frameworks/Python.framework The binary: mbp:postgresql-8.4.0 postgres$ which python /Library/Frameworks/Python.framework/Versions/Current/bin/pytho

Re: [GENERAL] Snow Leopard and plpython problem

2009-09-03 Thread Jerry LeVan
On Sep 3, 2009, at 11:01 AM, Jan Otto wrote: hi jerry, Hi I am having a problem building Postgresql 8.4.0 in Snow Leopard. I cannot get plpython to build... I have installed MacPython 2.6.2 in /Library/Frameworks/ Python.framework do you really need python 2.6.2? snow leopard has python 2

[GENERAL] More Snow Leopard problems...

2009-09-06 Thread Jerry LeVan
I have compiled a 32 bit ( CC="gcc -arch i386" ) version of PG 8.4.0. I am finding the following in the pg logfile when I stop then start the postgresql server. LOG: received smart shutdown request LOG: shutting down LOG: database system is shut down could not lookup DNS configuration info se

Re: [GENERAL] More Snow Leopard problems...

2009-09-07 Thread Jerry LeVan
On Sep 6, 2009, at 7:29 PM, Tom Lane wrote: Jerry LeVan writes: I have compiled a 32 bit ( CC="gcc -arch i386" ) version of PG 8.4.0. Since that's not the default on SL, have you tried 64 bit? could not lookup DNS configuration info service: (ipc/send) invalid desti

Re: [GENERAL] More Snow Leopard problems...

2009-09-07 Thread Jerry LeVan
On Sep 7, 2009, at 11:36 AM, Adrian Klaver wrote: On Monday 07 September 2009 6:03:28 am Jerry LeVan wrote: On Sep 6, 2009, at 7:29 PM, Tom Lane wrote: Jerry LeVan writes: I have compiled a 32 bit ( CC="gcc -arch i386" ) version of PG 8.4.0. Since that's not the default

Re: [GENERAL] More Snow Leopard problems...

2009-09-07 Thread Jerry LeVan
On Sep 7, 2009, at 9:37 AM, Jan Otto wrote: hi jerry, could not lookup DNS configuration info service: (ipc/send) invalid destination port LOG: could not resolve "localhost": nodename nor servname provided, or not known LOG: disabling statistics collector for lack of working socket WARNING:

[GENERAL] How can I make a two arch libpq for snow leopard?

2009-09-19 Thread Jerry LeVan
Hi, I have a i386 version of postgresql 8.4.1 created by setting export CC="gcc -arch i386" an then doing the config, make and make install. In particular libpq is an i386 library. Now I use two database 'adaptors' psycopg2 for python and pgtcl-ng for tcl. The python I use is from python.or

Re: [GENERAL] How can I make a two arch libpq for snow leopard?

2009-09-20 Thread Jerry LeVan
On Sep 20, 2009, at 7:47 PM, Scott Ribe wrote: The only thing that comes to mind is two separate build trees, one 32bit and the other 64bit and then somehow gluing the two libpqs together... Basically, probably the easiest way to proceed--man lipo to figure out how to combine the librar

[GENERAL] Log File Melancholy

2009-09-23 Thread Jerry LeVan
Hi, I have two Snow Leopard installations, a macbook pro and a mac mini. Whenever I start the postgresql system on the mbp the log shows: LOG: received smart shutdown request LOG: shutting down LOG: database system is shut down could not lookup DNS configuration info service: (ipc/send) inva

Re: [GENERAL] Log File Melancholy

2009-09-24 Thread Jerry LeVan
On Sep 23, 2009, at 7:46 PM, Tom Lane wrote: Jerry LeVan writes: could not lookup DNS configuration info service: (ipc/send) invalid destination port LOG: could not resolve "localhost": nodename nor servname provided, or not known LOG: disabling statistics collector for lack

[GENERAL] In a moment of madness I destroyed...

2014-02-02 Thread Jerry Levan
Today I updated my fedora machine from f19 to f20 without taking a data dump. When ‘fedup’ finished my 9.2.x binaries were updated to 9.3.x and postgresql can no longer start… I have all of the tables on another machine ( a mac running 9.1.x postgresql) so no important data was lost. ( My db c

[GENERAL] Thousands of errors...what happened?

2014-03-24 Thread Jerry Levan
The other day I attempted to connect to my 9.3.2 postgresql data base and my connection attempts kept failing. I found about 10 lines in the log file that looked like: ERROR: could not seek to end of file "global/12292": Too many open files LOG: out of file descriptors: Too many open files

Re: [GENERAL] Thousands of errors...what happened?

2014-03-24 Thread Jerry Levan
On Mar 24, 2014, at 11:30 AM, Sergey Konoplev wrote: > On Mon, Mar 24, 2014 at 9:14 AM, Jerry Levan wrote: >> ERROR: could not seek to end of file "global/12292": Too many open files >> LOG: out of file descriptors: Too many open files; release and retry > [...]

[GENERAL] Installing Fedora 15 hosed my db...

2011-06-16 Thread Jerry LeVan
Yesterday I upgraded from fedora 14 to fedora 15... The install process sorta trashed my 8.4 db...here is what I have: postgresql-server-9.0.4-1.fc15.i686 postgresql-pltcl-8.4.4-1PGDG.fc12.i386 postgresql-docs-8.4.4-1PGDG.fc12.i386 postgresql-libs-9.0.4-1.fc15.i686 postgresql-contrib-8.4.4-1PGDG.f

Re: [GENERAL] Installing Fedora 15 hosed my db...

2011-06-16 Thread Jerry LeVan
On Thu, 2011-06-16 at 16:05 -0400, Tom Lane wrote: > Jerry LeVan writes: > > Yesterday I upgraded from fedora 14 to fedora 15... > > The install process sorta trashed my 8.4 db...here is > > what I have: > > postgresql-server-9.0.4-1.fc15.i686 > > postg

[GENERAL] Installing Fedora 15 hosed my db...

2011-06-16 Thread Jerry LeVan
> > > On Jun 16, 2011, at 5:16 PM, Dagan McGregor wrote: > >> On Thu, 16 Jun 2011 15:01:30 -0400, Jerry LeVan wrote: >>> Yesterday I upgraded from fedora 14 to fedora 15... >>> >>> The install process sorta trashed my 8.4 db...here is >>>

[GENERAL] How can I merge two tables?

2011-09-01 Thread Jerry LeVan
Hi, I have tables on my various computers that looks like: Table "public.registrations" Column | Type | Modifiers | Storage | Description --+--+---+--+- software | text | | extended | id | text | | extended | va

[GENERAL] How can I merge two tables?

2011-09-01 Thread Jerry LeVan
Hi, I have tables on my various computers that looks like: Table "public.registrations" Column | Type | Modifiers | Storage | Description --+--+---+--+- software | text | | extended | id | text | | extended |

[GENERAL] Strange Connection Problem….

2012-12-03 Thread Jerry LeVan
Hi, I recently modified one of my Fedora boxes by changing it's name and ip. I also disabled the internal wifi ( connection speed was dropping to 1 mb/sec ) and configured a USB wifi stick ( wow 270~300 mb/sec ). As I checked out the refurbed box networking was ok and I was able to connect to P

[GENERAL] Subscription Mess...

2010-05-11 Thread Jerry LeVan
Please excuse the intrusion... Last week, my subscription to pgsql-general quit coming to my mailbox... I logged into my account at postgresql.org and it showed that I was stilled subscribed. In desperation I changed my email address ( to my gmail account) and the subscription started arriving

Re: [GENERAL] Subscription Mess...

2010-05-11 Thread Jerry LeVan
Begin forwarded message: > From: Jerry LeVan > Date: May 11, 2010 9:52:21 AM EDT > To: "pgsql-general@postgresql.org general" > Subject: Subscription Mess... > > Please excuse the intrusion... > > Last week, my subscription to pgsql-general quit coming to m

[GENERAL] Fedora 13 and yum.pgsqlrpms.org

2010-05-29 Thread Jerry LeVan
Will the repository be updated for Fedora 13 in the near future :) I had to disable the repo because yumex croaks when it cannot find the repository. Jerry -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mai

[GENERAL] Fedora 13 killed dblink this week...

2010-07-17 Thread Jerry LeVan
I think that something bad has happened to Fedora 13 this week. This morning when I tried the following: select dblink_connect('host=mbp user=levan dbname=levan password=xx') I got the following error: Error: could not load library "/usr/lib/pgsql/dblink.so": /usr/lib/libldap_r-2.4.so.2: u

Re: [GENERAL] Fedora 13 killed dblink this week...

2010-07-17 Thread Jerry LeVan
On Sat, 2010-07-17 at 08:49 -0700, Joe Conway wrote: > On 07/17/2010 08:12 AM, Tom Lane wrote: > > I wrote: > > Oh, and Theory 3: see if restarting your postgresql server fixes it. > > If you didn't restart then the old openldap libraries are probably > > still in the server's address space. I'm n

Re: [GENERAL] Fedora 13 killed dblink this week...

2010-07-17 Thread Jerry LeVan
On Jul 17, 2010, at 1:21 PM, Tom Lane wrote: > Jerry LeVan writes: >> I wish whoever is in charge of the yum rpm depository would get >> cracking on building the Fedora 13 repo... > > Uhm ... what's wrong with the Fedora-supplied PG RPMs? > >

[GENERAL] Libpq on iPad?

2010-08-01 Thread Jerry LeVan
Has anyone looked at the feasibility of building libpq as a first step towards building An iPad app that can talk to postgresql dbs ? Thanks Jerry Trapped in Steve Jobs Reality Distortion Field -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscr

Re: [GENERAL] Libpq on iPad?

2010-08-01 Thread Jerry LeVan
On Aug 1, 2010, at 8:00 PM, ABPNI wrote: > > > On 2 Aug 2010, at 00:44, Jerry LeVan wrote: > >> Has anyone looked at the feasibility of building libpq as a first step >> towards building >> An iPad app that can talk to postgresql dbs ? >> >> Thanks

Re: [GENERAL] OS X library path issues for libpq (ver 8.3

2008-09-12 Thread Jerry LeVan
Have you tried putting your environmental variables in: .MacOSX I have some apps that need access to some PG enviromental variables and I had to put them in a plist in the directory .MacOSX e.g. [mbp:~/.MacOSX]$ ls -al ~/.MacOSX total 8 drwxr-xr-x3 jerry jerry 102 Jun 25 2007 .

[GENERAL] Fedora 16 note...

2011-11-10 Thread Jerry Levan
I upgraded to Fedora 16 yesterday… I thought I might have lost my 12 year old db when the system came up and I noticed the 9.1 had overwrote the old binaries. Then I read about pg_upgrade stuff and it worked! I found that postgresql would not start at boot time until I did: systemctl enable pos

Re: [GENERAL] Fedora 16 note...

2011-11-10 Thread Jerry Levan
On Nov 10, 2011, at 9:56 PM, Craig Ringer wrote: > On 11/10/2011 11:10 PM, Jerry Levan wrote: >> I upgraded to Fedora 16 yesterday… >> >> I thought I might have lost my 12 year old db when the system came up >> and I noticed the 9.1 had overwrote the old binaries. &

[GENERAL] dblink build problem…must be a lesson here...

2011-11-11 Thread Jerry Levan
Hi, I compiled pg 9.1.1 on my Mac OX 10.7.2 this afternoon and when I attempted to build dblink I got: eagle:dblink postgres$ export CC="gcc -arch i386" eagle:dblink postgres$ make gcc -arch i386 -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wformat

[GENERAL] Need Help Installing Dblink…(Desperately…)

2011-11-12 Thread Jerry Levan
I think I have somehow botched my installation of 9.1.1 on Mac OSX 10.7.2 I have a mac running 9.1.1. I then built dblink from the contrib directory and I did not see an install option in the make file. I tried copying the dblink.so file to the postgresql library directory but i cannot figure ou

[GENERAL] Re: [GENERAL] Need Help Installing Dblink…(Desperately…)

2011-11-12 Thread Jerry Levan
On Nov 12, 2011, at 3:34 PM, Scott Mead wrote: > > On Sat, Nov 12, 2011 at 1:02 PM, Jerry Levan wrote: > I think I have somehow botched my installation of 9.1.1 on Mac OSX 10.7.2 > > I have a mac running 9.1.1. > > I then built dblink from the contrib directory and I did

[GENERAL] Re: [GENERAL] Re: [GENERAL] Need Help Installing Dblink…(Desperately…)

2011-11-12 Thread Jerry Levan
On Nov 12, 2011, at 5:49 PM, Tom Lane wrote: > Jerry Levan writes: >> On Nov 12, 2011, at 3:34 PM, Scott Mead wrote: >>> The Makefile should be including the global did you try a 'make >>> install' ? > >> I went back and did the make

Re: [GENERAL] Client SQL Tool

2011-11-14 Thread Jerry Levan
On Nov 14, 2011, at 5:33 PM, pgsql-general-ow...@postgresql.org wrote: > Date: Mon, 14 Nov 2011 16:01:16 +0100 > From: > To: > Subject: Client SQL Tool > Message-ID: <2D9339CD594D4A68B51E9D0B3AF134F4@neuromancer> > > Hi all, > > Iâ•˙ve started a new codeplex project that could be interesting

[GENERAL] Pokey Fedora Updates for Postgresql?

2012-02-17 Thread Jerry Levan
I guess I am feeling a bit cranky today :(… Seems like Postgresql 9.1.2 has been out for a while but it has not appeared in the updates for Fedora 16. Today I cruised koji.fedoraproject.org and noticed that a set of rpms appear to been built by , ummm, 'tgl' back in early January. Does anyone kn

Re: [GENERAL] Pokey Fedora Updates for Postgresql?

2012-02-17 Thread Jerry Levan
On Feb 17, 2012, at 4:21 PM, Tom Lane wrote: > Jerry Levan writes: >> Seems like Postgresql 9.1.2 has been out for a while but it has >> not appeared in the updates for Fedora 16. > > I beg your pardon? Sorry, they do not appear in *my* 'yum update' or yumex

Re: [GENERAL] Pokey Fedora Updates for Postgresql?

2012-02-18 Thread Jerry Levan
On Feb 17, 2012, at 4:58 PM, Tom Lane wrote: > Jerry Levan writes: >> On Feb 17, 2012, at 4:21 PM, Tom Lane wrote: >>> I beg your pardon? > >> Sorry, they do not appear in *my* 'yum update' or yumex or the software >> update program. > > H

[GENERAL] Messed up dblink...

2009-03-21 Thread Jerry LeVan
Something seems to have messed up my dblink interface... The only thing I can think that has changed the last week was the installation of 8.3.7. It has been a long time since I have had to think about the installation of the dblink package... The basic situation is as follows... I have my mai

Re: [GENERAL] Messed up dblink...

2009-03-21 Thread Jerry LeVan
On Mar 21, 2009, at 12:37 PM, Tom Lane wrote: Jerry LeVan writes: Something seems to have messed up my dblink interface... The only thing I can think that has changed the last week was the installation of 8.3.7. What version were you using beforehand? Are you *sure* nothing else in

[GENERAL] Shared Memory and Mac OS X

2005-02-21 Thread Jerry LeVan
There have been some recent discussions on Shared Memory problems in Darwin on the darwin-kernel list at lists.apple.com. The subject is : shm_open and mmap: Invalid argument? Tain't clear to me if this is relevant to the MacOS X and Postgresql shared memory problem that I see mentioned here from t

[GENERAL] Postgresql 8.0.2 and Tiger?

2005-04-13 Thread Jerry LeVan
Mac OSX 10.4 aka Tiger is going to be released in a couple of weeks, does anyone know if Tiger will still be Postgresql friendly? Jerry ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/

Re: [GENERAL] 8.0.3 build error on Mac OS X 10.4

2005-05-19 Thread Jerry LeVan
For what it is worth... I have 10.4.1 (Tiger) (archived and ) installed on my old 933MHZ QuickSiver. I also have Xcode 2.0 installed. When I compiled 8.0.3 it seemed to generated many more warnings with 4.0 gcc than the older 3.3 gcc. At least that is my recollection... I have installed the rascal

[GENERAL] PgAdmin 1.2.2 on MacOS X with PG 8.0.3

2005-06-18 Thread Jerry LeVan
Hi, I just tried PgAdmin 1.2.2 on my Mac OS 10.4.1 and PG 8.0.3. It appears that typing into into the bottom row of the info grid brings down the application. This is the first time I have tried this application Am I unique with this problem? Jerry ---(end of broadcas

[GENERAL] Korry Douglas's PostgreSQL 2ed out yet?

2005-07-28 Thread Jerry LeVan
Has anyone had the chance to review this book yet? Jerry ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to

[GENERAL] Pushing result set to table on different machine?

2005-09-13 Thread Jerry LeVan
Hi, I recently added a linux/windows laptop to our home network. I have started Postgresql (8.0.3) on the laptop and have "replicated" my main database on the laptop. (pg_dump, ftp and pg-"undump"). I would like to keep them reasonably in sync. Slony is overkill and I think the "mirror" contrib

[GENERAL] Ann: PgBrowser-1.1

2005-10-22 Thread Jerry LeVan
PgBrowse ver 1.1 is a generic Postgresql database browser that works on Windows, Macintosh and Linux platforms that is written in Tcl/Tk. A couple of features that help differentiate this (free) product. 1) No postresql software is actually needed on the client. ( but both functionality and spee

Re: [GENERAL] psql error on quitting...

2005-11-08 Thread Jerry LeVan
Some more info, the history is actually written! ( ' ' seems to be translated to \40 ) Still get the error message... Jerry Subject: psql error on quitting... Hi, I just upgraded from 8.0.4 to 8.1.0 this afternoon and the only thing "bad" I have noticed is that whenever I quit psql I get a

[GENERAL] psql error on quitting...

2005-11-08 Thread Jerry LeVan
Hi, I just upgraded from 8.0.4 to 8.1.0 this afternoon and the only thing "bad" I have noticed is that whenever I quit psql I get a message: could not save history to file "/Users/jerry/.psql_history": Invalid argument This is on MacOS X 10.4.3 Thanks for any info... Jerry ---

Re: [GENERAL] psql error on quitting...

2005-11-09 Thread Jerry LeVan
Tom was right, on the Mac libreadline is linked to libedit. My "solution" was to comment out the line reporting the error in the program "input.c" Jerry On Nov 9, 2005, at 7:27 AM, Andreas Seltenreich wrote: Tom Lane writes: Jerry LeVan <[EMAIL PROTECTED]> wr

[GENERAL] Cursors or Offset, Limit?

2005-11-15 Thread Jerry LeVan
Hi, I am mucking around trying to build a gui'sh "table editor" for Postgresql. I am currently using a "held" cursor to move around the table, Since the "cursor" does not show table modification I am thinking about using the "limit" and "offset" attributes to select the rows to display. What

[GENERAL] Collating Question...

2007-01-15 Thread Jerry LeVan
Hi, I am running 8.2.1 on my Mac OS X and my X86 Fedora Laptop... I just noticed that on my mac: levan=# select 'A' < 'a' ; ?column? -- t (1 row) and on the linux box: levan=# select 'A' < 'a' ; ?column? -- f (1 row) The locale function on the mac has everything set to "C" a

[GENERAL] Synchronize tables question....

2007-02-16 Thread Jerry LeVan
Hi, I have a table with four text fields on two different machines that contain information about mail list passwords/software keys and similar information. Neither table has any keys or constraints. I do have dbi installed on each machine... Is there an elegant way I can merge/update the two t

Re: [GENERAL] Synchronize tables question....

2007-02-19 Thread Jerry LeVan
On Feb 19, 2007, at 9:05 AM, Richard Huxton wrote: Don't forget to CC: the list Jerry LeVan wrote: Is there an elegant way I can merge/update the two tables so that they will contain the same information ( with no duplicates or omissions)? It sounds like you'll want so

[GENERAL] [ANN] BiggerSQL-1.3.8

2004-10-18 Thread Jerry LeVan
BiggerSQL is an advanced Cocoa based Postgresql Browser/Editor for Mac OSX users. BiggerSQL lives at http://homepage.mac.com/levanj/Cocoa BiggerSQL is capable of displaying images, playing mp3s, displaying movies and flash content. ie BiggerSQL is multimedia aware. From this versions release notes:

[GENERAL] Psycopg difficulty...

2004-10-27 Thread Jerry LeVan
Psycopg and probably PySQL seem to have decided to return a "float" type when libpq returns a string tagged with the "numeric" property. This can cause "pretty" printing problems when generating reports. ( I like all of my decimal points to line up.) For example in my python based browser if I try

[GENERAL] Upgrading from beta3 to beta4

2004-10-28 Thread Jerry LeVan
I did not notice in the Install instructions that a dump restore needed to be done... This is what I got when I upgrade the v8b3 to the v8b4 FATAL: database files are incompatible with server DETAIL: The database cluster was initialized with CATALOG_VERSION_NO 200408031, but the server was comp

[GENERAL] Gborg down?

2004-11-05 Thread Jerry LeVan
I don't seem to be able to connect to gborg.postgresql.org this evening... Jerry ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] ANN: PgBrowser 1.0

2004-11-09 Thread Jerry LeVan
PgBrowser is a postgresql database browser written in a more or less platform independent fashion. I appears to work in a Mac OSX environment, Linux, and Windows. The program is written in Tcl/Tk. The program includes LJ Bayuk's Pgintcl driver that is used if the Pgtcl 1.5 or greater driver cannot

Re: [GENERAL] ANN: PgBrowse-1.0

2004-11-09 Thread Jerry LeVan
Sigh, I can't read what I write... The correct homepage for PgBrowse is: http://homepage.mac.com/levanj/TclTk I guess the correction was probably obvious :) Jerry On Nov 9, 2004, at 6:57 PM, [EMAIL PROTECTED] wrote: The homepage for PgBrowser is: http://homepage.mac.com/levanj/TckTk Feedback and en

[GENERAL] Will B4->B5 require an Initdb?

2004-11-23 Thread Jerry LeVan
I guess the subject says it all, can I install the B5 release to a B4 db without starting from scratch? Jerry ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [

[GENERAL] OSX 10.3.7 broke Postgresql 8.0.0b5?

2004-12-17 Thread Jerry LeVan
I *think* the 10.3.7 upgrade broke my postgresql implementation... I am getting this error at startup. FATAL: could not create shared memory segment: Cannot allocate memory DETAIL: Failed system call was shmget(key=5432001, size=10403840, 03600). HINT: This error usually means that PostgreSQL's

Re: [GENERAL] OSX 10.3.7 broke Postgresql 8.0.0b5?

2004-12-17 Thread Jerry LeVan
, 2004, at 3:41 PM, Jerry LeVan wrote: I *think* the 10.3.7 upgrade broke my postgresql implementation... I am getting this error at startup. FATAL: could not create shared memory segment: Cannot allocate memory DETAIL: Failed system call was shmget(key=5432001, size=10403840, 03600). HINT: This

Re: [GENERAL] OSX 10.3.7 broke Postgresql 8.0.0b5?

2004-12-17 Thread Jerry LeVan
Well, what might be some good settings for a smallish db with the default configuration? Jerry On Dec 17, 2004, at 5:40 PM, Tom Lane wrote: Jerry LeVan <[EMAIL PROTECTED]> writes: Ok, I got postgres to start... I used these settings. FWIW, I just updated to 10.3.7 from 10.3.6 and compar

[GENERAL] Contacting Tom Lane :)

2004-12-17 Thread Jerry LeVan
e some good settings for a smallish db with the default configuration? Jerry On Dec 17, 2004, at 5:40 PM, Tom Lane wrote: > Jerry LeVan <[EMAIL PROTECTED]> writes: >> Ok, I got postgres to start... >> I used these settings. > > FWIW, I just updated to 10.3.7 from 1

Re: [GENERAL] Contacting Tom Lane :)

2004-12-17 Thread Jerry LeVan
Adelphia is not a small isp, it seems strange that all of Adelphia would be blocked... Jerry On Dec 17, 2004, at 11:49 PM, Bruno Wolff III wrote: On Fri, Dec 17, 2004 at 18:29:10 -0500, Jerry LeVan <[EMAIL PROTECTED]> wrote: Hi, Tom answered a question from me and when I attemped to reply

[GENERAL] Default and PQexecParams

2005-11-27 Thread Jerry LeVan
Hi, How could one differentiate between DEFAULT and 'DEFAULT' as parameters to PQexecuteParams? Jerry ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[GENERAL] Tcl Support in the FC4 rpms at posgresql.org?

2005-11-27 Thread Jerry LeVan
Is Tcl support included in any of the FC4 rpms located at postgresql.org? { I am talking about the 8.1 release }. (Tain't clear from the names of the rpms...) If tcl support is in one of the rpms then does the install proceed by downloading all of the rpms into a single directory and then issue

Re: [GENERAL] Tcl Support in the FC4 rpms at posgresql.org?

2005-11-27 Thread Jerry LeVan
NDUZ wrote: Hi, On Sun, 27 Nov 2005, Jerry LeVan wrote: Is Tcl support included in any of the FC4 rpms located at postgresql.org? { I am talking about the 8.1 release }. No. If you need the tcl rpm, you need to rebuild our srpm: rpm --rebuild --define 'tcl 1' postgresql-8.1.0-

[GENERAL] ANN: PgBrowse-1.3 is available.

2005-11-28 Thread Jerry LeVan
PgBrowse ver 1.3 is a generic Postgresql database browser that works on Windows, Macintosh and Linux platforms that is written in Tcl/Tk. A Starpack is available for Linux/x86 and an application bundle is available for MacOSX. A couple of features that help differentiate this (free) tool. 1) No

[GENERAL] I can't build the 8.1.0 source rpm from postgresql.org

2005-11-29 Thread Jerry LeVan
I downloaded the postgresql-8.1.0 source rpm for Fedora Core 4 from the rpm repository at postgresql.org. I installed the rpm with " rpm -i postgresql-8.1.0-2PGDG.src.rpm" I then attempted to rebuild the packages with rpmbuild --rebuild --define 'tcl 1' --define 'kerberos 0' --define 'tclde

[GENERAL] Update and bytea problem...

2005-12-09 Thread Jerry LeVan
Hi, I am trying to write a general update command where there might be "bytea" fields involved. The update command is generated programatically. I am having some problems when a bytea field is involved. A generated command might look like: update pics set info='moof.jpg', byteafield='moof.jpg

Re: [GENERAL] Update and bytea problem...

2005-12-09 Thread Jerry LeVan
On Dec 9, 2005, at 9:35 PM, Michael Fuhr wrote: On Fri, Dec 09, 2005 at 08:46:17PM -0500, Jerry LeVan wrote: I am trying to write a general update command where there might be "bytea" fields involved. The update command is generated programatically. I am having some problems wh

Re: [GENERAL] Update and bytea problem...

2005-12-09 Thread Jerry LeVan
Begin forwarded message: From: Jerry LeVan <[EMAIL PROTECTED]> Date: December 9, 2005 10:45:35 PM EST To: Michael Fuhr <[EMAIL PROTECTED]> Cc: Postgres General Subject: Re: [GENERAL] Update and bytea problem... On Dec 9, 2005, at 9:35 PM, Michael Fuhr wrote: On Fri, Dec 09, 2

  1   2   >