Thread: Postmaster will not start???

Postmaster will not start???

From
Eric Theis
Date:
I am running PostgreSQL 7.1.2/3 on Mandrake 8.1.  My problem (well my
immediate problem) is that the Postmaster will not start.  I installed MDK a
couple months ago.  In that time, Postgres has started fine until a couple
days ago. I do not get any messages (either on screen or in syslog), but the
Starting Postmaster init script fails.  I have tried uninstalling then
reinstalling the RPMs, but that only fixed the problem while I was logged in
immediately after the reinstall.  After rebooting it failed again.  I have
tried to upgrade the Postgres install from 7.1.2 to 7.1.3, but again no luck.
This  is a development box that is not left on, but turned on/off pretty
frequently.  Any thoughts or suggestions on where to look would be greatly
appreciated.

E

Genetic algorithms

From
"Miguel Gonzalez"
Date:
dear all,

 I am looking for some information of how to use the query optimization
facility using genetic algorithms in PostgreSQL.

 I tried to find some information on the internet, but I couldnt find any
detailed information of how to use genetic algorithms
in PostgreSQL.

 Has anyone know any web site or any documentation? It is just for an
assignment of a course in Genetic Algorithms. We would
like to know how to use the postgresql facilities for that and make a small
example of optimization.

 Many thanks in advance

 Miguel


Re: Genetic algorithms

From
Bruce Momjian
Date:
> dear all,
>
>  I am looking for some information of how to use the query optimization
> facility using genetic algorithms in PostgreSQL.
>
>  I tried to find some information on the internet, but I couldnt find any
> detailed information of how to use genetic algorithms
> in PostgreSQL.
>
>  Has anyone know any web site or any documentation? It is just for an
> assignment of a course in Genetic Algorithms. We would
> like to know how to use the postgresql facilities for that and make a small
> example of optimization.

Sure, it is in the PostgreSQL documentation.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Re: Postmaster will not start???

From
David Stanaway
Date:
On Monday, November 19, 2001, at 03:30  AM, Eric Theis wrote:

> I am running PostgreSQL 7.1.2/3 on Mandrake 8.1.  My problem (well my
> immediate problem) is that the Postmaster will not start.  I installed
> MDK a
> couple months ago.  In that time, Postgres has started fine until a
> couple
> days ago. I do not get any messages (either on screen or in syslog),
> but the
> Starting Postmaster init script fails.  I have tried uninstalling then
> reinstalling the RPMs, but that only fixed the problem while I was
> logged in
> immediately after the reinstall.  After rebooting it failed again.  I
> have
> tried to upgrade the Postgres install from 7.1.2 to 7.1.3, but again no
> luck.
> This  is a development box that is not left on, but turned on/off pretty
> frequently.  Any thoughts or suggestions on where to look would be
> greatly
> appreciated.


How much space do you have left on /var ?

I had a similar problem, but looking at the logs for postgres (In debian,
/var/log/postgres.log ) I saw that it was failing to start as it needed
20Mb ~ to complete a transaction.

If you don't have much space left on /var/ you may like to allocate more
space or clear some old files.

==============================
David Stanaway
Personal: david@stanaway.net
Work: david@netventures.com.au