Re: [sot] Postgres?

2009-05-15 Thread Steven Erat - Webapper Services

On Thu, May 14, 2009 at 4:01 PM, William Seiter will...@seiter.com wrote:


 Hey all,

 I am venturing into using postgres for the first time.  I have read that
 you
 can setup postgres to accept network connections, but I can't find a sample
 on the internet on how to do it.  Currently only accepting localhost. Any
 ideas?

 Thanks,
 William




For Postgres on Linux, I wrote this shell script that facilitates starting
and stopping the database from the commandline, which may be helpful:

http://www.talkingtree.com/blog/index.cfm/2006/8/25/Getting-Started-With-PostgreSQL

-- 
Steven Erat
Webapper Services, LLC.
http://www.webapper.com/


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322554
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: [sot] Postgres?

2009-05-15 Thread Wil Genovese

Steven,

These days starting and stopping PostgreSQL 8.3 on Redhat type linux  
is as simple as

$ service postgresql {start|stop|restart|initdb|.}




Wil Genovese

One man with courage makes a majority.
-Andrew Jackson

A fine is a tax for doing wrong. A tax is a fine for doing well.

On May 15, 2009, at 9:53 AM, Steven Erat - Webapper Services wrote:


 On Thu, May 14, 2009 at 4:01 PM, William Seiter will...@seiter.com  
 wrote:


 Hey all,

 I am venturing into using postgres for the first time.  I have read  
 that
 you
 can setup postgres to accept network connections, but I can't find  
 a sample
 on the internet on how to do it.  Currently only accepting  
 localhost. Any
 ideas?

 Thanks,
 William




 For Postgres on Linux, I wrote this shell script that facilitates  
 starting
 and stopping the database from the commandline, which may be helpful:

 http://www.talkingtree.com/blog/index.cfm/2006/8/25/Getting-Started-With-PostgreSQL

 -- 
 Steven Erat
 Webapper Services, LLC.
 http://www.webapper.com/


 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322556
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: [sot] Postgres?

2009-05-15 Thread Steven Erat - Webapper Services

On Fri, May 15, 2009 at 11:00 AM, Wil Genovese jugg...@visi.com wrote:


 Steven,

 These days starting and stopping PostgreSQL 8.3 on Redhat type linux
 is as simple as

 $ service postgresql {start|stop|restart|initdb|.}




 Wil Genovese

 One man with courage makes a majority.
 -Andrew Jackson




Right, when Postgres is installed as a package during the OS installation or
later installed as an RPM then its automatically available for use with the
service command.  My blog entry was more about building postgres from
source, because at the time I couldn't find a current version of Postgres as
an RPM.  Installing from source lacks some of the conveniences you get when
installed from RPM.


-- 
Steven Erat
Webapper Services, LLC.
http://www.webapper.com/


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322557
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


[sot] Postgres?

2009-05-14 Thread William Seiter

Hey all,

I am venturing into using postgres for the first time.  I have read that you
can setup postgres to accept network connections, but I can't find a sample
on the internet on how to do it.  Currently only accepting localhost. Any
ideas?

Thanks,
William


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322527
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: [sot] Postgres?

2009-05-14 Thread Wil Genovese

read my blog post on setting up and upgrading PostgreSQL.

http://www.trunkful.com


Wil Genovese

One man with courage makes a majority.
-Andrew Jackson

A fine is a tax for doing wrong. A tax is a fine for doing well.

On May 14, 2009, at 3:01 PM, William Seiter wrote:


 Hey all,

 I am venturing into using postgres for the first time.  I have read  
 that you
 can setup postgres to accept network connections, but I can't find a  
 sample
 on the internet on how to do it.  Currently only accepting  
 localhost. Any
 ideas?

 Thanks,
 William


 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322528
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: [sot] Postgres?

2009-05-14 Thread Jochem van Dieten

On Thu, May 14, 2009 at 10:01 PM, William Seiter wrote:
 I am venturing into using postgres for the first time.  I have read that you
 can setup postgres to accept network connections, but I can't find a sample
 on the internet on how to do it.  Currently only accepting localhost. Any
 ideas?

http://wiki.postgresql.org/wiki/FAQ#How_do_I_control_connections_from_other_hosts.3F
http://www.postgresql.org/docs/8.3/static/runtime-config-connection.html

Jochem

-- 
Jochem van Dieten
http://jochem.vandieten.net/

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322531
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4