Re: [ADMIN] Postgres community version limitaiton - help needed

2012-02-06 Thread Thomas Kellerer
Scott Marlowe, 05.02.2012 23:13: Not sure what you mean by "community edition". There's PostgreSQL. From the postgresql.org website, which is what most folks use. I think the term "community edition" was coined by EnterpriseDB - at least it shows up on their webpages on some places. -- S

Re: [ADMIN] Add tablefunc modules to Postgresql 9.1

2012-02-06 Thread Kevin Duffy
I actually figured this one out, with a little help from the web. I kind'a figured that I needed to install or add postgresql-contrib. And I figured yum would be involved. This posting got me the rest of the way. http://joysofprogramming.com/install-postgresql-contrib-fedora-rhel/ Key point being

Re: [ADMIN] Postgres community version limitaiton - help needed

2012-02-06 Thread ajay kumar
Thanks Scott . "community edition" means There is no license fees for using PostGresql as it is Open Source database . Regards Ajay Pandey > Date: Sun, 5 Feb 2012 15:13:06 -0700 > Subject: Re: [ADMIN] Postgres community version limitaiton - help needed > From: scott.marl...@gmail.com > T

[ADMIN] 9.1 QUestion -- directory left over after drop database

2012-02-06 Thread Greg Williamson
I have been playing a bit with a 9.1 instance as we plan for some new data. I created a database in a tablespace:   CREATE DATABASE foo2test2 TEMPLATE template1 TABLESPACE data1; I set my default tablesapce and create a dummy table with a small amount of data:   SET default_tablespace = data1;