Installing postgresql-9.4 on Debian 9/Jessie
Clash Royale CLAN TAG#URR8PPP
up vote
0
down vote
favorite
Yesterday I dist-upgraded a Debian 8 machine to 9.3. In my haste, I forgot to consider the postgresql database. Postgesql was upgraded from 9.4 to 9.6, and 9.4 was removed with the other obsolete packages.
Now I'm trying to figure out how to recover/upgrade my database and get it running on 9.6.
There appear to be two upgrade paths: pg_dumpall and pg_upgrade but both require the the previous version of postgresql be installed, which it isn't. Furthermore, version 9.4 appears to only be available in the repos for jessie and sid.
Is it safe/recommended to attempt installing the jessie release of postgresql-9.4? Are there other upgrade paths that don't require the old binary to be present?
debian postgresql
asked Jan 14 at 17:09
ctag
263
 |Â
show 1 more comment
up vote
0
down vote
favorite
Yesterday I dist-upgraded a Debian 8 machine to 9.3. In my haste, I forgot to consider the postgresql database. Postgesql was upgraded from 9.4 to 9.6, and 9.4 was removed with the other obsolete packages.
Now I'm trying to figure out how to recover/upgrade my database and get it running on 9.6.
There appear to be two upgrade paths: pg_dumpall and pg_upgrade but both require the the previous version of postgresql be installed, which it isn't. Furthermore, version 9.4 appears to only be available in the repos for jessie and sid.
Is it safe/recommended to attempt installing the jessie release of postgresql-9.4? Are there other upgrade paths that don't require the old binary to be present?
debian postgresql
asked Jan 14 at 17:09
ctag
263
have you backup dumps?
– Rui F Ribeiro
Jan 14 at 17:39
@RuiFRibeiro None that are recent enough for me to want to use them.
– ctag
Jan 14 at 17:41
The prospects to recover from a disaster like you describe without a dump are not exactly brilliant. Backup well the directory before attempting to install anything.
– Rui F Ribeiro
Jan 14 at 17:43
2
is the data file in the normal location, debian has a nice upgrade script called 'pg_upgradecluster' Here is a gist that may help. gist.github.com/dmitrykustov/27c673ec4f7abd716912e4c830910019
– gdahlm
Jan 14 at 18:51
2
@gdahlm Thank you for the suggestion! I was able to install the old package, and use the directions from that gist to upgrade the database. If you list this as an answer, I'll mark it solved.
– ctag
Jan 14 at 19:18
 |Â
show 1 more comment
up vote
0
down vote
favorite
up vote
0
down vote
favorite
Yesterday I dist-upgraded a Debian 8 machine to 9.3. In my haste, I forgot to consider the postgresql database. Postgesql was upgraded from 9.4 to 9.6, and 9.4 was removed with the other obsolete packages.
Now I'm trying to figure out how to recover/upgrade my database and get it running on 9.6.
There appear to be two upgrade paths: pg_dumpall and pg_upgrade but both require the the previous version of postgresql be installed, which it isn't. Furthermore, version 9.4 appears to only be available in the repos for jessie and sid.
Is it safe/recommended to attempt installing the jessie release of postgresql-9.4? Are there other upgrade paths that don't require the old binary to be present?
debian postgresql
asked Jan 14 at 17:09
ctag
263
Yesterday I dist-upgraded a Debian 8 machine to 9.3. In my haste, I forgot to consider the postgresql database. Postgesql was upgraded from 9.4 to 9.6, and 9.4 was removed with the other obsolete packages.
Now I'm trying to figure out how to recover/upgrade my database and get it running on 9.6.
There appear to be two upgrade paths: pg_dumpall and pg_upgrade but both require the the previous version of postgresql be installed, which it isn't. Furthermore, version 9.4 appears to only be available in the repos for jessie and sid.
Is it safe/recommended to attempt installing the jessie release of postgresql-9.4? Are there other upgrade paths that don't require the old binary to be present?
debian postgresql
asked Jan 14 at 17:09
ctag
263
asked Jan 14 at 17:09
ctag
263
asked Jan 14 at 17:09
ctag
263
asked Jan 14 at 17:09
ctag
263
263
have you backup dumps?
– Rui F Ribeiro
Jan 14 at 17:39
@RuiFRibeiro None that are recent enough for me to want to use them.
– ctag
Jan 14 at 17:41
The prospects to recover from a disaster like you describe without a dump are not exactly brilliant. Backup well the directory before attempting to install anything.
– Rui F Ribeiro
Jan 14 at 17:43
2
is the data file in the normal location, debian has a nice upgrade script called 'pg_upgradecluster' Here is a gist that may help. gist.github.com/dmitrykustov/27c673ec4f7abd716912e4c830910019
– gdahlm
Jan 14 at 18:51
2
@gdahlm Thank you for the suggestion! I was able to install the old package, and use the directions from that gist to upgrade the database. If you list this as an answer, I'll mark it solved.
– ctag
Jan 14 at 19:18
 |Â
