Starting Postgresql

a shell

http://en.wikipedia.org/wiki/Shell_%28computing%29

On Wed, Dec 20, 2006 at 10:59:05AM -0800, Bob Pawley wrote:

I haven't used the command lines previously having relied on PG Admin.

In the instructions -
"Starting postmaster
Nothing can happen to a database unless the postmaster process is running. As the site administrator, there are a number of things you should remember before starting the postmaster. These are discussed in the installation and configuration sections of this manual. However, if Postgres has been installed by following the installation instructions exactly as written, the following simple command is all you should need to start the postmaster:

% postmaster "- nowhere is it stated where the command is typed.Perhaps someone can tell me?Bob Pawley

--
You have no chance to survive make your time.

which in PostgreSQL is????

Bob

----- Original Message -----
From: "Ray Stell" <stellr@cns.vt.edu>
To: "Bob Pawley" <rjpawley@shaw.ca>
Cc: "Postgresql" <pgsql-general@postgresql.org>
Sent: Wednesday, December 20, 2006 11:07 AM
Subject: Re: [GENERAL] Starting Postgresql

which in PostgreSQL is????

Bob

----- Original Message -----
From: "Bob Pawley" <rjpawley@shaw.ca>
To: "Ray Stell" <stellr@cns.vt.edu>
Cc: "Postgresql" <pgsql-general@postgresql.org>
Sent: Wednesday, December 20, 2006 11:12 AM
Subject: Re: [GENERAL] Starting Postgresql

On 20 Dec 2006 at 11:12, Bob Pawley wrote:

which in PostgreSQL is????

It's not in PostgreSQL - it's the shell of your operating system. In
Windows, you get that either by clicking Start -> Run and typing
"command" or "cmd" (depending on your version of windows), or by
clicking on Start -> Programs -> Accessories -> Command prompt.

--Ray

----------------------------------------------------------------------

Raymond O'Donnell
Director of Music, Galway Cathedral, Galway, Ireland
rod@iol.ie
----------------------------------------------------------------------

Raymond O'Donnell wrote:

On 20 Dec 2006 at 11:12, Bob Pawley wrote:

which in PostgreSQL is????

It's not in PostgreSQL - it's the shell of your operating system. In
Windows, you get that either by clicking Start -> Run and typing
"command" or "cmd" (depending on your version of windows), or by
clicking on Start -> Programs -> Accessories -> Command prompt.

But in any case, you probably don't want to start it like that. On
Windows you probably want to go into the service manager (in
administrative tools iirc) and on Linux something like
/etc/init.d/postgresql start - that way you'll get the proper startup
sequence, setting any environment variables and redirecting logging etc.

By the way - what page were you quoting that intruction from? I don't
recognise it. I'm particularly puzzled because it referred to "Postgres"
rather than "PostgreSQL".

--
Richard Huxton
Archonet Ltd

Here's the url http://fusion.gat.com/~osborne/dbdoc/postgres/postmaster.htm

Bob

----- Original Message -----
From: "Richard Huxton" <dev@archonet.com>
To: "Raymond O'Donnell" <rod@iol.ie>
Cc: "Postgresql" <pgsql-general@postgresql.org>
Sent: Wednesday, December 20, 2006 11:43 AM
Subject: Re: [GENERAL] Starting Postgresql

On Wed, 2006-12-20 at 11:13 -0800, Bob Pawley wrote:

which in PostgreSQL is????

Bob, you should be looking into your control-panel and service controls
to start the postgresql service.

Sincerely,

Joshua D. Drake

Bob

----- Original Message -----
From: "Bob Pawley" <rjpawley@shaw.ca>
To: "Ray Stell" <stellr@cns.vt.edu>
Cc: "Postgresql" <pgsql-general@postgresql.org>
Sent: Wednesday, December 20, 2006 11:12 AM
Subject: Re: [GENERAL] Starting Postgresql

which in PostgreSQL is????

Bob

----- Original Message -----
From: "Ray Stell" <stellr@cns.vt.edu>
To: "Bob Pawley" <rjpawley@shaw.ca>
Cc: "Postgresql" <pgsql-general@postgresql.org>
Sent: Wednesday, December 20, 2006 11:07 AM
Subject: Re: [GENERAL] Starting Postgresql

a shell

http://en.wikipedia.org/wiki/Shell_%28computing%29

On Wed, Dec 20, 2006 at 10:59:05AM -0800, Bob Pawley wrote:

I haven't used the command lines previously having relied on PG Admin.

In the instructions -
"Starting postmaster
Nothing can happen to a database unless the postmaster process is
running. As the site administrator, there are a number of things you
should remember before starting the postmaster. These are discussed in
the installation and configuration sections of this manual. However, if
Postgres has been installed by following the installation instructions
exactly as written, the following simple command is all you should need
to start the postmaster:

% postmaster "- nowhere is it stated where the command is typed.Perhaps
someone can tell me?Bob Pawley

--
You have no chance to survive make your time.

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

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate

I think you're better off to use the official documentation.
http://www.postgresql.org/docs/

(chose the docs for the version you're running on the right side of that
page).

The docs you're currently referencing are for 7.0 - which is stone-age
postgresql.

On Wednesday 20 December 2006 11:57, Bob Pawley wrote:

Here's the url http://fusion.gat.com/~osborne/dbdoc/postgres/postmaster.htm

Bob

----- Original Message -----
From: "Richard Huxton" <dev@archonet.com>
To: "Raymond O'Donnell" <rod@iol.ie>
Cc: "Postgresql" <pgsql-general@postgresql.org>
Sent: Wednesday, December 20, 2006 11:43 AM
Subject: Re: [GENERAL] Starting Postgresql

Raymond O'Donnell wrote:

On 20 Dec 2006 at 11:12, Bob Pawley wrote:

which in PostgreSQL is????

It's not in PostgreSQL - it's the shell of your operating system. In
Windows, you get that either by clicking Start -> Run and typing
"command" or "cmd" (depending on your version of windows), or by
clicking on Start -> Programs -> Accessories -> Command prompt.

But in any case, you probably don't want to start it like that. On
Windows you probably want to go into the service manager (in
administrative tools iirc) and on Linux something like
/etc/init.d/postgresql start - that way you'll get the proper startup
sequence, setting any environment variables and redirecting logging etc.

By the way - what page were you quoting that intruction from? I don't
recognise it. I'm particularly puzzled because it referred to "Postgres"
rather than "PostgreSQL".

--
Richard Huxton
Archonet Ltd

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

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

--
UC

--
Open Source Solutions 4U, LLC 1618 Kelly St
Phone: +1 707 568 3056 Santa Rosa, CA 95401
Cell: +1 650 302 2405 United States
Fax: +1 707 568 6416

Original Message From Bob Pawley

Here's the url
http://fusion.gat.com/~osborne/dbdoc/postgres/postmaster.htm

Bob,

The above documentation is circa version 7.0.

It might be easier to use the current PostgreSQL official documentation.
See for example:

http://www.postgresql.org/docs/8.2/static/server-start.html

Regards,
George

Bob Pawley wrote:

Here's the url http://fusion.gat.com/~osborne/dbdoc/postgres/postmaster.htm

As the others say, use the official docs. And perhaps drop osborne a
note to let him know his docs are out of date.

--
Richard Huxton
Archonet Ltd