Обсуждение: Install postgres 7.2 on Mac problems

Hi,

I am NEW.

I installed postgres 7.2 on Mac os x.1 using the pkg
from mac's site. Now the package has created a user
postgre , but whats the default password for this
user?
Also, I do i need to change hba.conf files as
mentioned in other posts or that is not required if I
am installing using the Mac pkg.


Thanks,
Greatly appreciated,
Irfan

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

 Irfan,

> I am NEW.
>
> I installed postgres 7.2 on Mac os x.1 using the pkg
> from mac's site. Now the package has created a user
> postgre , but whats the default password for this
> user?
> Also, I do i need to change hba.conf files as
> mentioned in other posts or that is not required if I
> am installing using the Mac pkg.

I'm afraid that I don't know much about the official Apple package.  What
version is it? (7.2.1, 7.2.2 or 7.2.3?)

Open up the Shell or terminal application and try:
psql -U postgres template1

It may let you in without a password, and then you can set the password by
doing:

ALTER USER postgres WITH PASSWORD 'password';

I don't know what the Mac package sets as its pg_hba.conf; you should take a
look at it if you are having trouble connecting.

I have installed Postgres on OSX, but only from source.  Sorry I'm not more
help.


--
-Josh Berkus
 Aglio Database Solutions
 San Francisco

Irfan,  you might try Marc Liyanage's  installs for OS X
(http://www.entropy.ch/software/macosx/).  I'm a non-Mac user, and was able
to successfully install his package without issue.

Patrick Hatcher
Macys.Com
Legacy Integration Developer







                    Josh Berkus

                    <josh@agliodbs.com>           To:     Babu Khan <blueswimhorse@yahoo.com>,

                    Sent by:                       pgsql-novice@postgresql.org

                    pgsql-novice-owner@post       cc:

                    gresql.org                    Subject:     Re: [NOVICE] Install postgres 7.2 on Mac problems





                    01/10/2003 05:07 PM

                    Please respond to josh









 Irfan,

> I am NEW.
>
> I installed postgres 7.2 on Mac os x.1 using the pkg
> from mac's site. Now the package has created a user
> postgre , but whats the default password for this
> user?
> Also, I do i need to change hba.conf files as
> mentioned in other posts or that is not required if I
> am installing using the Mac pkg.

I'm afraid that I don't know much about the official Apple package.  What
version is it? (7.2.1, 7.2.2 or 7.2.3?)

Open up the Shell or terminal application and try:
psql -U postgres template1

It may let you in without a password, and then you can set the password by
doing:

ALTER USER postgres WITH PASSWORD 'password';

I don't know what the Mac package sets as its pg_hba.conf; you should take
a
look at it if you are having trouble connecting.

I have installed Postgres on OSX, but only from source.  Sorry I'm not more

help.


--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html