show 1 more comment
have you backup dumps?
– Rui F Ribeiro
Jan 14 at 17:39
@RuiFRibeiro None that are recent enough for me to want to use them.
– ctag
Jan 14 at 17:41
The prospects to recover from a disaster like you describe without a dump are not exactly brilliant. Backup well the directory before attempting to install anything.
– Rui F Ribeiro
Jan 14 at 17:43
2
is the data file in the normal location, debian has a nice upgrade script called 'pg_upgradecluster' Here is a gist that may help. gist.github.com/dmitrykustov/27c673ec4f7abd716912e4c830910019
– gdahlm
Jan 14 at 18:51
2
@gdahlm Thank you for the suggestion! I was able to install the old package, and use the directions from that gist to upgrade the database. If you list this as an answer, I'll mark it solved.
– ctag
Jan 14 at 19:18
have you backup dumps?
– Rui F Ribeiro
Jan 14 at 17:39
have you backup dumps?
– Rui F Ribeiro
Jan 14 at 17:39
@RuiFRibeiro None that are recent enough for me to want to use them.
– ctag
Jan 14 at 17:41
@RuiFRibeiro None that are recent enough for me to want to use them.
– ctag
Jan 14 at 17:41
The prospects to recover from a disaster like you describe without a dump are not exactly brilliant. Backup well the directory before attempting to install anything.
– Rui F Ribeiro
Jan 14 at 17:43
The prospects to recover from a disaster like you describe without a dump are not exactly brilliant. Backup well the directory before attempting to install anything.
– Rui F Ribeiro
Jan 14 at 17:43
2
2
is the data file in the normal location, debian has a nice upgrade script called 'pg_upgradecluster' Here is a gist that may help. gist.github.com/dmitrykustov/27c673ec4f7abd716912e4c830910019
– gdahlm
Jan 14 at 18:51
is the data file in the normal location, debian has a nice upgrade script called 'pg_upgradecluster' Here is a gist that may help. gist.github.com/dmitrykustov/27c673ec4f7abd716912e4c830910019
– gdahlm
Jan 14 at 18:51
2
2
@gdahlm Thank you for the suggestion! I was able to install the old package, and use the directions from that gist to upgrade the database. If you list this as an answer, I'll mark it solved.
– ctag
Jan 14 at 19:18
@gdahlm Thank you for the suggestion! I was able to install the old package, and use the directions from that gist to upgrade the database. If you list this as an answer, I'll mark it solved.
– ctag
Jan 14 at 19:18
 |Â
show 1 more comment
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f417064%2finstalling-postgresql-9-4-on-debian-9-jessie%23new-answer', 'question_page');
);
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
have you backup dumps?
– Rui F Ribeiro
Jan 14 at 17:39
@RuiFRibeiro None that are recent enough for me to want to use them.
– ctag
Jan 14 at 17:41
The prospects to recover from a disaster like you describe without a dump are not exactly brilliant. Backup well the directory before attempting to install anything.
– Rui F Ribeiro
Jan 14 at 17:43
2
is the data file in the normal location, debian has a nice upgrade script called 'pg_upgradecluster' Here is a gist that may help. gist.github.com/dmitrykustov/27c673ec4f7abd716912e4c830910019
– gdahlm
Jan 14 at 18:51
2
@gdahlm Thank you for the suggestion! I was able to install the old package, and use the directions from that gist to upgrade the database. If you list this as an answer, I'll mark it solved.
– ctag
Jan 14 at 19:18