Today I wanted to start postgres and I realized that I have to upgrade it.. so I followed what its said on the wiki
when I do
sudo -u postgres pg_upgrade \
-b /opt/pgsql-9.1/bin/ \
-B /usr/bin/ \
-d /var/lib/postgres/data-9.1 \
I get this error
cannot write to log file pg_upgrade_internal.log
but then if I do
su - postgres -c 'pg_upgrade -d /var/lib/postgres/data-9.1/ -D /var/lib/postgres/data/ -b /opt/pgsql-9.1/bin/ -B /usr/bin/'
I get an LC_COLLATE error that says that old and new values are differents
Is there something I can do?
Thanks in advance
Last edited by slevin123 (2012-09-30 19:44:20)
When you initialize the new database as the postgres user:
initdb --lc-collate <insert 9.1 collate here> -D /var/lib/postgres/data
how can i get the collate from 9.1?
As postgres user:
/opt/pgsql-9.1/bin/postmaster -D /var/lib/postgres/data_old/
with another terminal, as postgres user, open a pgsql console and then
I had a similar error, changing to a directory that postgres has r/w in, let me run the upgrade command without the "cannot write to log file pg_upgrade_internal.log" error..