[ADMIN] PG_UPRADE issue
so when following the instructions of pg_upgrade " If your installation directory is not version-specific, e.g. /usr/local/pgsql, it is necessary to move the current PostgreSQL install directory so it does not interfere with the new PostgreSQL installation. Once the current PostgreSQL server is shut down, it is safe to rename the PostgreSQL installation directory; assuming the old directory is /usr/local/pgsql, you can do: mv /usr/local/pgsql /usr/local/pgsql.old to rename the directory." i was just curious and try to see if the current postgres (which now is in the pgsql.old directory instead) is still working so i did a /usr/loca/pgsql.old/bin/pg_ctl -D /usr/local/pgsql.old/data start and it showed LOG: database system is ready to accept connections LOG: autovacuum launcher started but did not go further than that then i tried to /usr/local/pgsql8/bin/psql to connect to the server and it says psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? so am i doing something wrong with the "mv" command that i'm missing?? (beacuase it seems that everything screwed since i rename the complete folder) -- View this message in context: http://postgresql.1045698.n5.nabble.com/PG-UPRADE-issue-tp5759891.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[ADMIN] Re: PG_UPGRADE issues "this utility can only upgrade to postgresql version 9.2."
so i tried to do a /usr/local/pgsql.old/bin/postgres -D /usr/local/pgsql.old/data start LOG: database system was shut down at 2013-06-19 08:10:51 CST LOG: database system is ready to accept connections LOG: autovacuum launcher started it got stuck there ^^ the i tried to /usr/local/pgsql.old/bin/psql -p 5432 and it turns that psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? so basically i just moved the whole pgsql8.3.2 that i had to a new folder which is pgsql.old with sudo mv etc,etc but i can not turn on the 8.3 server, i did try to start the new one (9.2.4) and yes i can. any idea? -- View this message in context: http://postgresql.1045698.n5.nabble.com/PG-UPGRADE-issues-this-utility-can-only-upgrade-to-postgresql-version-9-2-tp5759509p5759873.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[ADMIN] Re: PG_UPGRADE issues "this utility can only upgrade to postgresql version 9.2."
so after trying i advance just a little bit but when running pg_upgrade for a check or upgrade i get: pg_control values: First log file ID after reset:0 First log file segment after reset: 2 pg_control version number:922 Catalog version number: 201204301 Database system identifier: 5890882831378718649 Latest checkpoint's TimeLineID: 1 Latest checkpoint's full_page_writes: on Latest checkpoint's NextXID: 0/726 Latest checkpoint's NextOID: 12047 Latest checkpoint's NextMultiXactId: 1 Latest checkpoint's NextMultiOffset: 0 Latest checkpoint's oldestXID:716 Latest checkpoint's oldestXID's DB: 1 Latest checkpoint's oldestActiveXID: 0 Maximum data alignment: 4 Database block size: 8192 Blocks per segment of large relation: 131072 WAL block size: 8192 Bytes per WAL segment:16777216 Maximum length of identifiers:64 Maximum columns in an index: 32 Maximum size of a TOAST chunk:2000 Date/time type storage: floating-point numbers Float4 argument passing: by value Float8 argument passing: by reference "/usr/local/pgsql.old/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/usr/local/pgsql.old/data/" -o "-p 5432 -c autovacuum=off -c autovacuum_freeze_max_age=20 -c listen_addresses='' -c unix_socket_permissions=0700" start >> "pg_upgrade_server.log" 2>&1 *failure* There were problems executing ""/usr/local/pgsql.old/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/usr/local/pgsql.old/data/" -o "-p 5432 -c autovacuum=off -c autovacuum_freeze_max_age=20 -c listen_addresses='' -c unix_socket_permissions=0700" start >> "pg_upgrade_server.log" 2>&1" Consult the last few lines of "pg_upgrade_server.log" for the probable cause of the failure. pg_ctl failed to start the old server, or connection failed Failure, exiting when going to the log file: pg_upgrade run on Tue Jun 18 11:58:08 2013 - command: "/usr/local/pgsql.old/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/usr/local/pgsql.old/data/" -o "-p 5432 -c autovacuum=off -c $ waiting for server to startLOG: database system was shut down at 2013-06-18 11:30:47 CST LOG: database system is ready to accept connections ...could not start server -- View this message in context: http://postgresql.1045698.n5.nabble.com/PG-UPGRADE-issues-this-utility-can-only-upgrade-to-postgresql-version-9-2-tp5759509p5759711.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[ADMIN] PG_UPGRADE issues "this utility can only upgrade to postgresql version 9.2."
so i'm running ubuntu 12.04 with pg8.3.2 installed on it, i want to upgrade to 9.2.4 using the pg_upgrade. i've followed this steps: 1) download postgres9.2.4 2)configure it and compile it 3) make and install the pg_upgrade and pg_upgrade_support utilities from the pg9.2.4 contrib folder 4) init the pg9.2.4 cluster with: initdb -D /usr/local/pgsql9.2.4/data 5) try to check for compatibilities between the 2 clusters and getting the following error while logged into postgres user account. command>> /usr/local/pgsql9.2.0/bin/./pg_upgrade -b /usr/local/pgsql/bin/ -B /usr/local/pgsql9.2.0/bin/ -c -d /usr/local/pgsql/data/ -D /usr/local/pgsql9.2.0/data/ error>> cannot write to log file pg_upgrade_internal.log Failure, exiting 6) so i decided to move on and just do an upgrade without the -c (check for compatibilities) : 6.1) stop both servers 6.2) run the same command without the -c to upgrade and getting : " this utility can only upgrade to postgresql version 9.2" please enlighten me or give me any advice. -- View this message in context: http://postgresql.1045698.n5.nabble.com/PG-UPGRADE-issues-this-utility-can-only-upgrade-to-postgresql-version-9-2-tp5759509.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin