Package Details: postgresql-testing 9.4beta3-1

Git Clone URL: https://aur.archlinux.org/postgresql-testing.git (read-only)
Package Base: postgresql-testing
Description: Beta version of the PostgreSQL database (includes both server and libs)
Upstream URL: https://wiki.postgresql.org/wiki/HowToBetaTest
Licenses: custom:PostgreSQL
Conflicts: postgresql, postgresql-libs, postgresql-testing
Provides: postgresql=9.4beta3, postgresql-libs=9.4beta3
Submitter: intgr
Maintainer: intgr
Last Packager: intgr
Votes: 8
Popularity: 0.000000
First Submitted: 2009-10-28 01:32
Last Updated: 2015-06-08 10:03

Dependencies (7)

Required by (358)

Sources (7)

Latest Comments

quido commented on 2015-10-16 08:51

9.5beta1 please?
http://www.postgresql.org/about/news/1614/
Gotta try them BRIN indices.

intgr commented on 2014-12-09 12:50

Thanks @kiz, sorry for procrastinating on this for so long. :(

If you want to take over maintainership, let me know.

kiz commented on 2014-11-28 03:09

9.4rc1
https://gist.githubusercontent.com/kokizzu/bb3ea504147e3567f2d4/raw/c367a5c30ec3e0046ef2c4122bb8bb8247a5bb06/postgresql-testing-9.4rc1

intgr commented on 2014-10-14 18:29

Updated to 9.4beta3: http://www.postgresql.org/about/news/1547/

Again, a pg_upgrade is required; do that BEFORE installing the new package version.

intgr commented on 2014-07-25 07:35

Updated to 9.4beta2: http://www.postgresql.org/about/news/1533/

This version requires a pg_upgrade like last time, BEFORE installing the new package version.

intgr commented on 2014-05-20 17:30

Updated to 9.4beta1.

The upgrade procedure from 9.3 is the same as before. After makepkg and BEFORE INSTALLING, run:

systemctl stop postgresql
mv /var/lib/postgres/data /var/lib/postgres/data9.3
sudo -u postgres /PATH/TO/postgresql-testing/pkg/postgresql-testing/usr/bin/initdb --locale en_US.UTF-8 -D /var/lib/postgres/data
cd /tmp
sudo -u postgres /PATH/TO/postgresql-testing/pkg/postgresql-testing/usr/bin/pg_upgrade -b /usr/bin -B /PATH/TO/postgresql-testing/pkg/postgresql-testing/usr/bin -d /var/lib/postgres/data9.3 -D /var/lib/postgres/data
# install new package
start postgresql

chungy commented on 2014-05-19 03:29

9.4beta1 is out

intgr commented on 2013-09-09 14:14

Updated to 9.3.0 final release, see release announcement: http://www.postgresql.org/about/news/1481/

Sorry I missed the rc1 :)

When upgrading from beta2, no pg_upgrade is necessary.

For upgrading from beta1 or earlier, see the pg_upgrade instructions in earlier comments.

intgr commented on 2013-07-30 17:50

Updated to 9.3beta2, I also fixed the provides= line so dependencies now correctly detect it as newer than 9.2. For upstream changes, see: http://www.postgresql.org/about/news/1471/

The catalog on-disk format has changed between beta1 and beta2, so you need to perform the upgrade procedure again like last time. BUILD this package first, but DO NOT INSTALL yet. Then perform these steps:

systemctl stop postgresql
mv /var/lib/postgres/data /var/lib/postgres/data-old
sudo -u postgres /PATH/TO/postgresql-testing/pkg/postgresql-testing/usr/bin/initdb --locale en_US.UTF-8 -D /var/lib/postgres/data
cd /tmp
sudo -u postgres /PATH/TO/postgresql-testing/pkg/postgresql-testing/usr/bin/pg_upgrade --link -b /usr/bin -B /PATH/TO/postgresql-testing/pkg/postgresql-testing/usr/bin -d /var/lib/postgres/data-old -D /var/lib/postgres/data

After this has successfully finished, you can install the package and 'systemctl start postgresql' again.


@mappi
Sorry, I have been on vacation and too lazy to update this package. Yes, I will continue to update this package with newer betas and RC versions. Usually I'm faster with my updates.

> Maybe, for testing could be created postgresql-libs-testing package ?

That's not needed, the libs are included with postgresql-testing. But it wasn't working correctly before, because I had the provides= line wrong. It should be fixed now. Let me know if you still have problems.

mappi commented on 2013-07-16 09:12

Before I've looking this package I would like creating own package for PostgreSQL 9.3 Beta / Release Candidate versions for testing it. I've installing and testing your this package and it's work fine. But for use contrib libraries I could install additional libraries (please look to postgresql-libs package in Extra repository of Archlinux).

Now, I have 2 proposals for changing:
- It's there possible upgrade this postgres-testing package to last version 9.3 Beta 2 of PostgreSQL? And next time to Release Candidate version (when it will publish) ?
- In Extra Archlinux repository we are 2 PostgreSQL main pacakages: postgresql and postgresql-libs. Maybe, for testing could be created postgresql-libs-testing package ?

