[BUGS] BUG #8324: Missing script
The following bug has been logged on the website: Bug reference: 8324 Logged by: Robert Stone Email address: floripa...@gmail.com PostgreSQL version: 9.2.4 Operating system: Debian 3.9-1-amd64 #1 SMP Debian 3.9.8-1 x86_64 GN Description: Downloaded the 9.2.4 source and compiled it. There is NO pg_upgrade script in the 9.2/bin directory. I thought that I have to run this script to upgrade my database from 9.1 to 9.2. Can I run the 9.1 version of pg_upgrade? Please advise. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #8325: Missing script II
The following bug has been logged on the website: Bug reference: 8325 Logged by: Robert Stone Email address: floripa...@gmail.com PostgreSQL version: 9.2.4 Operating system: Linux roblaptop 3.9-1-amd64 #1 SMP Debian 3.9.8-1 Description: Since my previous report discovered pg_upgrade sitting in a directory named contrib. Tried to compile it but the following errors occurred:- root@roblaptop:/home/postgres/v9.2/postgresql-9.2.4/contrib/pg_upgrade# make gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -DFRONTEND -DDLSUFFIX=\.so\ -I. -I../../src/interfaces/libpq -I. -I. -I../../src/include -D_GNU_SOURCE -c -o check.o check.c In file included from ../../src/include/postgres.h:48:0, from check.c:10: ../../src/include/utils/elog.h:69:28: fatal error: utils/errcodes.h: No such file or directory compilation terminated. make: *** [check.o] Error 1 root@roblaptop:/home/postgres/v9.2/postgresql-9.2.4/contrib/pg_upgrade# BTW, with Debian GNU Make is called make and not gmake. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #8324: Missing script
On Tue, Jul 23, 2013 at 2:02 PM, floripa...@gmail.com wrote: The following bug has been logged on the website: Bug reference: 8324 Logged by: Robert Stone Email address: floripa...@gmail.com PostgreSQL version: 9.2.4 Operating system: Debian 3.9-1-amd64 #1 SMP Debian 3.9.8-1 x86_64 GN Description: Downloaded the 9.2.4 source and compiled it. There is NO pg_upgrade script in the 9.2/bin directory. I thought that I have to run this script to upgrade my database from 9.1 to 9.2. Can I run the 9.1 version of pg_upgrade? Please advise. pg_upgrade is a contrib module, so you will find it in contrib/pg_upgrade. Note that when performing an upgrade you will also need to install the extension called pg_upgrade_support in the server to-be-upgraded. It is located in contrib/pg_upgrade_support. -- Michael
Re: [BUGS] BUG #8325: Missing script II
On Tue, Jul 23, 2013 at 2:24 PM, floripa...@gmail.com wrote: The following bug has been logged on the website: Bug reference: 8325 Logged by: Robert Stone Email address: floripa...@gmail.com PostgreSQL version: 9.2.4 Operating system: Linux roblaptop 3.9-1-amd64 #1 SMP Debian 3.9.8-1 Description: Since my previous report discovered pg_upgrade sitting in a directory named contrib. Tried to compile it but the following errors occurred:- root@roblaptop:/home/postgres/v9.2/postgresql-9.2.4/contrib/pg_upgrade# make gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -DFRONTEND -DDLSUFFIX=\.so\ -I. -I../../src/interfaces/libpq -I. -I. -I../../src/include -D_GNU_SOURCE -c -o check.o check.c In file included from ../../src/include/postgres.h:48:0, from check.c:10: ../../src/include/utils/elog.h:69:28: fatal error: utils/errcodes.h: No such file or directory compilation terminated. make: *** [check.o] Error 1 root@roblaptop:/home/postgres/v9.2/postgresql-9.2.4/contrib/pg_upgrade# You should compile first the main code tree in src/. This will help ;) -- Michael
Re: [BUGS] BUG #8274: Wildly insane boolean selectivity estimates
and...@tao11.riddles.org.uk writes: The handling of freq_null for estimating IS NOT TRUE/FALSE for boolean columns which are all null or almost all null (enough that analyze doesn't find any non-null values to put in MCV) is completely off in the weeds. Doh, definitely a bit of brain fade there :-( Suggested fix at: https://gist.github.com/RhodiumToad/5901567 Seems reasonable, will fix. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs