Re: What version of PostgreSQL does Heroku use?

[Steven! Ragnarök]

On 9/23/11 10:37 AM, Peter van Hardenberg wrote:

This doesn't work on Cedar, where psql is not available. You can always
"SELECT version();" using your SQL interface of choice.

Speaking generally, the sandbox databases are 8.3, and the production
databases are 9.0. We hope to unify this soon, but the differences are
primarily that the older 8.3 databases are lacking some features found
in 9.0.

-pvh

On Fri, Sep 23, 2011 at 9:48 AM, Aaron Brethorst mailto:aa...@brethorsting.com>> wrote:

 From your app's Heroku console you should be able to do the following:

 >> `psql --version`
=> "psql (PostgreSQL) 8.3.14\ncontains support for command-line
editing\n"

On Sep 23, 2011, at 9:36 AM, ebdb wrote:

 > Hi. I'm just setting up my account and dev machine. I'd like to
try to
 > get my PostgreSQL version on my dev machine as close as possible to
 > what's on Heroku.
 >
 > What version would that be?
 >
 > Thanks!
 >
 > E
 >
 > --
 > You received this message because you are subscribed to the
Google Groups "Heroku" group.
 > To post to this group, send email to heroku@googlegroups.com
.
 > To unsubscribe from this group, send email to
heroku+unsubscr...@googlegroups.com
.
 > For more options, visit this group at
http://groups.google.com/group/heroku?hl=en.
 >

--
You received this message because you are subscribed to the Google
Groups "Heroku" group.
To post to this group, send email to heroku@googlegroups.com
.
To unsubscribe from this group, send email to
heroku+unsubscr...@googlegroups.com
.
For more options, visit this group at
http://groups.google.com/group/heroku?hl=en.


--
You received this message because you are subscribed to the Google
Groups "Heroku" group.
To post to this group, send email to heroku@googlegroups.com.
To unsubscribe from this group, send email to
heroku+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/heroku?hl=en.


`heroku pg:psql` will get you a Postgres console on Cedar.

--
Steven! Ragnarök
T 408 256 0278
ste...@nuclearsandwich.com
http://nuclearsandwich.com

--
You received this message because you are subscribed to the Google Groups 
"Heroku" group.
To post to this group, send email to heroku@googlegroups.com.
To unsubscribe from this group, send email to 
heroku+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/heroku?hl=en.

Re: What version of PostgreSQL does Heroku use?

[Peter van Hardenberg]

This doesn't work on Cedar, where psql is not available. You can always
"SELECT version();" using your SQL interface of choice.

Speaking generally, the sandbox databases are 8.3, and the production
databases are 9.0. We hope to unify this soon, but the differences are
primarily that the older 8.3 databases are lacking some features found in
9.0.

-pvh

On Fri, Sep 23, 2011 at 9:48 AM, Aaron Brethorst wrote:

> From your app's Heroku console you should be able to do the following:
>
> >> `psql --version`
> => "psql (PostgreSQL) 8.3.14\ncontains support for command-line editing\n"
>
> On Sep 23, 2011, at 9:36 AM, ebdb wrote:
>
> > Hi. I'm just setting up my account and dev machine. I'd like to try to
> > get my PostgreSQL version on my dev machine as close as possible to
> > what's on Heroku.
> >
> > What version would that be?
> >
> > Thanks!
> >
> > E
> >
> > --
> > You received this message because you are subscribed to the Google Groups
> "Heroku" group.
> > To post to this group, send email to heroku@googlegroups.com.
> > To unsubscribe from this group, send email to
> heroku+unsubscr...@googlegroups.com.
> > For more options, visit this group at
> http://groups.google.com/group/heroku?hl=en.
> >
>
> --
> You received this message because you are subscribed to the Google Groups
> "Heroku" group.
> To post to this group, send email to heroku@googlegroups.com.
> To unsubscribe from this group, send email to
> heroku+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/heroku?hl=en.
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Heroku" group.
To post to this group, send email to heroku@googlegroups.com.
To unsubscribe from this group, send email to 
heroku+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/heroku?hl=en.

Re: What version of PostgreSQL does Heroku use?

[Aaron Brethorst]

>From your app's Heroku console you should be able to do the following:

>> `psql --version`
=> "psql (PostgreSQL) 8.3.14\ncontains support for command-line editing\n"

On Sep 23, 2011, at 9:36 AM, ebdb wrote:

> Hi. I'm just setting up my account and dev machine. I'd like to try to
> get my PostgreSQL version on my dev machine as close as possible to
> what's on Heroku.
> 
> What version would that be?
> 
> Thanks!
> 
> E
> 
> -- 
> You received this message because you are subscribed to the Google Groups 
> "Heroku" group.
> To post to this group, send email to heroku@googlegroups.com.
> To unsubscribe from this group, send email to 
> heroku+unsubscr...@googlegroups.com.
> For more options, visit this group at 
> http://groups.google.com/group/heroku?hl=en.
> 

-- 
You received this message because you are subscribed to the Google Groups 
"Heroku" group.
To post to this group, send email to heroku@googlegroups.com.
To unsubscribe from this group, send email to 
heroku+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/heroku?hl=en.

What version of PostgreSQL does Heroku use?

[ebdb]

Hi. I'm just setting up my account and dev machine. I'd like to try to
get my PostgreSQL version on my dev machine as close as possible to
what's on Heroku.

What version would that be?

Thanks!

E

-- 
You received this message because you are subscribed to the Google Groups 
"Heroku" group.
To post to this group, send email to heroku@googlegroups.com.
To unsubscribe from this group, send email to 
heroku+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/heroku?hl=en.