Обсуждение: Postgres on Apple hardware?
Anyone out there running Postgres on either Linux or Mac OS X on Apple hardware? Any problems with compiling/running Postgres in either of those environments? Thanks, -M@
if you check out http://techdocs.postgresql.org you will find that there is already a binary port or two for osx. rjsjr > -----Original Message----- > From: pgsql-general-owner@postgresql.org > [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Matthew Hixson > Sent: Monday, March 11, 2002 5:03 PM > To: pgsql-general@postgresql.org > Subject: [GENERAL] Postgres on Apple hardware? > > > Anyone out there running Postgres on either Linux or Mac OS X on Apple > hardware? Any problems with compiling/running Postgres in either of those > environments? > Thanks, > -M@ > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html >
On Tue, 2002-03-12 at 00:03, Matthew Hixson wrote: > Anyone out there running Postgres on either Linux or Mac OS X on Apple > hardware? Any problems with compiling/running Postgres in either of those > environments? All the GUI tools are either shareware or commercial. I have tried getting pgaccess to work but there is some lind of issue with the tcl or tk libs. Wish runs just fine but as soon as I try to open the pgaccess script it either quits or gives an access denied error. I'll start fishing around on tcl/tk lists for mac capable people when I get the time. In fact I am much more interested in getting a free GUI for postgres running on Mac OS X than running the database there. The binaries for Linux intel are easier to come by and the first to be updated, and a bi-pentium outperforms a Bi-G4 for database serving (see recent benchmarks) Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html Macromedia UltraDev with PostgreSQL http://www.animaproductions.com/ultra.html
On Tuesday, March 12, 2002, at 04:33 , Matthew Hixson wrote: > Anyone out there running Postgres on either Linux or Mac OS X on Apple > hardware? Any problems with compiling/running Postgres in > either of those > environments? > Thanks, > -M@ > I've just dived head first into PostgreSQL v7.2 on OSX v 10.1.3 on a 233MHz G3. Got it from http://www.entropy.ch/software/MacOSx/postgresql/ It should be simple enough to compile it yourself though and there are instructions on the same page. Apple has some good info for getting started with web development on OS X : http://developer.apple.com/internet/macosx/osdb.html Cheers, Joel
On Mon, 2002-03-11 at 15:03, Matthew Hixson wrote: > Anyone out there running Postgres on either Linux or Mac OS X on Apple > hardware? Any problems with compiling/running Postgres in either of those > environments? I was running it on a PowerBook running Debian Linux but since Debian upgraded to version 7.2, I cannot start the postmaster. It exits immediately with SIGABRT. I guess this would be a "problem running postgres" but I suspect the problem actually lies with Debian's package. -jwb
>> Anyone out there running Postgres on either Linux or Mac OS X on Apple >> hardware? Any problems with compiling/running Postgres in either of >> those >> environments? I have not tired to compile it - but postgres runs fine for me (simple development) on a PowerBook G3 with 384 MB RAM and a desktop G4. Both systems running OS X 10.1.3. I got the binaries from: http://www.entropy.ch/software/macosx/postgresql/ I was up and running in a very short time :) Jeff
Does PostgreSQL 7.2 support queries on tables from different databases? If so, I'd like to know the syntax. Thanks! Best Regards, Carlo Florendo NEC Telecoms fcarlo@ntsp.nec.co.jp
On Mon, 2002-03-11 at 23:28, Jeffrey W. Baker wrote: > On Mon, 2002-03-11 at 15:03, Matthew Hixson wrote: > > Anyone out there running Postgres on either Linux or Mac OS X on Apple > > hardware? Any problems with compiling/running Postgres in either of those > > environments? > > I was running it on a PowerBook running Debian Linux but since Debian > upgraded to version 7.2, I cannot start the postmaster. It exits > immediately with SIGABRT. I guess this would be a "problem running > postgres" but I suspect the problem actually lies with Debian's package. So how about submitting a bug report? I can't fix packaging errors I don't know about. No one else has reported such a problem with the package, but I don't know how many users there are on that architecture (is that powerpc?). You should also cc the appropriate Debian mailing list for your architecture, since I only have i386 machines. -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C "Let your light so shine before men, that they may see your good works, and glorify your Father which is in heaven." Matthew 5:16
Le Jeudi 14 Mars 2002 06:18, Carlo Florendo a écrit : > Does PostgreSQL 7.2 support queries on tables from different databases? > If so, I'd like to know the syntax. I don't think so. The only possibility (?) would be to used an untrusted server-side language (such as PLperl if it can be used as untrusted) and query other backends. By now, this is merely impossible. If someone knows how to do it, I would be interested in knowing. Cheers, Jean-Michel pOURE
Just to respond to the general question... I'm successfully running Postgres 7.2 on a Power Mac 7200/90 using the Debian Linux distribution. I'm not doing any substantial work yet, (still on a learning curve) but simple queries work fine.
Jean-Michel POURE wrote: > Le Jeudi 14 Mars 2002 06:18, Carlo Florendo a écrit : > >>Does PostgreSQL 7.2 support queries on tables from different databases? >>If so, I'd like to know the syntax. >> > > I don't think so. The only possibility (?) would be to used an untrusted > server-side language (such as PLperl if it can be used as untrusted) and > query other backends. By now, this is merely impossible. If someone knows how > to do it, I would be interested in knowing. > > Cheers, > Jean-Michel pOURE > See dblink in contrib. It is crude, but might work for you depending on your needs. Joe