Thread: postgresql / osx lion

hello,
i'm a new mac user.
I have heard that postgresql can't be installed on new osx lion for mac. will it be fixed  soon? or do you have any
advice to make it work now ?
regards.

Seb,
It looks like Postgres is already installed in Lion.  Look for it at /usr/bin/psql
Look like version 9.0.4
This is a strange one for Apple as they are usually a couple of version behind.
Kent

On Aug 15, 2011, at 3:22 PM, Arvind Sharma wrote:

>
> Try downloading the Mac OS X  version from :
>
> http://www.enterprisedb.com/products-services-training/pgdownload#osx
>
> Its a DMG file and will get installed just like any other Mac App.
>
>
> Arvind
>
> From: Sébastien BERAL <sebeyeless@hotmail.com>
> To: Arvind Sharma <arvind321@yahoo.com>
> Sent: Monday, August 15, 2011 1:43 PM
> Subject: Re: [NOVICE] postgresql / osx lion
>
> Thank you for the answer.
> I'm talking about fresh install of PG.
> I'm a new mac user, and my macbookpro is "virgin"
> I upgraded to Lion before starting anything else.
> and now I need to install PG on it. so you advice me to get PG 9.0 ?
> Seb
>
> Le 15 août 2011 à 22:03, Arvind Sharma a écrit :
>
>> I have PG-9.0 running on Mac OS X - Lion for quite some time now.
>>
>> Works ok.
>>
>> Are you talking fresh install of PG on a Mac OS X Lion or PG already running on Snow leopard which is upgraded to
Lion?? 
>>
>> Arvind
>>
>>
>>
>> From: Sébastien BERAL <sebeyeless@hotmail.com>
>> To: pgsql-novice@postgresql.org
>> Sent: Monday, August 15, 2011 12:07 PM
>> Subject: [NOVICE] postgresql / osx lion
>>
>> hello,
>> i'm a new mac user.
>> I have heard that postgresql can't be installed on new osx lion for mac. will it be fixed  soon? or do you have any
>> advice to make it work now ?
>> regards.
>> --
>> Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-novice
>>
>>
>
>
>
>
> Spam
> Not spam
> Forget previous vote


This e-mail and any attachments are for the intended recipient(s), not for general publication, and may contain
confidentialmaterial.  If you are not the intended recipient(s), please be aware that any disclosure, copying,
distributionor use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please
contactthe sender and delete all copies. 

Ftr, I did run into some problems with my local postgres install -
mine was originally a homebrew install on Snow Leopard.  When I
upgraded to Lion over the weekend, I did get an error (FATAL: no
pg_hba.conf entry for host "::1", ... ) on trying to connect.  My
pg_hba.conf just needed a new entry to handle IPv6 connections - it's
all good now:

    # IPv6 local connections:
    host    all    all    ::1/128    md5


