Hi Everyone trying to set up prefect on my local machine for

Question

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

Kevin Kho · Answer

Hi Nicholas could you move the traceback to the tread to keep the main channel cleaner when you get a chance

Kevin Kho · Answer

How did you spin this up `prefect server start`

Nicholas Kan · Answer

```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```

Nicholas Kan · Answer

< Kevin Kho> used docker compose up with the following yaml

Kevin Kho · Answer

Is this just the output of `prefect server config` or did you make changes

Nicholas Kan · Answer

it s just the output

Kevin Kho · Answer

Is it the same behavior when you do `prefect server start`

Kevin Kho · Answer

Is it actually failing though The logs can just be noisy sometimes but it can work

Nicholas Kan · Answer

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

Nicholas Kan · Answer

also tried to connect separately to db using pgadmin to verify and it is not accepting

Nicholas Kan · Answer

able to see the schema but can t query

Kevin Kho · Answer

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

Nicholas Kan · Answer

Just finished building with prefect server start and it is working now thank you for your assistance

Kevin Kho · Answer

I don t know why that would be different man shrugging