Re: [sot] Postgres?
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?
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?
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?
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?
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?
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