4 ms·

What's the easiest way to try out an alpha version of postgres? I can't find a ubuntu or homebrew pacakged build of it... easiest to build it from source? edit

by po 11y ago

What's the easiest way to try out an alpha version of postgres? I can't find a ubuntu or homebrew pacakged build of it... easiest to build it from source? edit: seems like the alpha release is available on the downloads page now: http://www.postgresql.org/download/ http://www.postgresql.org/download/

anarazel 11y ago
https://wiki.postgresql.org/wiki/Apt/FAQ#I_want_to_try_the_beta_version_of_the_next_PostgreSQL_release https://wiki.postgresql.org/wiki/Apt/FAQ#I_want_to_try_the_b... Could be explained a bit better...
leftnode 11y ago
Building Postgres from source for testing is relatively simple - at least on Ubuntu / Debian. useradd --home-dir /home/postgres \ --create-home --shell /bin/bash \ --user-group postgres apt-get install -y build-essential libkrb5-dev \ libxml2 libxml2-dev libxslt1-dev \ libossp-uuid-dev uuid python-dev \ libreadline6 libreadline-dev ./configure --disable-debug --enable-thread-safety \ --with-gssapi --with-openssl \ --with-libxml --with-libxslt \ --with-ossp-uuid --with-python \ --without-bonjour make world && make install sudo su - postgres -c "/usr/local/pgsql/bin/initdb -D /home/postgres/cluster -E UTF8"
- mslate 11y ago
  > "Relatively simple - at least on Ubuntu / Debian" I realize we're all professionals here and technical know-how is expected, but nothing about this is "simple". Brings me PTSD of working w/ academics' alphabet soup of "open source" simulation code written in C, Perl and Makefiles. Build tools have come along away, maybe not with vanilla Postgres installs, but I guess that's what DBAs are paid to know these days.
  - craigching 11y ago
    I honestly don't see what's so hard about the gp's set of instructions. Your grandma doesn't need to install alpha builds of PostgreSQL (though I shouldn't assume, there are some technical grandmas out there ;) ), for 99% of people out there they can use "apt-get" or "yum" or whatever and can wait until the release. So let's turn this around, how would you like to see builds become easier?
    - mslate 11y ago
      I was cranky earlier, I just want better documentation. Postgres has slowly gotten better about this over the years.
- anarazel 11y ago
  > apt-get install -y build-essential libkrb5-dev ... This can slightly more easily done using 'apt-get build-dep postgresql-9.4'. That'll also pull in the tools to build the docs, but I'd consider that a good thing. > make world && make install You're building world, but not installing it -> make install-world.
- fake-name 11y ago
  Wow, I would have killed to have just that list last weekend. I spent ~4 hours figuring most of it out myself.
pbnjay 11y ago
If you're on Mac, Postgres.app has an alpha build on github: https://github.com/PostgresApp/PostgresApp/releases https://github.com/PostgresApp/PostgresApp/releases
subleq 11y ago
There is a docker container with everything set up: http://www.databasesoup.com/2015/07/test-postgresql-95-alpha-in-docker.html http://www.databasesoup.com/2015/07/test-postgresql-95-alpha...
deleted 11y ago
[deleted]
Vitaly 11y ago
Docker

by po 11y ago

anarazel 11y ago

https://wiki.postgresql.org/wiki/Apt/FAQ#I_want_to_try_the_beta_version_of_the_next_PostgreSQL_release https://wiki.postgresql.org/wiki/Apt/FAQ#I_want_to_try_the_b... Could be explained a bit better...

leftnode 11y ago

Building Postgres from source for testing is relatively simple - at least on Ubuntu / Debian. useradd --home-dir /home/postgres \ --create-home --shell /bin/bash \ --user-group postgres apt-get install -y build-essential libkrb5-dev \ libxml2 libxml2-dev libxslt1-dev \ libossp-uuid-dev uuid python-dev \ libreadline6 libreadline-dev ./configure --disable-debug --enable-thread-safety \ --with-gssapi --with-openssl \ --with-libxml --with-libxslt \ --with-ossp-uuid --with-python \ --without-bonjour make world && make install sudo su - postgres -c "/usr/local/pgsql/bin/initdb -D /home/postgres/cluster -E UTF8"

mslate 11y ago
> "Relatively simple - at least on Ubuntu / Debian" I realize we're all professionals here and technical know-how is expected, but nothing about this is "simple". Brings me PTSD of working w/ academics' alphabet soup of "open source" simulation code written in C, Perl and Makefiles. Build tools have come along away, maybe not with vanilla Postgres installs, but I guess that's what DBAs are paid to know these days.
- craigching 11y ago
  I honestly don't see what's so hard about the gp's set of instructions. Your grandma doesn't need to install alpha builds of PostgreSQL (though I shouldn't assume, there are some technical grandmas out there ;) ), for 99% of people out there they can use "apt-get" or "yum" or whatever and can wait until the release. So let's turn this around, how would you like to see builds become easier?
  - mslate 11y ago
    I was cranky earlier, I just want better documentation. Postgres has slowly gotten better about this over the years.
anarazel 11y ago
> apt-get install -y build-essential libkrb5-dev ... This can slightly more easily done using 'apt-get build-dep postgresql-9.4'. That'll also pull in the tools to build the docs, but I'd consider that a good thing. > make world && make install You're building world, but not installing it -> make install-world.
fake-name 11y ago
Wow, I would have killed to have just that list last weekend. I spent ~4 hours figuring most of it out myself.

pbnjay 11y ago

If you're on Mac, Postgres.app has an alpha build on github: https://github.com/PostgresApp/PostgresApp/releases https://github.com/PostgresApp/PostgresApp/releases

subleq 11y ago

There is a docker container with everything set up: http://www.databasesoup.com/2015/07/test-postgresql-95-alpha-in-docker.html http://www.databasesoup.com/2015/07/test-postgresql-95-alpha...

deleted 11y ago

[deleted]

Vitaly 11y ago

Docker