105 reputation
3
bio website
location
age
visits member for 3 years
seen Nov 28 at 8:00

Nov
4
comment How to upgrade from Postgres 9.1 to 9.3 allowing read access during upgrade
pg_dumpall is running in late evening, it can assumed that data is not changed by users in this time. Destination cluster in 5433 port has new database with different name containing data. Will this method keep this new database in destination cluster, will it add only existing databases from source cluster ?
Nov
2
comment How to upgrade from Postgres 9.1 to 9.3 allowing read access during upgrade
I found that pg_dumpall -p 5432 | psql -d postgres -p 5433 works. It takes less than 30 minutes , 12 databases, total compressed backup files files size is 10 GB, is this possible or is there something missing? I have already create one database with different name in new cluster, will this keep new database? Is it OK to use this method since it doesn't require to take database offline?
Nov
1
asked How to upgrade from Postgres 9.1 to 9.3 allowing read access during upgrade
Nov
1
accepted How to install Postgres 9.3 parallel in Debian Squeeze
Oct
27
asked How to install Postgres 9.3 parallel in Debian Squeeze
Jul
16
awarded  Scholar
Jul
16
accepted How to fix Bad request response from IIS express 7 for one request from internet
May
27
awarded  Popular Question
Nov
24
revised How to fix Bad request response from IIS express 7 for one request from internet
deleted 1 characters in body
Nov
24
revised How to fix Bad request response from IIS express 7 for one request from internet
deleted 539 characters in body
Nov
24
awarded  Editor
Nov
24
revised How to fix Bad request response from IIS express 7 for one request from internet
added 66 characters in body
Nov
24
asked How to fix Bad request response from IIS express 7 for one request from internet