Re: [GENERAL] pgsql and Mac OS X

2007-05-02 Thread Tom Lane
Michael Glaesemann <[EMAIL PROTECTED]> writes: > On May 1, 2007, at 10:11 , Tom Lane wrote: >> The Mini I bought last summer seems to have 7.3.10 installed on it. >> Don't know where to look to determine the ARD version. > I should think you only have the Remote Desktop PostgreSQL server > insta

Re: [GENERAL] pgsql and Mac OS X

2007-05-02 Thread Michael Glaesemann
On May 1, 2007, at 10:11 , Tom Lane wrote: Michael Glaesemann <[EMAIL PROTECTED]> writes: Not having ARD3 myself, anyone happen to know which version of PostgreSQL Apple's shipping with version 3? My ARD2 installation is running 7.3.3. The Mini I bought last summer seems to have 7.3.10 insta

Re: [GENERAL] pgsql and Mac OS X

2007-05-01 Thread Michael Glaesemann
On May 1, 2007, at 22:33 , Eddy D. Sanchez wrote: I had problem with mac ports, and I decide install Xcode for libraries and compile postgres from scratch, it works fine, without any problem with libraries. MacPorts requires the Xcode Developer Tools, so that may have been your problem.

Re: [GENERAL] pgsql and Mac OS X

2007-05-01 Thread Eddy D. Sanchez
I've got PostgreSQL Client and server on my MacBook, just compiling the last source code without problem, and I work with last PgAdmin. I had problem with mac ports, and I decide install Xcode for libraries and compile postgres from scratch, it works fine, without any problem with libraries

Re: [GENERAL] pgsql and Mac OS X

2007-05-01 Thread Tom Lane
Michael Glaesemann <[EMAIL PROTECTED]> writes: > Not having ARD3 myself, anyone happen to know which version of > PostgreSQL Apple's shipping with version 3? My ARD2 installation is > running 7.3.3. The Mini I bought last summer seems to have 7.3.10 installed on it. Don't know where to look to

Re: [GENERAL] pgsql and Mac OS X

2007-05-01 Thread Michael Glaesemann
On May 1, 2007, at 3:19 , Magnus Hagander wrote: Not being a Mac user myself, I do seem to recall having read somewhere that they changed this at some point. That early versions had it in 5432, but it was changed to 5433 in newer ones. What a guy :) From the Apple developer site: http://devel

Re: [GENERAL] pgsql and Mac OS X

2007-05-01 Thread Magnus Hagander
Tom Lane wrote: > Michael Glaesemann <[EMAIL PROTECTED]> writes: >> On Apr 30, 2007, at 16:39 , Tom Lane wrote: >>> Yeah, Apple uses Postgres as a part of Remote Desktop, but I don't >>> think >>> they intend it for general use --- it deliberately uses a nonstandard >>> port to avoid conflicting

Re: [GENERAL] pgsql and Mac OS X

2007-04-30 Thread John DeSoi
You can get libpq (and psql) from the pgEdit distribution. Just right click on the application and choose "Show Package Contents". You'll find these files in Contents/MacOS/bin John http://pgedit.com/public/pgedit/pgEdit_mac_1.3.dmg On Apr 30, 2007, at 3:28 PM, Tom Allison wrote: I'm tryi

Re: [GENERAL] pgsql and Mac OS X

2007-04-30 Thread Tom Lane
Michael Glaesemann <[EMAIL PROTECTED]> writes: > On Apr 30, 2007, at 16:39 , Tom Lane wrote: >> Yeah, Apple uses Postgres as a part of Remote Desktop, but I don't >> think >> they intend it for general use --- it deliberately uses a nonstandard >> port to avoid conflicting with a regular PG serve

Re: [GENERAL] pgsql and Mac OS X

2007-04-30 Thread Tom Allison
Please update the Randall Notebook to read: sudo fink install dbd-pg-unified-pm586 Perhaps this will be done in time for YAPC? On Apr 30, 2007, at 6:22 PM, Randal L. Schwartz wrote: "Tom" == Tom Lane <[EMAIL PROTECTED]> writes: Tom> What you can do if you want to build PG from source is buil

Re: [GENERAL] pgsql and Mac OS X

2007-04-30 Thread Michael Glaesemann
On Apr 30, 2007, at 16:39 , Tom Lane wrote: Yeah, Apple uses Postgres as a part of Remote Desktop, but I don't think they intend it for general use --- it deliberately uses a nonstandard port to avoid conflicting with a regular PG server. Really? I've had the Remote Desktop postgres instanc

