Re: [Fink-users] PostgreSQL isn't running

2008-01-20 Thread Josh Berkus
David,

 Using a rusty Amiga 4000T, a rebuilt PowerBook G4,  a homebuilt  
 Ubuntu box

Heh.  If you can get PostgreSQL running on the Amiga I'd love to write 
about it.

--Josh

-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
Fink-users mailing list
Fink-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/fink-users


Re: [Fink-users] PostgreSQL isn't running

2008-01-17 Thread Peter Stirling
Perhaps some sort of postgre-db-running package would be a good idea?

It could depend on the installation of any of the versions of postgre  
and allow packages (and users!) the ability to depend on it being  
installed and running.

It could probably error on install in the case where the user has it  
running already.


On 16 Jan 2008, at 9:05 pm, Josh Berkus wrote:

 All,

 In general, installation of database software does not imply that you
 want the database server running.  It might be installed as a
 dependency by another package that has specific requirements for how
 the database is set up, so initializing and starting some default
 instance is not really appropriate.

 For that matter, some users will already have PostgreSQL installed  
 and want
 to use the existing instance.  Or some users may be running the old  
 Apple
 Remote Desktop which unfortunately runs PostgreSQL on the default  
 port and
 causes a conflict.

 -- 
 --Josh

 Josh Berkus
 PostgreSQL @ Sun
 San Francisco

 -
 This SF.net email is sponsored by: Microsoft
 Defy all challenges. Microsoft(R) Visual Studio 2008.
 http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
 ___
 Fink-users mailing list
 Fink-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/fink-users

 --
 This email has been verified as Virus free.
 Virus Protection and more available at http://www.plus.net


-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
Fink-users mailing list
Fink-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/fink-users


Re: [Fink-users] PostgreSQL isn't running

2008-01-16 Thread Damien Kick

On Jan 15, 2008, at 6:37, Kurt Schwehr wrote:

 Here are some additional notes

 http://schwehr.org/blog/archives/2008-01.html#e2008-01-09T13_40_59.txt
 setting up a postgresql/postgis database on mac
 osx 10.5 with fink
 pgsql.sh start
 sudo daemonic enable postgresql82

Thanks for the info.  Is there some kind of technical problem to  
having the fink install set things up such that the server is started  
for the user?

-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
Fink-users mailing list
Fink-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/fink-users


Re: [Fink-users] PostgreSQL isn't running

2008-01-16 Thread Alexander Hansen
On Jan 15, 2008 11:15 PM, Damien Kick [EMAIL PROTECTED] wrote:

 On Jan 15, 2008, at 6:37, Kurt Schwehr wrote:

  Here are some additional notes
 
  http://schwehr.org/blog/archives/2008-01.html#e2008-01-09T13_40_59.txt
  setting up a postgresql/postgis database on mac
  osx 10.5 with fink
  pgsql.sh start
  sudo daemonic enable postgresql82

The last line above is supposed to set things up so that the server is
automatically started on bootup.


 Thanks for the info.  Is there some kind of technical problem to
 having the fink install set things up such that the server is started
 for the user?


-- 
Alexander K. Hansen
akh AT finkproject DOT org
Fink User Liaison and Documenter

-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
Fink-users mailing list
Fink-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/fink-users


Re: [Fink-users] PostgreSQL isn't running

2008-01-16 Thread Kurt Schwehr
Nigel,

Take a look at /sw/var/postgresql-8.2/pgsql.log 

You may find the reason for postgresql not starting in that log file.

-kurt




- Original Message 
From: Nigel Stanger [EMAIL PROTECTED]

 pgsql.sh start
 sudo daemonic enable postgresql82

I'm finding that PostgreSQL isn't starting when I reboot my machine.
Everything is in the correct place, and daemonic lists postgresql82
 when I
do a dump, yet the postmaster isn't automatically loading. I have to
 crank
it up by hand. Weirdly, the StartupItem installed by daemonic works
 fine
when called from the command line.

Needless to say, this is annoying :)






  

Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ 


-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
Fink-users mailing list
Fink-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/fink-users


Re: [Fink-users] PostgreSQL isn't running

2008-01-16 Thread Damien Kick

On Jan 16, 2008, at 4:44, Alexander Hansen wrote:

 On Jan 15, 2008 11:15 PM, Damien Kick [EMAIL PROTECTED] wrote:

 On Jan 15, 2008, at 6:37, Kurt Schwehr wrote:

 Here are some additional notes

 http://schwehr.org/blog/archives/2008-01.html#e2008-01-09T13_40_59.txt
 setting up a postgresql/postgis database on mac
 osx 10.5 with fink
 pgsql.sh start
 sudo daemonic enable postgresql82

 The last line above is supposed to set things up so that the server is
 automatically started on bootup.

I understand that but I was wondering if this was supposed to have  
been done by fink during the install.  Not that I mind doing it by  
hand after the install but I'm just wondering if perhaps I missed  
some error messages about these steps having failed during the fink  
install.

-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
Fink-users mailing list
Fink-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/fink-users


Re: [Fink-users] PostgreSQL isn't running

2008-01-16 Thread Kurt Schwehr
Hi Damien,

Here is my take on not starting postgresql:

It is usually the maintainers choice (in this case Ben) on how to handle this.  
I can't speak for Ben, but in this case I think it is correct that the 
postgresql packages do not automatically turn on the databases.  There are a 
number of packages that require various versions of postgresql be installed, 
but that doesn't mean a user that installed those other packages wants to have 
a bunch of postgresql database servers running.  It's not possible to handle 
the needs of every user, so in this case, having instructions in fink describe 
postgresql82 and at the end of the install seems to me to be a good balance.

I encourage you to contribute documentation and and please do continue to 
suggest improvements to packages.