mappi commented on 2013-07-16 07:55

Before I've looking this package I would like creating own package for PostgreSQL 9.3 Beta. I've installing and testing this AUR package and it's works fine.

Now, I have 2 proposals:
- It's there possible upgrade postgres-testing package to last PostgreSQL 9.2 Beta 2 ? And next time to Release Candidate version ?
- In Extra Archlinux repository we are 2 PostgreSQL main pacakages: postgresql and postgresql-libs. Mayube, for testing could be created postgresql-libs-testing package ?

intgr commented on 2013-05-09 20:24

Updated to 9.3beta1: http://www.postgresql.org/docs/devel/static/release-9-3.html

You can upgrade from your current PostgreSQL database with pg_upgrade (run after building, before installing the testing version):

systemctl stop postgresql
mv /var/lib/postgres/data /var/lib/postgres/data9.2
sudo -u postgres /PATH/TO/postgresql-testing/pkg/postgresql-testing/usr/bin/initdb --locale en_US.UTF-8 -D /var/lib/postgres/data
cd /tmp
sudo -u postgres /PATH/TO/postgresql-testing/pkg/postgresql-testing/usr/bin/pg_upgrade -b /usr/bin -B /PATH/TO/postgresql-testing/pkg/postgresql-testing/usr/bin -d /var/lib/postgres/data9.2 -D /var/lib/postgres/data

intgr commented on 2012-09-12 10:41

Updated to 9.2.0

@0x1997 I'm sorry, I see the mistake now (and double sorry for not reading your comment properly!)
I updated the .service and postgresql-initdb script from systemd-arch-units now, hopefully it will work for you now. :)

intgr commented on 2012-09-05 08:43

@0x1997 Upstream explicitly refused using EnvironmentFile and I am not going to maintain my own fork of postgresql.service just for the 3 users of this testing package.
Please submit to upstream, either Arch Linux directly or systemd-arch-units (https://github.com/falconindy/systemd-arch-units/). Then ping me to update it from upstream.

I've been using this service for ages now; it's ugly, but it works. Maybe there's something in your environment that needs to be tweaked for it to work.

0x1997 commented on 2012-09-05 03:46

Can't start postgresql using systemd. Please update postgresql.servie to this https://gist.github.com/3629914 or instead of adding Environment=PGROOT=/var/lib/postgres you can uncomment the line PGROOT="/var/lib/postgres" in postgresql.confd

intgr commented on 2012-08-28 09:42

Updated to 9.2rc1

intgr commented on 2012-08-27 10:40

Updated to 9.2beta4

intgr commented on 2012-08-24 10:25

Updated again, added postgresql.service & files for systemd (since systemd-arch-units no longer ships them)

intgr commented on 2012-08-24 08:31

Updated to 9.2beta3

intgr commented on 2012-06-20 08:13

Updated to 9.2beta2. Sorry about the delay :)

intgr commented on 2012-05-16 17:35

Updated to 9.2beta1

intgr commented on 2011-09-11 17:35

Updated to 9.1.0

intgr commented on 2011-08-31 09:12

THIS PACKAGE IS DEPRECATED!

Please use postgresql-testing instead: https://aur.archlinux.org/packages.php?ID=31562

intgr commented on 2011-08-31 08:26

Updated to 9.1rc1

intgr commented on 2011-08-12 15:36

Updated to 9.1beta3

intgr commented on 2011-06-17 17:03

Updated to 9.1beta2

intgr commented on 2011-05-02 19:10

Updated to 9.1beta1

intgr commented on 2011-04-07 19:38

Updated to 9.1alpha5

intgr commented on 2011-03-11 00:03

Updated to 9.1alpha4

intgr commented on 2011-01-10 21:21

Updated to 9.1alpha3

intgr commented on 2010-11-05 14:44

Updated to version 9.1alpha2: http://www.postgresql.org/about/news.1252
Some exciting optimization work here, especially for partitioned tables :)

intgr commented on 2010-09-25 01:12

Updated to version 9.1alpha1: http://developer.postgresql.org/pgdocs/postgres/release-9-1-alpha.html

intgr commented on 2010-09-01 19:39

@dserban: Yes it's safe. For some reason, a Makefile generated by automake is put into /usr/lib/postgresql/pgxs/src by 'make install'
I'm trying to figure out what it is and why it's there now. But in any case it's totally harmless.

dserban commented on 2010-09-01 19:18

At the end of the building process I get a warning:
==> Tidying install...
-> Purging other files...
-> Compressing man and info pages...
==> WARNING: Package contains reference to $srcdir
==> Creating package...
-> Generating .PKGINFO file...
-> Compressing package...
==> Leaving fakeroot environment.

Is it safe to ignore the $srcdir warning?

intgr commented on 2010-09-01 17:21

Thanks dserban, updated to 9.0rc1.

dserban commented on 2010-09-01 13:17

PostgreSQL 9.0 Release Candidate 1:
http://www.postgresql.org/about/news.1230

intgr commented on 2010-08-03 10:01

Updated to 9.0beta4

intgr commented on 2010-05-04 13:05

Updated to 9.0beta1: http://lwn.net/Articles/385907/