Re: [GENERAL] pgsql and Mac OS X

2007-04-30 Thread Erik Jones
On Apr 30, 2007, at 5:03 PM, Tom Allison wrote: On Apr 30, 2007, at 5:38 PM, Michael Glaesemann wrote: On Apr 30, 2007, at 16:20 , Randal L. Schwartz wrote: "Tom" == Tom Allison <[EMAIL PROTECTED]> writes: Tom> /System/Library/CoreServices/RemoteManagement/rmdb.bundle/ bin/psql That's

Re: [GENERAL] pgsql and Mac OS X

2007-04-30 Thread Randal L. Schwartz
> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes: Tom> What you can do if you want to build PG from source is build normally Tom> but only install the client programs. The Fine Manual recommends Tom> gmake -C src/bin install Tom> gmake -C src/include install Tom> gmake -C src/in

Re: [GENERAL] pgsql and Mac OS X

2007-04-30 Thread Tom Lane
Tom Allison <[EMAIL PROTECTED]> writes: > I'm wondering how Apple Remote Desktop got onto my machine and how to > remove it. There isn't any particular need to remove it; it won't conflict with a standard PG installation. regards, tom lane ---(en

Re: [GENERAL] pgsql and Mac OS X

2007-04-30 Thread Philip Hallstrom
That's not on my mac. Must be some bolt-on you installed. So how did you get it working? (I have no idea how this file got there. Wouldn't know where to begin) Coming in late so maybe someone already posted this, but I used this: http://www.postgresqlformac.com/ I wanted the server too, b

Re: [GENERAL] pgsql and Mac OS X

2007-04-30 Thread Tom Allison
That might be the thing to do. I'm wondering how Apple Remote Desktop got onto my machine and how to remove it. On Apr 30, 2007, at 5:38 PM, Michael Glaesemann wrote: On Apr 30, 2007, at 16:20 , Randal L. Schwartz wrote: "Tom" == Tom Allison <[EMAIL PROTECTED]> writes: Tom> /System/Libr

Re: [GENERAL] pgsql and Mac OS X

2007-04-30 Thread Tom Allison
On Apr 30, 2007, at 5:20 PM, Randal L. Schwartz wrote: "Tom" == Tom Allison <[EMAIL PROTECTED]> writes: Tom> /System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/ psql That's not on my mac. Must be some bolt-on you installed. -- Randal L. Schwartz - Stonehenge Consulting Service

Re: [GENERAL] pgsql and Mac OS X

2007-04-30 Thread Tom Lane
Tom Allison <[EMAIL PROTECTED]> writes: > I found psql in > /System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/psql > which means that I can, as a user, access the database from a Mac. > But I'm still unable to build the perl modules for DBD:Pg support. > And this one seems a bit screwed

Re: [GENERAL] pgsql and Mac OS X

2007-04-30 Thread Michael Glaesemann
On Apr 30, 2007, at 16:20 , Randal L. Schwartz wrote: "Tom" == Tom Allison <[EMAIL PROTECTED]> writes: Tom> /System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/ psql That's not on my mac. Must be some bolt-on you installed. Apple Remote Desktop uses PostgreSQL as it's data sto

Re: [GENERAL] pgsql and Mac OS X

2007-04-30 Thread Randal L. Schwartz
> "Tom" == Tom Allison <[EMAIL PROTECTED]> writes: Tom> /System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/psql That's not on my mac. Must be some bolt-on you installed. -- Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095 <[EMAIL PROTECTED]> http://www

Re: [GENERAL] pgsql and Mac OS X

2007-04-30 Thread Tom Allison
I found psql in /System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/psql which means that I can, as a user, access the database from a Mac. But I'm still unable to build the perl modules for DBD:Pg support. And this one seems a bit screwed up from default. Port is 5433, not 5432. pg_conf

Re: [GENERAL] pgsql and Mac OS X

2007-04-30 Thread Erik Jones
On Apr 30, 2007, at 2:28 PM, Tom Allison wrote: I'm trying to find the binaries for pgsql (the client) for Mac OSX. Is there any way to get these without installing all of postgres on a computer? I'm not going to use postgres on my MacBook, just connect to it. If you have macports installe

[GENERAL] pgsql and Mac OS X

2007-04-30 Thread Tom Allison
I'm trying to find the binaries for pgsql (the client) for Mac OSX. Is there any way to get these without installing all of postgres on a computer? I'm not going to use postgres on my MacBook, just connect to it. ---(end of broadcast)--- TIP 3: