[GENERAL] Moving Postgresql 9.1 instance from FreeBSD 9.0 machine to FreeBSD 10.2
Hi I have a Postgresql 9.1 instance running on FreeBSD 9.0 (64 bit). The machine is now running out of space and no extra hard disk can be added to the machine. I am planning to move the instance to another machine which is running FreeBSD 10.2 (64 bit) with the same Postgresql version. One idea is to take a dump and transfer the data, which is my fallback plan. The other is to simply copy over the data directory since the postgresql version is same (64 bit OS with PG 9.1) on both machine. This will reduce a lot of down time as the data is around 1 TB . Old Machine: FreeBSD 9.0 (64 bit) with Postgresql 9.1 (UFS file system) New Machine: FreeBSD 10.2 (64 bit) with Postgresql 9.1 (UFS file system) The directory structure and others hardware would remain the same in both machine, apart from a increased capacity of hard disk and RAM in the new machine. Just wondering if anybody has already done such a move or has any suggestions if I should or should not go the directory copy route? Thanks Amitabh
Re: [GENERAL] Blocksize Config Make Check Failures
GMail writes: > I'm attempting to get a little bit more disk performance out of a data > warehouse like PG 9.5 RC1 instance I have that is running on ZFS > (recordsize=128K). When trying to make PG 9.5RC1 with --blocksize > 8 > four of the make check tests are reported as failing. Yeah, that's unsurprising. You can also get some discrepancies from the expected output if you, eg, run with nondefault planner parameters. Thanks for pointing this out though, because I notice that somebody stuck a bunch of plain EXPLAIN commands into rowsecurity.sql, in clear violation of the project policy about using COSTS OFF in regression explain commands. That's causing some though not all of your diffs, and might lead to pseudo-failures in other environments that we do consider supported. I'll go fix that ... regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Blocksize Config Make Check Failures
I'm attempting to get a little bit more disk performance out of a data warehouse like PG 9.5 RC1 instance I have that is running on ZFS (recordsize=128K). When trying to make PG 9.5RC1 with --blocksize > 8 four of the make check tests are reported as failing. I'm curious as to if this is a problem with the checks or if the errors would cause problems in usage. None of the make check errors caused the server to terminate or have serious issues but I just wanted to check if anyone else had concerns. You can see for yourself the failures with this command: git checkout tags/REL9_5_RC1; make clean; ./configure --with-blocksize=16; make; make check For example the select_views regression.diff shows that the explain plan changed which doesn't seem overly concerning. The tablesample failure though is more interesting. I'm not entirely sure that tablesample is working correctly though in terms of the count of data it should be returning but at least it is returning some data. See attached for the regression.diffs. Mike blocksize_regression.diffs Description: Binary data -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general