Re: [GENERAL] metadata development

2009-03-28 Thread Simon Riggs
On Fri, 2009-03-27 at 10:44 -0500, Dara Olson wrote: > I am new to postgres/postgis and am trying to figure out the best way > to approach documenting metadata within postgres. Has there been > anything developed to add FGDC or Dublin Core standard metadata > records into postgres for each table

[GENERAL] New shapshot RPMs (Mar 27, 2009) are ready for testing

2009-03-28 Thread Devrim GÜNDÜZ
As we are moving very close to 8.4 beta, please join us for testing 8.4 release. I just released new RPM sets, which is based on Mar 27 CVS snapshot. Please note that these packages are **not** production ready. They are for Fedora 9,10 and RHEL/CentOS 5. I have no intention to push 8.4 developme

Re: [GENERAL] intermittant performance problem

2009-03-28 Thread Alban Hertroys
On Mar 27, 2009, at 8:38 PM, Mike Charnoky wrote: Hi Alban, I experimented with your sample() solution and was rather baffled by the results, as it was actually 2x-3x slower than doing an ORDER BY RANDOM() LIMIT n. I even precalculated the size of the result set, so that only one sequen

[GENERAL] problem with locale :

2009-03-28 Thread Eugenio Modesti
Hello, i received a copy of a postgresql data directory and i need to read it (and do a regular dump). the datadir version is 8.1 so i installed that version of the server. When trying to start the server i got this: Error: The server must be started under the locale : which does not exist an

Re: [GENERAL] metadata development

2009-03-28 Thread Eric Schwarzenbach
Dara Olson wrote: > > Happy spring. > > I am new to postgres/postgis and am trying to figure out the best way > to approach documenting metadata within postgres. Has there been > anything developed to add FGDC or Dublin Core standard metadata > records into postgres for each table within the datab

Re: [GENERAL] metadata development

2009-03-28 Thread Martin Gainty
MG>(hopefully quick) comments below.. > From: subscri...@blackbrook.org > CC: pgsql-general@postgresql.org > Subject: Re: [GENERAL] metadata development > > Dara Olson wrote: > > > > Happy spring. MG>Happy Spring.. > > > > I am new to postgres/postgis and am trying to figure out the best way >

[GENERAL] Authentication Failed - new user installation

2009-03-28 Thread ray
I have installed 8.2 on a Windows 2000 laptop. I think it is installed. From the pgAdmin, it shows "Servers (1)" and it is named PostgreSQL Database Server 8.2 (localhost:5432). Right clicking for says I can stop services or disconnect so I am guessing that it is running. Is that correct? Und

Re: [GENERAL] Authentication Failed - new user installation

2009-03-28 Thread Scott Mead
On Sat, Mar 28, 2009 at 3:51 AM, ray wrote: > I have installed 8.2 on a Windows 2000 laptop. > > I think it is installed. From the pgAdmin, it shows "Servers (1)" and > it is named PostgreSQL Database Server 8.2 (localhost:5432). Right > clicking for says I can stop services or disconnect so I

Re: [GENERAL] problem with locale :

2009-03-28 Thread Tom Lane
Eugenio Modesti writes: > i received a copy of a postgresql data directory and i need to read it > (and do a regular dump). > the datadir version is 8.1 so i installed that version of the server. > When trying to start the server i got this: > Error: The server must be started under the locale :

Re: [GENERAL] Authentication Failed - new user installation

2009-03-28 Thread Dave Page
On Sat, Mar 28, 2009 at 4:21 PM, Scott Mead wrote: > > > On Sat, Mar 28, 2009 at 3:51 AM, ray wrote: >> >> I have installed 8.2 on a Windows 2000 laptop. >> >> I think it is installed.  From the pgAdmin, it shows "Servers (1)" and >> it is named PostgreSQL Database Server 8.2 (localhost:5432).  R

Re: [GENERAL] How to compile a 32 bit version of postgres on a x64 machine.

2009-03-28 Thread Douglas McNaught
On Thu, Mar 26, 2009 at 6:43 AM, Tim Uckun wrote: > It looks like most avenues for high availability with postgres are not > available if one of the machines is a 64 bit machine and the other a 32. > > Somebody on this list suggested I install a 32 bit version of postgres on my > x64 machine.  Wha

Re: [GENERAL] problem with locale :

2009-03-28 Thread Stefan Kaltenbrunner
Eugenio Modesti wrote: Hello, i received a copy of a postgresql data directory and i need to read it (and do a regular dump). the datadir version is 8.1 so i installed that version of the server. When trying to start the server i got this: Error: The server must be started under the locale : wh

[GENERAL] running two servers on one machine

2009-03-28 Thread Eric Smith
All, I'm trying to run two database clusters on a single machine, and am failing. I use initdb to create the two clusters... each has their own directory structure. I can start one server or the other with pg_ctl, but once the first starts, the second just hangs on "waiting for server t

Re: [GENERAL] running two servers on one machine

2009-03-28 Thread Adrian Klaver
On Saturday 28 March 2009 3:27:15 pm Eric Smith wrote: > All, > > I'm trying to run two database clusters on a single machine, and am > failing. I use initdb to create the two clusters... each has their > own directory structure. I can start one server or the other with > pg_ctl, but once the fir

Re: [GENERAL] running two servers on one machine

2009-03-28 Thread Thomas Kellerer
Adrian Klaver wrote on 28.03.2009 23:37: On Saturday 28 March 2009 3:27:15 pm Eric Smith wrote: All, I'm trying to run two database clusters on a single machine, and am failing. I use initdb to create the two clusters... each has their own directory structure. I can start one server or the ot

Re: [GENERAL] running two servers on one machine

2009-03-28 Thread Devrim GÜNDÜZ
On Sat, 2009-03-28 at 23:51 +0100, Thomas Kellerer wrote: > You also have to make sure you assign different listener ports for > both servers in postgresql.conf ... or use different unix_socket_directory for each. Make sure that they are not under /tmp, since /tmp will be cleaned up every 15 days

[GENERAL] running two clusters on one machine

2009-03-28 Thread Eric Smith
All, I'm trying to run two database clusters on a single machine, and am failing. I use initdb to create the two clusters... each has their own directory structure. I can start one server or the other with pg_ctl, but once the first starts, the second just hangs on "waiting for server t