Comments (5)
I am getting the same issue with 10-to-13
while upgrading a Mattermost setup.
could not open version file "/var/lib/postgresql/10/data/PG_VERSION": No such file or directory
from docker-postgres-upgrade.
The directory /var/lib/postgresql/10/data/
is empty inside the container. Although so is /var/lib/postgresql/13/data/
It seems like the postgres cluster has not been initialised? My database is small enough that I think a pg_restore is my best option.
from docker-postgres-upgrade.
P.s. Also fails with...
$ docker run --rm \
-v $PWD/data/postgres:/var/lib/postgresql/11/data \
-v $PWD/data/12/postgres:/var/lib/postgresql/12/data \
tianon/postgres-upgrade:11-to-12
from docker-postgres-upgrade.
@davidbartonau what base does your container image use (i.e. debian, alpine, etc?).
The other thread mentioned that permission issues as a possible root cause, but a different directory stucture could be to blame also(?)..
from docker-postgres-upgrade.
Re-arranging the bind volume directory structure, so that it matched the first example in the README, worked for me.
i.e. ...
$ find $DIR -mindepth 2 -maxdepth 2
$DIR/11/data
$DIR/12/data
so I could run the upgrade with:
docker run --rm \
-v "$DIR:/var/lib/postgresql" \
"tianon/postgres-upgrade:11-to-12" \
--link
(Replacing $DIR
as appropriate in both snippets of course).
Don't know if there is an issue with the implementation when using the method I used above (mounting two seperate bind points) or I was just using it wrong. Either way, I will close this.
from docker-postgres-upgrade.
Related Issues (20)
- wont start - fails to find socket of source postgres HOT 2
- Upgrading from 14 to 15 failing with `"/var/lib/postgresql/14/data/PG_VERSION": No such file or directory` HOT 5
- Docker image should run pg_upgrade's generated update_extension.sql file when present HOT 2
- support custom username for example "-U my_username" when connecting HOT 6
- Break database made with Alpine-based container HOT 6
- PostgreSQL 16 HOT 3
- TO VERSION 16 HOT 1
- 11 to VERSION 16 REQUEST HOT 1
- Cannot create directory: File exists. HOT 1
- Docker image for ARM64 (aarch64 / Arm Ampere) architecture HOT 1
- "could not create any Unix-domain sockets" HOT 2
- Add ARM Arch Support HOT 1
- Does the operation of `exec gosu postgres "$BASH_SOURCE" "$@"` overlap with `exec "$@"`? HOT 4
- 13-to-15: FATAL: role "postgres" does not exist HOT 2
- How to support PostgreSQL database upgrade with multiple tablespaces HOT 1
- Collation warning
- script to review when username is not postgres - permission issue
- Is there a reason to remove upgrade ability for older versions? HOT 2
- chown fails
- Support for linux/arm64/v8 HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from docker-postgres-upgrade.