PostgreSQL-JDBC (was: PostgreSQL 8.1.2)

2006-02-01 Thread Matthias Kilian
On Tue, Jan 31, 2006 at 12:34:20PM +0100, Marc Balmer wrote: > Find attached a diff for a minor PostgreSQL update to version 8.1.2. Quick test: works for me (on i386). Hijacking this thread: I've a port for the Java freaks (PostgreSQL-JDBC), but I'd not yet the time to make

postgresql

2009-09-07 Thread frantisek holop
hi there, i am a postgres newbie, and tonight i installed it for the first time. amaaq$ sudo pkg_add postgresql-server No packages available in the PKG_PATH useradd: Warning: home directory `/var/postgresql' doesn't exist, and -m was not specified postgresql-server-8.4.0

Re: PostgreSQL-JDBC (was: PostgreSQL 8.1.2)

2006-07-16 Thread Matthias Kilian
[Sorry for reanimating such an old thread, but] On Sat, Feb 04, 2006 at 09:16:44AM +0100, Marc Balmer wrote: > > Hijacking this thread: I've a port for the Java freaks (PostgreSQL-JDBC), > > but I'd not yet the time to make regress work. [...] > It would surely make

postgresql readme

2020-02-11 Thread Stuart Henderson
It's always annoying to look through postgresql.conf to figure out which things you've changed and which are default settings. Fortunately with postgresql-previous we have a default postgresql.conf that's likely to be close to the one in the old version, so we can diff it to give a

PostgreSQL 12.0

2019-10-03 Thread Jeremy Evans
PostgreSQL 12.0 was released today. Here's a diff to update to it. Tested briefly on amd64, no issues noted. Unless another kind soul takes care of it first, I will be working on updating the rest of the ports tree to work with PostgreSQL 12 during p2k19. Thanks, Jeremy Index: Mak

PostgreSQL 9.6.2

2017-02-09 Thread Pierre-Emmanuel André
Hi, Small diff to update PostgreSQL to it's latest stable version. Release note here: https://www.postgresql.org/about/news/1733/ Comments, ok ? Regards, Index: Makefile === RCS file: /cvs/ports/databases/postgresql/Makef

PostgreSQL updates

2016-05-13 Thread Pierre-Emmanuel André
Hi, These 2 diffs update PostgreSQL to version 9.4.8 (OpenBSD -stable) and to version 9.5.3 (OpenBSD -current). Both tested on @amd64. Comments, ok ? Regards, Index: Makefile === RCS file: /cvs/ports/databases/postgresql/Makefile,v

postgresql syslog

2014-03-26 Thread Jan Stary
I am trying to setup syslog logging for a postgresql 9.3.2 server on current/amd64. All goes well except, the postgresql server seems to not notice whan the log rotates via newsyslog. /var/postgresql/logfile 600 100 *@T00 Z When this happens, no fourther messages are logged; as if the

PostgreSQL 9.2

2012-09-11 Thread Pierre-Emmanuel André
Hi, PostgreSQL 9.2 is out. Release notes: http://www.postgresql.org/docs/9.2/static/release-9-2.html Announcement: http://www.postgresql.org/about/news/1415/ As usual a dump/restore is required (we don't support yet pg_upgrade). Feedbacks welcome. Regards, -- Pierre-Emmanuel André GP

PostgreSQL 8.1.2

2006-01-31 Thread Marc Balmer
Find attached a diff for a minor PostgreSQL update to version 8.1.2. - Marc Balmer diff -urN -x CVS databases/postgresql/Makefile mystuff/ports/databases/postgresql/Makefile --- databases/postgresql/Makefile Sat Jan 14 23:33:53 2006 +++ mystuff/ports/databases/postgresql/Makefile Tue Jan

Postgresql port

2006-02-21 Thread David B.
itten for Apache2/PHP4/Postgresql 8.x.x and am trying to move everything over to an ultrasparc running openbsd. I have purchased 3.7 from you, but apparently you only have a compiled packages of Postgresql 8.x.x for your version 3.8, so I'll have to buy new install media, which doesn't r

Re: postgresql

2009-09-07 Thread Stuart Henderson
On 2009/09/07 23:16, frantisek holop wrote: > hi there, > > i am a postgres newbie, and tonight i installed it for the > first time. > > amaaq$ sudo pkg_add postgresql-server > No packages available in the PKG_PATH > useradd: Warning: home directory `/var/postgresql&#x

Re: postgresql

2009-09-07 Thread patrick keshishian
On Mon, Sep 7, 2009 at 2:30 PM, Stuart Henderson wrote: > On 2009/09/07 23:16, frantisek holop wrote: >> hi there, >> >> i am a postgres newbie, and tonight i installed it for the >> first time. >> >> amaaq$ sudo pkg_add postgresql-server >> No

