I downloaded the new postgress, Installed it and did as you commanded at the cmd prompt;
postmaster -U postgres -i
and got this message:
(Execution of Postgres SQL by a user with administrative permissions is not permitted.
The server must be started under an unprivleged user ID to prevent possible system security comprimises.)
no request for password even.

pgadmin seems to log on with the 'postgress' user & password

BTW when I type in passwords nothing happens the cursor stays put... not even **** !! is this normal

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

On Mon, 22 Aug 2005, Paul Bramble wrote:

You didn't say what kind of system you're running, but getting a packaged
version of PostgreSQL (RPM, DEB, Windows Installer) will probably help on
the install side.

Once it's installed, you'll need to make an actual database and load the
schema file. That might be as simple as doing something like the
following as the postgres user:
createdb dbname
psql dbname -f foo.sql


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

Stephan Szabo wrote:
unless its been changed in the later releases, he'll also need to muck with the
default settings in the conf files before he'll be able to connect.



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

http://www.postgresql.org/docs/faq

Someone discovered our diabolical plot to secretly install postgres on
every computer across the globe! Quickly! Dispatch the Deadly Viper
Assassination Squad to silence him!

Vaccaro wrote:



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

Vaccaro wrote:

You probably installed a piece of software that required PostgreSQL. If
something you installed stops working, you will know what it is. Either
that or someone else installed it for you in order to work with it.

PostgreSQL is a relational database manager. It stores data for other
programs. It is not adware, spyware, or anything like that. You can
read more about it at http://www.postgresql.org

Best Wishes,
Chris Travers
Metatron Technology Consulting
chris (AT) metatrontech (DOT) com

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