On Mon, Aug 15, 2011 at 2:36 PM, Kent Thomas <kent@solarbee.com> wrote:
> Seb,
> It looks like Postgres is already installed in Lion.  Look for it at /usr/bin/psql
> Look like version 9.0.4
> This is a strange one for Apple as they are usually a couple of version behind.
> Kent
>
> On Aug 15, 2011, at 3:22 PM, Arvind Sharma wrote:
>
>>
>> Try downloading the Mac OS X  version from :
>>
>> http://www.enterprisedb.com/products-services-training/pgdownload#osx
>>
>> Its a DMG file and will get installed just like any other Mac App.
>>
>>
>> Arvind
>>
>> From: Sébastien BERAL <sebeyeless@hotmail.com>
>> To: Arvind Sharma <arvind321@yahoo.com>
>> Sent: Monday, August 15, 2011 1:43 PM
>> Subject: Re: [NOVICE] postgresql / osx lion
>>
>> Thank you for the answer.
>> I'm talking about fresh install of PG.
>> I'm a new mac user, and my macbookpro is "virgin"
>> I upgraded to Lion before starting anything else.
>> and now I need to install PG on it. so you advice me to get PG 9.0 ?
>> Seb
>>
>> Le 15 août 2011 à 22:03, Arvind Sharma a écrit :
>>
>>> I have PG-9.0 running on Mac OS X - Lion for quite some time now.
>>>
>>> Works ok.
>>>
>>> Are you talking fresh install of PG on a Mac OS X Lion or PG already running on Snow leopard which is upgraded to
Lion?? 
>>>
>>> Arvind
>>>
>>>
>>>
>>> From: Sébastien BERAL <sebeyeless@hotmail.com>
>>> To: pgsql-novice@postgresql.org
>>> Sent: Monday, August 15, 2011 12:07 PM
>>> Subject: [NOVICE] postgresql / osx lion
>>>
>>> hello,
>>> i'm a new mac user.
>>> I have heard that postgresql can't be installed on new osx lion for mac. will it be fixed  soon? or do you have any
>>> advice to make it work now ?
>>> regards.
>>> --
>>> Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
>>> To make changes to your subscription:
>>> http://www.postgresql.org/mailpref/pgsql-novice
>>>
>>>
>>
>>
>>
>>
>> Spam
>> Not spam
>> Forget previous vote
>
>
> This e-mail and any attachments are for the intended recipient(s), not for general publication, and may contain
confidentialmaterial.  If you are not the intended recipient(s), please be aware that any disclosure, copying,
distributionor use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please
contactthe sender and delete all copies. 
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>

On Aug 15, 2011, at 2:36 PM, Kent Thomas wrote:

> Seb,
> It looks like Postgres is already installed in Lion.  Look for it at /usr/bin/psql
> Look like version 9.0.4
> This is a strange one for Apple as they are usually a couple of version behind.
> Kent

I thought that wast just on the server version. Does regular lion come with Postgres as well?

Brent.

(This time to the list)

Brent Dombrowski <brent.dombrowski@gmail.com> writes:
> On Aug 15, 2011, at 2:36 PM, Kent Thomas wrote:
>> It looks like Postgres is already installed in Lion.  Look for it at /usr/bin/psql

> I thought that wast just on the server version. Does regular lion come with Postgres as well?

On my plain-Lion laptop, I see psql, pg_dump, and other "client side" PG
programs in /usr/bin.  No postmaster though.  I assume you have to buy
Lion Server to get that.  But you can talk to a remote PG server with
what they give you in plain Lion.

            regards, tom lane

On Aug 15, 2011, at 7:44 PM, Tom Lane wrote:

> Brent Dombrowski <brent.dombrowski@gmail.com> writes:
>> On Aug 15, 2011, at 2:36 PM, Kent Thomas wrote:
>>> It looks like Postgres is already installed in Lion.  Look for it at /usr/bin/psql
>
>> I thought that wast just on the server version. Does regular lion come with Postgres as well?
>
> On my plain-Lion laptop, I see psql, pg_dump, and other "client side" PG
> programs in /usr/bin.  No postmaster though.  I assume you have to buy
> Lion Server to get that.  But you can talk to a remote PG server with
> what they give you in plain Lion.
>
>             regards, tom lane

Thanks Tom, that makes sense. That will be one less thing for me to install when I move to Lion.

Brent.

On Thu, Sep 22, 2011 at 6:02 PM, Arvind Sharma <arvind321@yahoo.com> wrote:
> Hi,
>
> Is there a way to extract the contents of a column which is nothing but a
> well defined XML blob of data, and to be able to traverse the XML Elements (
> XPath style) using any in-build functions ?
>
> Also, how would I store such a XML blob in a column ?  Declare the column as
> 'VARCHAR(256)' or something else ?
>
> Would this require any special module to be loaded at the Server startup ?
> I am using the PG-9.0 Installer from the official site.

Have you tried the built-in XML datatype and related functions?
  http://developer.postgresql.org/pgdocs/postgres/functions-xml.html

If so, you should clarify specifically what is not working (provide an example).

Josh