Thread: Starting Postgresql
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
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 numberof things you should remember before starting the postmaster. These are discussed in the installation and configurationsections of this manual. However, if Postgres has been installed by following the installation instructionsexactly 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 >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: "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. >> >
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
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
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 >
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