Re: postgresql

2009-09-07 Thread frantisek holop
hmm, on Mon, Sep 07, 2009 at 10:30:05PM +0100, Stuart Henderson said that > I really dislike that with the space, and don't think it helps much > with copy-and-paste either. I'd be happy just removing it though it definitely helps with a lot of terminals that do not consider '.' as a separating ch

Re: postgresql

2009-09-07 Thread Chris Bennett
frantisek holop wrote: hmm, on Mon, Sep 07, 2009 at 10:30:05PM +0100, Stuart Henderson said that I really dislike that with the space, and don't think it helps much with copy-and-paste either. I'd be happy just removing it though it definitely helps with a lot of terminals that do no

Re: postgresql

2009-09-07 Thread frantisek holop
hmm, on Mon, Sep 07, 2009 at 05:23:04PM -0500, Chris Bennett said that >> it definitely helps with a lot of terminals that do not consider >> '.' as a separating character for obvious reasons... instead '.' is part of URLs and files. i find it unproductive to make it a seperating character. i a

PostgreSQL 9.0

2010-05-03 Thread Pierre-Emmanuel André
/postgresql/Makefile,v retrieving revision 1.126 diff -u -p -r1.126 Makefile --- Makefile23 Mar 2010 10:24:45 - 1.126 +++ Makefile3 May 2010 10:18:29 - @@ -5,7 +5,7 @@ COMMENT-server= PostgreSQL RDBMS (server COMMENT-docs= PostgreSQL RDBMS documentation COMMENT-contrib=PostgreSQL

PostgreSQL 15.4

2023-08-10 Thread Jeremy Evans
Simple update to the latest release of PostgreSQL. Release announcement at: https://www.postgresql.org/about/news/postgresql-154-149-1312-1216-1121-and-postgresql-16-beta-3-released-2689/ Fixes a couple CVEs: CVE-2023-39417: Extension script @substitutions@ within quoting allow SQL injection

PostgreSQL 15.2

2023-02-09 Thread Jeremy Evans
This updates to PostgreSQL 15.2, released today. Release announcement: https://www.postgresql.org/about/news/postgresql-152-147-1310-1214-and-1119-released-2592/ One security issue, CVE-2022-41862: Client memory disclosure when connecting, with Kerberos, to modified server. Is there anyone

PostgreSQL 14.5

2022-08-12 Thread Jeremy Evans
Apparently I was not paying attention back in June when they released 14.4. In my defense, no CVE in the 14.4 release. The 14.5 release fixes CVE-2022-2625. Release announcements: https://www.postgresql.org/about/news/postgresql-144-released-2470/ https://www.postgresql.org/about/news

database/postgresql, update to PostgreSQL 8.2.x series

2007-01-15 Thread Marc Balmer
some time in the (near?) future I will update our port of the PostgreSQL database to version 8.2.x. We currently have version 8.1.x in the tree, so the update will require you to do a database dump prior to the update and a restore after it. please make sure to read the release notes at http

If you run MediaWiki on PostgreSQL and update PostgreSQL...

2008-05-08 Thread Marc Balmer
A message from your friendly MediaWiki maintainer: If you use MediaWiki on OpenBSD with the PostgreSQL database, be careful when updating PostgreSQL from 8.2.x to 8.3.x, a dump and restore is not enough: Dump your wiki database. Split the dump into to files, the first one containing only

Update: PostgreSQL 16.2

2024-02-08 Thread Jeremy Evans
This updates PostgreSQL to 16.2. Release announcement at https://www.postgresql.org/about/news/postgresql-162-156-1411-1314-and-1218-released-2807/ This fixes one CVE: CVE-2024-0985: PostgreSQL non-owner REFRESH MATERIALIZED VIEW CONCURRENTLY executes arbitrary SQL Tested on

Update: PostgreSQL 16.3

2024-05-09 Thread Jeremy Evans
Update to the latest release of PostgreSQL. Release announcement at: https://www.postgresql.org/about/news/postgresql-163-157-1412-1315-and-1219-released-2858/ Note that there is a small (CVSS score 3.1) security fix this release that requires manual updates for existing installations (see the

Update: PostgreSQL 16.4

2024-08-08 Thread Jeremy Evans
This updates PostgreSQL to the latest release. Release announcement at: https://www.postgresql.org/about/news/postgresql-164-158-1413-1316-1220-and-17-beta-3-released-2910/ Fixes CVE-2024-7348: PostgreSQL relation replacement during pg_dump executes arbitrary SQL Tested briefly on amd64. I&#x

Re: postgresql readme

2020-02-11 Thread Klemens Nanni
On Tue, Feb 11, 2020 at 09:02:48PM +, Stuart Henderson wrote: > OK to add that to the pkg-readme? Sure, that's definitely a helpful addition.

Re: postgresql readme

2020-02-11 Thread Kurt Mosiejczuk
On Tue, Feb 11, 2020 at 09:02:48PM +, Stuart Henderson wrote: > It's always annoying to look through postgresql.conf to figure out which > things you've changed and which are default settings. > Fortunately with postgresql-previous we have a default postgresql.conf > tha

Re: postgresql readme

2020-02-11 Thread Jeremy Evans
On Tue, Feb 11, 2020 at 1:03 PM Stuart Henderson wrote: > It's always annoying to look through postgresql.conf to figure out which > things you've changed and which are default settings. > > Fortunately with postgresql-previous we have a default postgresql.conf > that&#x

Re: postgresql readme

2020-02-11 Thread Aham Brahmasmi
> Sent: Tuesday, February 11, 2020 at 9:02 PM > From: "Stuart Henderson" > To: ports , "Pierre-Emmanuel André" > Subject: postgresql readme > > It's always annoying to look through postgresql.conf to figure out which > things you've changed an

Re: postgresql readme

2020-02-12 Thread Pierre-Emmanuel André
On Tue, Feb 11, 2020 at 09:02:48PM +, Stuart Henderson wrote: > It's always annoying to look through postgresql.conf to figure out which > things you've changed and which are default settings. > > Fortunately with postgresql-previous we have a default postgresql.conf

Re: postgresql readme

2020-02-12 Thread Stuart Henderson
On 2020/02/12 07:25, Aham Brahmasmi wrote: > > PKGNAME-pg_upgrade=postgresql-pg_upgrade-${VERSION} > > -REVISION-server=0 > > +REVISION-server= 1 > > Namaste Stuart, > > Thank you for the patch. > > Would it be preferable to remove the extra space after the

[Update] PostgreSQL 11.3

2019-05-10 Thread Pierre-Emmanuel André
Hello, Small diff to update PostgreSQL to it's latest version (11.3). Release note is here : https://www.postgresql.org/about/news/1939/ 2 CVE fixed in this release: + CVE-2019-10129: Memory disclosure in partition routing + CVE-2019-10130: Selectivity estimators bypass row security pol

[Update] PostgreSQL 11.4

2019-06-21 Thread Pierre-Emmanuel André
Hello, Small diff to update PostgreSQL to it's latest version 11.4. Changelog here: https://www.postgresql.org/docs/11/release-11-4.html CVE fixed: CVE-2019-10164 Tested on @amd64. Comments, ok ? Index: Makefile === RCS file:

[Upgrade] PostgreSQL 11.6

2019-11-14 Thread Pierre-Emmanuel André
Hello, Small diff to update PostgreSQL to it's latest version 11.6. This diff is more for -stable because the plan is to upgrade -current to PostgreSQL 12.1. Tested on @amd64. Comments, ok ? Regards, Index: Makefile === RCS

Re: PostgreSQL 12.0

2019-11-14 Thread Pierre-Emmanuel Andr?
On Tue, Nov 05, 2019 at 01:29:41AM -0800, Jeremy Evans wrote: > On 10/29 07:35, Jeremy Evans wrote: > > I ran a partial bulk of the PostgreSQL dependencies, and this is what is > > broke with PostgreSQL 12: > > > > databases/citus > > databases/pg_statsinf

Re: PostgreSQL 12.0

2019-11-15 Thread Pierre-Emmanuel Andr?
On Thu, Nov 14, 2019 at 10:17:14PM +0100, Pierre-Emmanuel Andr? wrote: > On Tue, Nov 05, 2019 at 01:29:41AM -0800, Jeremy Evans wrote: > > On 10/29 07:35, Jeremy Evans wrote: > > > I ran a partial bulk of the PostgreSQL dependencies, and this is what is > > &g

Re: PostgreSQL 12.0

2019-11-16 Thread Christian Weisgerber
Pierre-Emmanuel Andr?: > > Diff updated to the latest version of PostgreSQL : 12.1. > > I think it's time to put it in a bulk. > > Updated diff after the upgrade to 11.6. I have started an amd64 bulk build with this. -- Christian "naddy" Weisgerber na...@mips.inka.de

Re: PostgreSQL 12.0

2019-11-16 Thread Christian Weisgerber
Christian Weisgerber: > > > Diff updated to the latest version of PostgreSQL : 12.1. > > > I think it's time to put it in a bulk. > > > > Updated diff after the upgrade to 11.6. > > I have started an amd64 bulk build with this. databases/postgresql fail

Re: PostgreSQL 12.0

2019-11-17 Thread Pierre-Emmanuel Andr?
On Sat, Nov 16, 2019 at 10:47:24PM +0100, Christian Weisgerber wrote: > Christian Weisgerber: > > > > > Diff updated to the latest version of PostgreSQL : 12.1. > > > > I think it's time to put it in a bulk. > > > > > > Updated diff after

Re: PostgreSQL 12.0

2019-11-18 Thread Christian Weisgerber
Pierre-Emmanuel Andr?: > Updated diff attached. I tried another test build, but that was derailed by the libcroco issue, so I don't have full results. A partial result is that databases/postgresql-plr geo/pgpointcloud fail to build. See the attached log files. I'll try yet

Re: PostgreSQL 12.0

2019-11-18 Thread Landry Breuil
On Mon, Nov 18, 2019 at 07:28:18PM +0100, Christian Weisgerber wrote: > Pierre-Emmanuel Andr?: > > > Updated diff attached. > > I tried another test build, but that was derailed by the libcroco > issue, so I don't have full results. A partial result is that > >

Re: PostgreSQL 12.0

2019-11-19 Thread Jeremy Evans
On Mon, Nov 18, 2019 at 10:30 AM Christian Weisgerber wrote: > Pierre-Emmanuel Andr?: > > > Updated diff attached. > > I tried another test build, but that was derailed by the libcroco > issue, so I don't have full results. A partial result is that > >

Re: PostgreSQL 12.0

2019-11-19 Thread Jeremy Evans
On 11/15 05:29, Pierre-Emmanuel Andr? wrote: > On Thu, Nov 14, 2019 at 10:17:14PM +0100, Pierre-Emmanuel Andr? wrote: > > On Tue, Nov 05, 2019 at 01:29:41AM -0800, Jeremy Evans wrote: > > > On 10/29 07:35, Jeremy Evans wrote: > > > > I ran a partial bulk of the Postgr

[Update] PostgreSQL 12.3

2020-05-26 Thread Pierre-Emmanuel André
Hello, Small diff to update PostgreSQL to it's latest version : 12.3 Same diff applies for -stable too. Tested on @amd64 Comments, ok? Regards, Index: Makefile === RCS file: /cvs/ports/databases/postgresql/Makefile,v retri

[Update] PostgreSQL 11.5

2019-08-08 Thread Pierre-Emmanuel André
Hello, Small diff to update PostgreSQL to it's latest release. Annoucement is here: https://www.postgresql.org/about/news/1960/ 2 CVE fixed (and 2 another on Windows systems). Tested on @amd64. Same diff apply for -stable too. Comments, ok ? Regards, Index: Mak

Re: PostgreSQL 12.0

2019-10-03 Thread Jeremy Evans
On 10/03 09:01, Jeremy Evans wrote: > PostgreSQL 12.0 was released today. Here's a diff to update to it. > Tested briefly on amd64, no issues noted. You will probably need this diff for postgresql-previous to build the package for postgresql. Thanks, Jeremy Inde

Re: PostgreSQL 12.0

2019-10-04 Thread Pierre-Emmanuel André
On Thu, Oct 03, 2019 at 11:26:13AM -0700, Jeremy Evans wrote: > On 10/03 09:01, Jeremy Evans wrote: > > PostgreSQL 12.0 was released today. Here's a diff to update to it. > > Tested briefly on amd64, no issues noted. > > You will probably need this diff for postgres

Re: PostgreSQL 12.0

2019-10-04 Thread Jeremy Evans
On 10/04 06:12, Pierre-Emmanuel Andr? wrote: > On Thu, Oct 03, 2019 at 11:26:13AM -0700, Jeremy Evans wrote: > > On 10/03 09:01, Jeremy Evans wrote: > > > PostgreSQL 12.0 was released today. Here's a diff to update to it. > > > Tested briefly on amd64, no issues n

Re: PostgreSQL 12.0

2019-10-04 Thread Christian Weisgerber
On 2019-10-03, Jeremy Evans wrote: > Unless another kind soul takes care of it first, I will be working > on updating the rest of the ports tree to work with PostgreSQL 12 > during p2k19. Good plan. This will not make 6.6. -- Christian "naddy" Weisgerber

Re: PostgreSQL 12.0

2019-10-12 Thread Jeremy Evans
On 10/04 09:27, Jeremy Evans wrote: > On 10/04 06:12, Pierre-Emmanuel Andr? wrote: > > On Thu, Oct 03, 2019 at 11:26:13AM -0700, Jeremy Evans wrote: > > > On 10/03 09:01, Jeremy Evans wrote: > > > > PostgreSQL 12.0 was released today. Here's a diff to update to

Re: PostgreSQL 12.0

2019-10-24 Thread Pierre-Emmanuel Andr?
On Sat, Oct 12, 2019 at 04:41:40PM -0700, Jeremy Evans wrote: > On 10/04 09:27, Jeremy Evans wrote: > > On 10/04 06:12, Pierre-Emmanuel Andr? wrote: > > > On Thu, Oct 03, 2019 at 11:26:13AM -0700, Jeremy Evans wrote: > > > > On 10/03 09:01, Jeremy Evans wrote:

Re: PostgreSQL 12.0

2019-10-29 Thread Jeremy Evans
rote: > > > > > On 10/03 09:01, Jeremy Evans wrote: > > > > > > PostgreSQL 12.0 was released today. Here's a diff to update to it. > > > > > > Tested briefly on amd64, no issues noted. > > > > > > > &

Re: PostgreSQL 12.0

2019-11-05 Thread Jeremy Evans
On 10/29 07:35, Jeremy Evans wrote: > I ran a partial bulk of the PostgreSQL dependencies, and this is what is > broke with PostgreSQL 12: > > databases/citus > databases/pg_statsinfo > databases/kdb > databases/postgresql-pllua > databases/postgresql-plv8 > databases/

[Update] PostgreSQL 12.4

2020-08-13 Thread Pierre-Emmanuel André
Hello, Small diff to upgrade PostgreSQL to it's latest version. Tested on @amd64. Comments, ok ? Regards Index: Makefile === RCS file: /cvs/ports/databases/postgresql/Makefile,v retrieving revision 1.263 diff -u -p -u -p -r

[Update] PostgreSQL 12.5

2020-11-12 Thread Pierre-Emmanuel André
Hello, Small diff to update PostgreSQL to it's latest version: 12.5 Changelog here: https://www.postgresql.org/about/news/postgresql-131-125-1110-1015-9620-and-9524-released-2111/ Comments, ok ? Regards, Index: Makefile ==

PostgreSQL 13.1 Upgrade

2020-11-20 Thread Jeremy Evans
Now that PostgreSQL 13.1 is out, I think we can consider upgrading to it. The diff below was tested on amd64 on a partial bulk of the ports depending on PostgreSQL. Thankfully, the changes were less extensive than in previous PostgreSQL major updates. Briefly, the changes: citus 9.0.1 -> 9.

[Update] PostgreSQL 10.5

2018-08-09 Thread Pierre-Emmanuel André
Hi, Small diff to update PostgreSQL to it's latest version. Release note : https://www.postgresql.org/about/news/1878/ Fix for 2 CVE: CVE-2018-10915 and CVE-2018-10925 Tested on @amd64. Comments, ok ? Regards, ps: diff for 6.3 will follow. Index: Mak

[Update] PostgreSQL 10.6

2018-11-08 Thread Pierre-Emmanuel André
Hi, Here is a diff to update PostgreSQL to it's latest version (10.6). Release note : https://www.postgresql.org/about/news/1905/ (It fixes CVE-2018-16850) Tested on @amd64. Comments, ok ? Regards, Index: Makefile === RCS

postgresql readme cleanup

2015-07-30 Thread Kirill Bychkov
Hi. This removes some trailing white spaces and add RSC id and header to README-plpython. OK? Index: Makefile === RCS file: /cvs/ports/databases/postgresql/Makefile,v retrieving revision 1.206 diff -u -r1.206 Makefile --- Makefile

Re: PostgreSQL 9.5.0

2016-01-08 Thread Stuart Henderson
On 2016/01/08 07:59, Jeremy Evans wrote: > -SHARED_LIBS= ecpg7.6 \ > - ecpg_compat 4.6 \ > - pgtypes 4.5 \ > - pq 5.7 > +SHARED_LIBS= ecpg7.7 \ > + ecpg_compat 4.7 \ > + pgtypes

security: postgresql 9.4.6

2016-02-12 Thread Stuart Henderson
"This release closes security hole CVE-2016-0773, an issue with regular expression (regex) parsing. Prior code allowed users to pass in expressions which included out-of-range Unicode characters, triggering a backend crash. This issue is critical for PostgreSQL systems with untrusted use

[Security] PostgreSQL 9.4.7

2016-04-01 Thread Pierre-Emmanuel André
Hi, Small diff to upgrade PostgreSQL to version 9.4.7. It's a security fix ( CVE-2016-2193 and CVE-2016-3065). More informations here: http://www.postgresql.org/about/news/1656/ Tested on @amd64. This diff applies to 5.9 and 5.8 too. Ok to commit ? Regards, Index: Mak

Re: PostgreSQL 9.5.0

2016-04-01 Thread Kim Lidström
So what happened with this patch? Was it forgotten? Seems like postgresql is at 9.5.2 now.

Re: PostgreSQL 9.5.0

2016-04-02 Thread Pierre-Emmanuel André
On Fri, Apr 01, 2016 at 10:27:30PM +0200, Kim Lidström wrote: > So what happened with this patch? Was it forgotten? > > Seems like postgresql is at 9.5.2 now. > I will send an updated diff for 9.5.2. I'm testing it right now.

Re: PostgreSQL 9.5.0

2016-04-03 Thread Jeremy Evans
On Sun, Apr 3, 2016 at 4:17 AM, Pierre-Emmanuel André wrote: > On Sat, Apr 02, 2016 at 12:40:00PM +0200, Pierre-Emmanuel André wrote: > > On Fri, Apr 01, 2016 at 10:27:30PM +0200, Kim Lidström wrote: > > > So what happened with this patch? Was it forgotten? > > > >

[Update] PostgreSQL 10.4

2018-05-13 Thread Pierre-Emmanuel André
Hi, Small diff to update PostgreSQL to it's latest version. Release note : https://www.postgresql.org/about/news/1851/ There is a CVE fix : CVE-2018-1115: Too-permissive access control list on function pg_logfile_rotate() Comments, ok ? Regards, Index: Mak

Re: PostgreSQL 9.5.0

2016-05-15 Thread Stuart Henderson
On 2016/04/03 13:17, Pierre-Emmanuel André wrote: > -SHARED_LIBS= ecpg7.6 \ .. > - pq 5.7 > + pq 6.8 For future reference, major bump usually means minor gets reset to 0.

[Security] PostgreSQL 9.5.4

2016-08-12 Thread Pierre-Emmanuel André
Hi, This diff updates PostgreSQL to it's latest version: 9.5.4. Release note here: https://www.postgresql.org/docs/9.5/static/release-9-5-4.html This version fixes 2 CVE: CVE-2016-5423 and CVE-2016-5424 This diff applies to OpenBSD -current and OpenBSD 6.0. Diff for 5.9 is coming. Comment

Re: PostgreSQL 9.6.0

2016-09-30 Thread Rafael Sadowski
On Fri Sep 30, 2016 at 11:05:01AM +0200, Pierre-Emmanuel André wrote: > Hi, > > The new release of PostgreSQL is available. > Release note: https://www.postgresql.org/docs/9.6/static/release-9-6.html > For those who want to play with parallel queries, you have to enable them

Re: PostgreSQL 9.6.0

2016-09-30 Thread Pierre-Emmanuel André
On Fri, Sep 30, 2016 at 12:27:39PM +0200, Rafael Sadowski wrote: > On Fri Sep 30, 2016 at 11:05:01AM +0200, Pierre-Emmanuel André wrote: > > Hi, > > > > The new release of PostgreSQL is available. > > Release note: https://www.postgresql.org/docs/9.6/static/release-9-6.

[UPDATE] PostgreSQL 11.2

2019-02-19 Thread Pierre-Emmanuel André
Hello, Now that PostgreSQL 11.1 is in, we can upgrade it to the latest version (11.2). Tested on @amd64. Comments, ok ? Regards, Index: Makefile === RCS file: /cvs/ports/databases/postgresql/Makefile,v retrieving revision 1.248 diff

[Security] PostgreSQL 9.6.3

2017-05-11 Thread Pierre-Emmanuel André
Hi, The latest version of PostgreSQL fixes 3 CVE ( https://www.postgresql.org/about/news/1746/ ) Tested on @amd64. OK ? Index: Makefile === RCS file: /cvs/ports/databases/postgresql/Makefile,v retrieving revision 1.224 diff -u -p

[Update] PostgreSQL 9.6.5

2017-09-13 Thread Pierre-Emmanuel André
Hi, Small diff to update PostgreSQL to it's latest version : https://www.postgresql.org/about/news/1777/ Tested on @amd64 Comments, ok ? Regards, Index: Makefile === RCS file: /cvs/ports/databases/postgresql/Makefile,v retri

PostgreSQL security update

2017-11-10 Thread Pierre-Emmanuel André
Hi, Small diff to update PostgreSQL to it's latest version (9.6.6) Release notes: https://www.postgresql.org/docs/9.6/static/release-9-6-6.html (3 CVE fixed) Comments, ok ? Regards, ps: 10.1 is coming but need more tests ;) Index: Mak

[Update] PostgreSQL 10.2

2018-02-08 Thread Pierre-Emmanuel André
Hi, Small diff to update PostgreSQL to it's latest version (10.2). Release note is here: https://www.postgresql.org/about/news/1829/ It fixes 2 CVEs : CVE-2018-1052 and CVE-2018-1053 Comments, ok ? Diff for -stable will follow. Regards, Index: Mak

[Update] PostgreSQL 10.3

2018-03-01 Thread Pierre-Emmanuel André
Hi, Small diff to update PostgreSQL to it's latest stable version (10.3). This version fixes a CVE : CVE-2018-1058 Release note here: https://www.postgresql.org/about/news/1834/ Tested on @amd64. Diff for -stable will follow. Comments, ok ? Regards, Index: Mak

[Update] PostgreSQL 9.2.2

2012-12-08 Thread Pierre-Emmanuel André
Hi, Bugfix update to the latest PostgreSQL version. Release notes are here: http://www.postgresql.org/docs/9.2/static/release-9-2-2.html Please note that you may need to perform REINDEX operations. Comments/ok ? Regards,Index: Makefile

PostgreSQL: Critical update !

2013-12-29 Thread Pierre-Emmanuel André
Hi, The PostgreSQL group has released a critical update to all supported versions of PostgreSQL databases. This update fixes three serious data-loss bugs affecting replication and database maintenance. Annoucement: http://www.postgresql.org/about/news/1492/ More informations here: https

Re: postgresql syslog

2014-03-26 Thread patrick keshishian
On 3/26/14, Jan Stary wrote: > I am trying to setup syslog logging > for a postgresql 9.3.2 server on current/amd64. > All goes well except, the postgresql server seems > to not notice whan the log rotates via newsyslog. > > /var/postgresql/logfile 600 100 *@T00 Z >

Re: postgresql syslog

2014-03-26 Thread Stuart Henderson
On 2014/03/26 20:23, Jan Stary wrote: > I am trying to setup syslog logging > for a postgresql 9.3.2 server on current/amd64. > All goes well except, the postgresql server seems > to not notice whan the log rotates via newsyslog. > > /var/postgresql/logfile 600 100 *@T00

[WIP] PostgreSQL 9.2

2012-05-15 Thread Pierre-Emmanuel André
Hi, WIP diff to test beta 1 of PostgreSQL 9.2. Major performance and scalability advances in this version include: + Index-only scans, allowing users to avoid inefficient scans of base tables + Enhanced read-only workload scaling to 64 cores and over 300,000 queries per second + Improvements

Re: PostgreSQL 9.2

2012-09-24 Thread Pierre-Emmanuel André
On Tue, Sep 11, 2012 at 09:42:48AM +0200, Pierre-Emmanuel André wrote: > Hi, > > PostgreSQL 9.2 is out. > Release notes: http://www.postgresql.org/docs/9.2/static/release-9-2.html > Announcement: http://www.postgresql.org/about/news/1415/ > > As usual a dump/restore is requi

[Update] PostgreSQL 9.3.5

2014-09-02 Thread Pierre-Emmanuel André
Hi, Small diff to update PostgreSQL to it's latest version. Tested on @amd64. Comments, ok ? Regards, -- Pierre-Emmanuel André GPG key: 0xBB8D3F0E Index: Makefile === RCS file: /cvs/ports/databases/postgresql/Makef

postgresql rc.d script

2014-09-22 Thread frantisek holop
i installed postgresql and starting to use it for first time. here is what i think could be improved. 1. i think the postgres package readme could mention, that while there is no default database location the rc.d script has /var/postgresql/data hardcoded in it. 2. without actually

Re: PostgreSQL 9.4.0

2014-12-24 Thread Stuart Henderson
On 2014/12/23 17:08, Pierre-Emmanuel André wrote: > Hi, > > Here is a diff for the latest version of PostgreSQL (9.4.0). > + Announcement: http://www.postgresql.org/about/news/1557/ > + Release infos: http://www.postgresql.org/docs/9.4/static/release-9-4.html > > Tested on

Re: PostgreSQL 9.4.0

2014-12-24 Thread Pierre-Emmanuel André
On Wed, Dec 24, 2014 at 10:34:33AM +, Stuart Henderson wrote: > On 2014/12/23 17:08, Pierre-Emmanuel André wrote: > > Hi, > > > > Here is a diff for the latest version of PostgreSQL (9.4.0). > > + Announcement: http://www.postgresql.org/about/news/1557

Re: PostgreSQL 9.4.0

2014-12-25 Thread Landry Breuil
On Wed, Dec 24, 2014 at 12:20:14PM +0100, Pierre-Emmanuel André wrote: > On Wed, Dec 24, 2014 at 10:34:33AM +, Stuart Henderson wrote: > > On 2014/12/23 17:08, Pierre-Emmanuel André wrote: > > > Hi, > > > > > > Here is a diff for the latest version of Post

[Update] PostgreSQL 9.4.3

2015-06-04 Thread Pierre-Emmanuel André
Hi, This diff updates PostgreSQL to it's latest version (9.4.3). It's a reliability fix (file permission fix). More infos here: + http://www.postgresql.org/about/news/1590/ + https://wiki.postgresql.org/wiki/May_2015_Fsync_Permissions_Bug Tested on @amd64 on -current and 5.7. C

[Update] PostgreSQL 9.1.1

2011-09-26 Thread Pierre-Emmanuel André
Hi, Small bugfix for PostgreSQL. Changelog here: http://www.postgresql.org/docs/9.1/static/release-9-1-1.html Regards, -- Pierre-Emmanuel André GPG key: 0x7AE329DC Index: Makefile === RCS file: /cvs/ports/databases/postgresql

[Update] PostgreSQL 9.1.2

2011-12-05 Thread Pierre-Emmanuel André
Hi, Bugfixes update to the latest PostgreSQL. Changelog here: http://www.postgresql.org/docs/9.1/static/release-9-1-2.html Important things to know: + Fix bugs in information_schema.referential_constraints view (Tom Lane) This view was being insufficiently careful about matching the foreign-key

[update] PostgreSQL 9.1.3

2012-03-05 Thread Pierre-Emmanuel André
Hi, Small diff to update PostgreSQL to it's latest version. It fixes 3 CVE and a lot of bugfixes. Changelog: http://www.postgresql.org/docs/9.1/static/release-9-1-3.html Tested on @amd64 with rthreads. Regards, -- Pierre-Emmanuel André GPG key: 0x7AE329DC Index: Mak

Update: postgresql 8.4.0

2009-07-02 Thread Pierre-Emmanuel André
On Mon, Jun 01, 2009 at 12:37:35PM +0200, Simon Bertrang wrote: > Hi, > to all brave and/or interested database people, here's an update to > postgresql version 8.4beta2. > I'm totally in love with recursive join support for example... pick your > own favorite from > ht

Re: PostgreSQL 8.1.2

2006-02-01 Thread steven mestdagh
On Tue, Jan 31, 2006 at 12:34:20PM +0100, Marc Balmer wrote: > Find attached a diff for a minor PostgreSQL update to version 8.1.2. > > - Marc Balmer > diff -urN -x CVS databases/postgresql/Makefile > mystuff/ports/databases/postgresql/Makefile > --- databases/postgresql/Makef

Re: PostgreSQL 8.1.2

2006-02-01 Thread Marc Balmer
* steven mestdagh wrote: > On Tue, Jan 31, 2006 at 12:34:20PM +0100, Marc Balmer wrote: > > Find attached a diff for a minor PostgreSQL update to version 8.1.2. > > > > - Marc Balmer > > > diff -urN -x CVS databases/postgresql/Makefile > > mystuff

Re: Postgresql port

2006-02-21 Thread steven mestdagh
or someone trying to > switch over to OpenBSD from linux. > > I have extensive software written for Apache2/PHP4/Postgresql 8.x.x and am > trying to move everything over to an ultrasparc running openbsd. I have > purchased 3.7 from you, but apparently you only have a compiled packa

Re: Postgresql port

2006-02-21 Thread CS Lee
ion of Apache. Apache has > > been over version 2 for over a year, yet your version in your latest > > release is 1.3.29; that creates a lot of problems for someone trying to > > switch over to OpenBSD from linux. > > > > I have extensive software written for Apache2/P

Re: Postgresql port

2006-02-21 Thread frantisek holop
hmm, on Tue, Feb 21, 2006 at 01:27:32AM -0700, David B. said that > running as a module to handle the database requests and produce the pages, > and I really don't want to re-write the PHP pages for an older version of > PHP that works with the older version of Apache. could you be more specific

Some PostgreSQL changes

2006-03-04 Thread Marc Balmer
I will slightly change the behaviour of the PostgreSQL port when installing the server package. The database administrator username will be postgres, as recommended by the PostgreSQL developers. The uid under which the software is installed will not change. The initial database that is created

devel/postgresql-jdbc

2006-11-10 Thread Matthias Kilian
JDBC (that's Java[tm] Database Bloatware Crap) interface to posgresql. Tests (especially with jdk 1.3 and 1.4) are welcome, since I've only tested with 1.5. Please note that make regress will tune some sysctl's and that you've to shutdown any running postgresql database befor

UPDATE: PostgreSQL 8.3.3

2008-07-06 Thread Brad
An update to PostgreSQL 8.3.3. A number of failure important bug fixes. Index: Makefile === RCS file: /cvs/ports/databases/postgresql/Makefile,v retrieving revision 1.115 diff -u -p -r1.115 Makefile --- Makefile24 Mar 2008 17:26

  1   2   3   4   5   >