-kurt




- Original Message 
From: Damien Kick [EMAIL PROTECTED]
To: Alexander Hansen [EMAIL PROTECTED]
Cc: fink-users@lists.sourceforge.net
Sent: Wednesday, January 16, 2008 8:22:33 AM
Subject: Re: [Fink-users] PostgreSQL isn't running



On Jan 16, 2008, at 4:44, Alexander Hansen wrote:

 On Jan 15, 2008 11:15 PM, Damien Kick [EMAIL PROTECTED] wrote:

 On Jan 15, 2008, at 6:37, Kurt Schwehr wrote:

 Here are some additional notes


 http://schwehr.org/blog/archives/2008-01.html#e2008-01-09T13_40_59.txt
 setting up a postgresql/postgis database on mac
 osx 10.5 with fink
 pgsql.sh start
 sudo daemonic enable postgresql82

 The last line above is supposed to set things up so that the server
 is
 automatically started on bootup.

I understand that but I was wondering if this was supposed to have  
been done by fink during the install.  Not that I mind doing it by  
hand after the install but I'm just wondering if perhaps I missed  
some error messages about these steps having failed during the fink  
install.

-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
Fink-users mailing list
Fink-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/fink-users





  

Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ 


-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
Fink-users mailing list
Fink-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/fink-users


Re: [Fink-users] PostgreSQL isn't running

2008-01-16 Thread Mark J. Reed
In general, installation of database software does not imply that you
want the database server running.  It might be installed as a
dependency by another package that has specific requirements for how
the database is set up, so initializing and starting some default
instance is not really appropriate.

I'm searching for a reasonable analogy, but having a database engine
set up a database instance upon installation is somewhat akin to
having the installation of Word create a letter for you.

Besides, most of the network services that come preinstalled with OS X
out of the box are not started by default, either - the web server,
remote access (RDC/SSH), etc.

-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
Fink-users mailing list
Fink-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/fink-users


Re: [Fink-users] PostgreSQL isn't running

2008-01-16 Thread Josh Berkus
All,

 In general, installation of database software does not imply that you
 want the database server running.  It might be installed as a
 dependency by another package that has specific requirements for how
 the database is set up, so initializing and starting some default
 instance is not really appropriate.

For that matter, some users will already have PostgreSQL installed and want 
to use the existing instance.  Or some users may be running the old Apple 
Remote Desktop which unfortunately runs PostgreSQL on the default port and 
causes a conflict.

-- 
--Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco

-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
Fink-users mailing list
Fink-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/fink-users


Re: [Fink-users] PostgreSQL isn't running

2008-01-15 Thread Kurt Schwehr

Here are some additional notes
 
http://schwehr.org/blog/archives/2008-01.html#e2008-01-09T13_40_59.txt
setting up a postgresql/postgis database on mac
osx 10.5 with fink
pgsql.sh start
sudo daemonic enable postgresql82
-kurt
(goatbar)


- Original Message 
From: Damien Kick [EMAIL PROTECTED]
To: fink-users@lists.sourceforge.net
Sent: Monday, January 14, 2008 10:45:15 PM
Subject: [Fink-users] PostgreSQL isn't running


I'm running

$ fink --version
Package manager version: 0.27.8
Distribution version: 0.8.1.rsync powerpc

And I've recently installed

PostgreSQL 8.2.4-1021

I was surprised to find that I could not connect to the server

$ psql
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket /tmp/.s.PGSQL.5432?

But I'm also not quite sure what I should do to get it started.  Any
 advice
on where to get started?


-
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
___
Fink-users mailing list
Fink-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/fink-users





  

Never miss a thing.  Make Yahoo your home page. 
http://www.yahoo.com/r/hs

-
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
___
Fink-users mailing list
Fink-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/fink-users


Re: [Fink-users] PostgreSQL isn't running

2008-01-15 Thread Nigel Stanger
On 16/1/2008 1:37 AM, Kurt Schwehr at [EMAIL PROTECTED] spake thus:

 pgsql.sh start
 sudo daemonic enable postgresql82

I'm finding that PostgreSQL isn't starting when I reboot my machine.
Everything is in the correct place, and daemonic lists postgresql82 when I
do a dump, yet the postmaster isn't automatically loading. I have to crank
it up by hand. Weirdly, the StartupItem installed by daemonic works fine
when called from the command line.

Needless to say, this is annoying :)

-- 
Nigel Stanger,   mailto:[EMAIL PROTECTED]
Dunedin, NEW ZEALAND.Fnord.

Usenet is like a herd of performing elephants with diarrhea --- massive,
difficult to redirect, awe-inspiring, entertaining, and a source of
mind-boggling amounts of excrement when you least expect it.
--- Gene Spafford



-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
Fink-users mailing list
Fink-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/fink-users


[Fink-users] PostgreSQL isn't running

2008-01-14 Thread Damien Kick
I'm running

$ fink --version
Package manager version: 0.27.8
Distribution version: 0.8.1.rsync powerpc

And I've recently installed

PostgreSQL 8.2.4-1021

I was surprised to find that I could not connect to the server

$ psql
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket /tmp/.s.PGSQL.5432?

But I'm also not quite sure what I should do to get it started.  Any advice
on where to get started?


-
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
___
Fink-users mailing list
Fink-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/fink-users


Re: [Fink-users] PostgreSQL isn't running

2008-01-14 Thread Josh Berkus
Damien,

 But I'm also not quite sure what I should do to get it started.  Any advice
 on where to get started?

initdb -D /var/postgres/8.2/data
pg_ctl -D /var/postgres/8.2/data start 

-- 
Josh Berkus
PostgreSQL @ Sun
San Francisco

-
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
___
Fink-users mailing list
Fink-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/fink-users