https://prefect.io logo
Join Slack
Powered by
Hi Everyone, trying to set up prefect on my local ...
# ask-community
n
Hi Everyone, trying to set up prefect on my local machine for the first time, I keep getting this error when the postgres docker container is building. I am just using the docker-compose from docker hub. Has anyone encountered this before or knows how to workaround? Error message in the replies
k
Hi Nicholas, could you move the traceback to the tread to keep the main channel cleaner when you get a chance?
How did you spin this up? 
prefect server start
?
n
Copy code
docker-compose-server-postgres-1  | The files belonging to this database system will be owned by user "postgres".
docker-compose-server-postgres-1  | This user must also own the server process.
docker-compose-server-postgres-1  |
docker-compose-server-postgres-1  | The database cluster will be initialized with locale "en_US.utf8".
docker-compose-server-postgres-1  | The default database encoding has accordingly been set to "UTF8".
docker-compose-server-postgres-1  | The default text search configuration will be set to "english".
docker-compose-server-postgres-1  |
docker-compose-server-postgres-1  | Data page checksums are disabled.
docker-compose-server-postgres-1  |
docker-compose-server-postgres-1  | fixing permissions on existing directory /var/lib/postgresql/data ... ok
docker-compose-server-postgres-1  | creating subdirectories ... ok
docker-compose-server-postgres-1  | selecting default max_connections ... 100
docker-compose-server-postgres-1  | selecting default shared_buffers ... 128MB
docker-compose-server-postgres-1  | selecting default timezone ... Etc/UTC
docker-compose-server-postgres-1  | selecting dynamic shared memory implementation ... posix
docker-compose-server-postgres-1  | creating configuration files ... ok
docker-compose-server-postgres-1  | running bootstrap script ... ok
docker-compose-server-postgres-1  | performing post-bootstrap initialization ... ok
docker-compose-server-postgres-1  | syncing data to disk ...
docker-compose-server-postgres-1  | WARNING: enabling "trust" authentication for local connections
docker-compose-server-postgres-1  | You can change this by editing pg_hba.conf or using the option -A, or
docker-compose-server-postgres-1  | --auth-local and --auth-host, the next time you run initdb.
docker-compose-server-postgres-1  | ok
docker-compose-server-postgres-1  |
docker-compose-server-postgres-1  | Success. You can now start the database server using:
docker-compose-server-postgres-1  |
docker-compose-server-postgres-1  |     pg_ctl -D /var/lib/postgresql/data -l logfile start
docker-compose-server-postgres-1  |
docker-compose-server-postgres-1  | waiting for server to start....2022-06-23 16:59:12.769 UTC [48] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
docker-compose-server-postgres-1  | 2022-06-23 16:59:12.801 UTC [49] LOG:  database system was shut down at 2022-06-23 16:59:12 UTC
docker-compose-server-postgres-1  | 2022-06-23 16:59:12.821 UTC [48] LOG:  database system is ready to accept connections
docker-compose-server-postgres-1  |  done
docker-compose-server-postgres-1  | server started
docker-compose-server-postgres-1  | CREATE DATABASE
docker-compose-server-postgres-1  |
docker-compose-server-postgres-1  |
docker-compose-server-postgres-1  | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
docker-compose-server-postgres-1  |
docker-compose-server-postgres-1  | waiting for server to shut down...2022-06-23 16:59:13.292 UTC [48] LOG:  received fast shutdown request
docker-compose-server-postgres-1  | .2022-06-23 16:59:13.296 UTC [48] LOG:  aborting any active transactions
docker-compose-server-postgres-1  | 2022-06-23 16:59:13.299 UTC [48] LOG:  background worker "logical replication launcher" (PID 55) exited with exit code 1
docker-compose-server-postgres-1  | 2022-06-23 16:59:13.299 UTC [50] LOG:  shutting down
docker-compose-server-postgres-1  | 2022-06-23 16:59:13.332 UTC [48] LOG:  database system is shut down
docker-compose-server-postgres-1  |  done
docker-compose-server-postgres-1  | server stopped
docker-compose-server-postgres-1  |
docker-compose-server-postgres-1  | PostgreSQL init process complete; ready for start up.
docker-compose-server-postgres-1  |
docker-compose-server-postgres-1  | 2022-06-23 16:59:13.412 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432docker-compose-server-postgres-1  | 2022-06-23 16:59:13.412 UTC [1] LOG:  listening on IPv6 address "::", port 5432
docker-compose-server-postgres-1  | 2022-06-23 16:59:13.420 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
docker-compose-server-postgres-1  | 2022-06-23 16:59:13.440 UTC [76] LOG:  database system was shut down at 2022-06-23 16:59:13 UTC
docker-compose-server-postgres-1  | 2022-06-23 16:59:13.448 UTC [1] LOG:  database system is ready to accept connections
@Kevin Kho used docker compose up with the following yaml
docker-compose.yaml
k
Is this just the output of 
prefect server config
or did you make changes?
n
it's just the output
k
Is it the same behavior when you do 
prefect server start
?
Is it actually failing though? The logs can just be noisy sometimes but it can work
n
Everything else is working fine, the graphql and UI, but I am unable to add a project, I assume because the db is shutting down and not accepting connection
also tried to connect separately to db using pgadmin to verify and it is not accepting
able to see the schema but can't query
k
I personally haven’t seen this before and can’t immediately see a reason why it’s failing. Are you open to trying Cloud by chance? The free tier gives 10k free task runs a month, which is more than enough to get started with
n
Just finished building with prefect server start and it is working now, thank you for your assistance!
k
I don’t know why that would be different 🤷‍♂️
6 Views
Open in Slack
PreviousNext
Powered by