Hi,
I am running a gentoo system and can't seem to get started. I have
postgres beta2 sort of set up and running (I did a initdb and have the
server running) but can't get either pgadmin or phppgadmin to start. I
get

rux data $ pgadmin3
Xlib: connection to ":0.0" refused by server
Xlib: No protocol specified


(pgadmin3:667): Gtk-WARNING **: cannot open display:

from pgadmin, and can't seem to find how to connect to phppgadmin...
Cheers
Antoine

--
G System, The Evolving GUniverse - http://www.g-system.at

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

On Wed, 15 Sep 2004, Antoine wrote:

Well... This error has nothing related with PostgreSQL || pgadmin3. I've
seen this error before... HAve you su'ed to root and then back to
your user?

Try running pgadmin3 with your regular user...

Both pgAdmin3 and phpPgAdmin have seperate mailing lists. You can find the
detailed info from http://www.pgadmin.org/pgadmin3/support.php and
http://phppgadmin.sourceforge.net/?page=support , respectively.

Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org devrim.gunduz~linux.org.tr
http://www.tdmsoft.com
http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFBSLfAtl86P3SPfQ4RAiCcAKDaJFcA+na79zmMoc2Dq9 J7cCpEBQCgymvf
aOHhkPBGmIbr8yYe2ZGr5DM=
=Bo5t
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

This site is packed with information about running PostgreSQL on the Mac: http://www.entropy.ch/software/macosx/postgresql/

On this page you will find a package installer for PostgreSQL (it looks like you already have it installed, but maybe not correctly) and a startup item that can be used to start the server when the machine boots up.

As far as making a double clickable app to start and stop the database, my suggestion would be to write a simple shell script that will do it (could be as easy as writing how you currently start it to a file called pgstop.sh) and then using Platypus (http://sveinbjorn.vefsyn.is/platypus) to make it double clickable.

As far as the errors you are having, it's really hard to tell unless we know how it was installed. It could be how you are starting the application, how it was installed, a user setting problem, etc. If you could send the log, it might be more helpful. If you use the package installer from above and follow all of the directions, you should be ok.

--------

Joseph Erickson



-----Original Message-----
From: pgsql-novice-owner (AT) postgresql (DOT) org
[mailtogsql-novice-owner (AT) postgresql (DOT) org]On Behalf Of Adam I. Harris,
M.D.
Sent: Friday, October 15, 2004 7:07 AM
To: pgsql-novice (AT) postgresql (DOT) org
Subject: [NOVICE] Getting Started


While I consider myself computer literate, I don't speak "server". I
have an XServe running Mac OS 10.3. The dual G4 machine has 2 Gig RAM
and 750 GIG hard drive. I'm using a PACS program that depends on
Postgresql to run my image database. For the life of me, I cannot get
postgresql to install and run properly. I get errors in the log that
access to certain files is denied on the basis of permissions, while I
cannot find the files in question to grant access (yes, I do know how
to look for invisible files).

I really could use some assistance getting the system started. I also
will need a clickable icons and two programs to start and stop the db
with auto start on reboot.

I've been trying to install 7.4.3. Is version 8 ready for prime time?

Any and all help is greatly appreciated.

Adam I. Harris, M.D.

San Antonio Orthopaedic Specialists
Specializing in Joint Replacement of the Hip, Knee, and Shoulder
First in South Texas to offer the Zimmer Minimally Invasive Total Hip
replacement and Minimally Invasive Total Knee replacement.


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

Did you install the precompiled version linked from here:
http://www.apple.com/downloads/macos...ostgresql.html

I've seen it was made for 10.2, while you're using 10.3. That might
be an issue.

Or did you compile the PostgreSQL sourcecode?
Then, have you checked out this link?
http://developer.apple.com/internet/.../postgres.html

Tell us more about what you did so far...

I don't think using 8.0 will resolve your problem, since it's
more of a packaging-for-your-OS-problem than a PostgreSQL problem...

Bye, Chris.




---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

In article <1098088684.4383.22.camel@dell>, Chris Mair <list (AT) 1006 (DOT) org>
wrote:


http://www.entropy.ch/software/macosx/postgresql/

Marc also has a package to launch on startup. If you want a tool to
make icons you can click, look up Platypus

http://www.versiontracker.com/dyn/moreinfo/macosx/19870

Good Luck

Nikki

Adam I. Harris, M.D. wrote:

Ooops ... exotic

That's decent.
Ummm ... I doubt that the default config of PostgreSQL will use that
much memory even if it should.
As soon as your PG works you should find out how to tweak the memory
settings. Probaply you'll need to compile it yourself.

Is it the PostgreSQL log or OS X's ?
What are the inaccessible files names ?

Generally one creates a special user for running the PostgreSQL server
process who is called "postgres" ... or whatever you like.
It must be a nonadministrative user.
This user "postgres" should own the data directory and probaply only he
should have access to it.
So if you created "/var/postgres/data" as user "adam" then run
PostgreSQL as user "postgres" the server might be not allowed to go into
the data directory at all therefore it can't acces stuff it expects to
find there. Or maybe it can read there but has no write-permission.

Did you run "initdb" with the user "postgres" to prepare the content of
the data dir. before you tried to start the server the first time ?
Under Windows you actually need to logon as this user. It won't do to
just to use "run as" while beeing loged in as someone else.

Mind that the server won't start, if it figures it was allready running.
Look for stale process-id files e.g. "/tmp/postmaster.pid". Those access
right issues are pretty annoying. I had my fair share of them.

If you switched the starting user ("adam" --> "postgres") an write
permission issue might arise with PostgreSQL's log file.
Delete it so PostgreSQL can create a new one.

Those 2 programs are actually 1 and it comes with postgres.
Look in the readme. It should be pg_ctl or as in Linux and Windows
there might be ways to install PostgreSQL as a OS service. Services get
automatically started/stopped by the OS.

If you ran the initdb command succesfully it displayed 2 ways to
start the server manually. You can use both as command parameters of an
icon. Though those commands need to be run by the server process owner.
That's "postgres". OS X should have some "su -c 'blabla'" way to do this.
I use :
/usr/local/pgsql/bin/postmaster -i -D /usr/local/pgsql/data >logfile 2>&1 &

To stop postgres you can simply kill it with the process id in it's
pid-file:
kill -INT `sed -n 1p /usr/local/pgsql/data/postmaster.pid`
or use some magic with pg_ctl.

What about the current stable 7.4.5 ?


hope it helped
Andreas

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings