Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save alisonamerico/6a1ee143b05761db08166b524d62d5a2 to your computer and use it in GitHub Desktop.
Save alisonamerico/6a1ee143b05761db08166b524d62d5a2 to your computer and use it in GitHub Desktop.
snowman on  80 [!?] is 📦 v0.1.0 via 🐍 v3.8.3 took 10m44s
❯ docker-compose up
Creating touristspots_database ... done
Creating snowman_web_1 ... done
Attaching to touristspots_database, snowman_web_1
touristspots_database | The files belonging to this database system will be owned by user "postgres".
touristspots_database | This user must also own the server process.
touristspots_database |
touristspots_database | The database cluster will be initialized with locale "C.UTF-8".
touristspots_database | The default database encoding has accordingly been set to "UTF8".
touristspots_database | The default text search configuration will be set to "english".
touristspots_database |
touristspots_database | Data page checksums are disabled.
touristspots_database |
touristspots_database | fixing permissions on existing directory /var/lib/postgresql/data ... ok
touristspots_database | creating subdirectories ... ok
touristspots_database | selecting dynamic shared memory implementation ... posix
touristspots_database | selecting default max_connections ... 100
touristspots_database | selecting default shared_buffers ... 128MB
touristspots_database | selecting default time zone ... Etc/UTC
touristspots_database | creating configuration files ... ok
touristspots_database | running bootstrap script ... ok
touristspots_database | performing post-bootstrap initialization ... ok
touristspots_database | syncing data to disk ... ok
touristspots_database |
touristspots_database |
touristspots_database | Success. You can now start the database server using:
touristspots_database |
touristspots_database | pg_ctl -D /var/lib/postgresql/data -l logfile start
touristspots_database |
touristspots_database | initdb: warning: enabling "trust" authentication for local connections
touristspots_database | You can change this by editing pg_hba.conf or using the option -A, or
touristspots_database | --auth-local and --auth-host, the next time you run initdb.
touristspots_database | waiting for server to start....2020-07-24 13:03:10.786 UTC [46] LOG: starting PostgreSQL 12.3 (Debian 12.3-1.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
touristspots_database | 2020-07-24 13:03:10.819 UTC [46] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
touristspots_database | 2020-07-24 13:03:10.966 UTC [47] LOG: database system was shut down at 2020-07-24 13:03:08 UTC
touristspots_database | 2020-07-24 13:03:11.006 UTC [46] LOG: database system is ready to accept connections
touristspots_database | done
touristspots_database | server started
touristspots_database | CREATE DATABASE
touristspots_database |
touristspots_database |
touristspots_database | /usr/local/bin/docker-entrypoint.sh: sourcing /docker-entrypoint-initdb.d/10_postgis.sh
touristspots_database | CREATE DATABASE
touristspots_database | Loading PostGIS extensions into template_postgis
touristspots_database | CREATE EXTENSION
touristspots_database | CREATE EXTENSION
touristspots_database | CREATE EXTENSION
touristspots_database | CREATE EXTENSION
touristspots_database | Loading PostGIS extensions into touristspots
web_1 | Watching for file changes with StatReloader
web_1 | Performing system checks...
web_1 |
web_1 | System check identified no issues (0 silenced).
web_1 | Exception in thread django-main-thread:
web_1 | Traceback (most recent call last):
web_1 | File "/usr/local/lib/python3.8/site-packages/django/db/backends/base/base.py", line 220, in ensure_connection
web_1 | self.connect()
web_1 | File "/usr/local/lib/python3.8/site-packages/django/utils/asyncio.py", line 26, in inner
web_1 | return func(*args, **kwargs)
web_1 | File "/usr/local/lib/python3.8/site-packages/django/db/backends/base/base.py", line 197, in connect
web_1 | self.connection = self.get_new_connection(conn_params)
web_1 | File "/usr/local/lib/python3.8/site-packages/django/utils/asyncio.py", line 26, in inner
web_1 | return func(*args, **kwargs)
web_1 | File "/usr/local/lib/python3.8/site-packages/django/db/backends/postgresql/base.py", line 185, in get_new_connection
web_1 | connection = Database.connect(**conn_params)
web_1 | File "/usr/local/lib/python3.8/site-packages/psycopg2/__init__.py", line 127, in connect
web_1 | conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
web_1 | psycopg2.OperationalError: could not connect to server: Connection refused
web_1 | Is the server running on host "localhost" (127.0.0.1) and accepting
web_1 | TCP/IP connections on port 5433?
web_1 | could not connect to server: Cannot assign requested address
web_1 | Is the server running on host "localhost" (::1) and accepting
web_1 | TCP/IP connections on port 5433?
web_1 |
web_1 |
web_1 | The above exception was the direct cause of the following exception:
web_1 |
web_1 | Traceback (most recent call last):
web_1 | File "/usr/local/lib/python3.8/threading.py", line 932, in _bootstrap_inner
web_1 | self.run()
web_1 | File "/usr/local/lib/python3.8/threading.py", line 870, in run
web_1 | self._target(*self._args, **self._kwargs)
web_1 | File "/usr/local/lib/python3.8/site-packages/django/utils/autoreload.py", line 53, in wrapper
web_1 | fn(*args, **kwargs)
web_1 | File "/usr/local/lib/python3.8/site-packages/django/core/management/commands/runserver.py", line 120, in inner_run
web_1 | self.check_migrations()
web_1 | File "/usr/local/lib/python3.8/site-packages/django/core/management/base.py", line 458, in check_migrations
web_1 | executor = MigrationExecutor(connections[DEFAULT_DB_ALIAS])
web_1 | File "/usr/local/lib/python3.8/site-packages/django/db/migrations/executor.py", line 18, in __init__
web_1 | self.loader = MigrationLoader(self.connection)
web_1 | File "/usr/local/lib/python3.8/site-packages/django/db/migrations/loader.py", line 49, in __init__
web_1 | self.build_graph()
web_1 | File "/usr/local/lib/python3.8/site-packages/django/db/migrations/loader.py", line 212, in build_graph
web_1 | self.applied_migrations = recorder.applied_migrations()
web_1 | File "/usr/local/lib/python3.8/site-packages/django/db/migrations/recorder.py", line 76, in applied_migrations
web_1 | if self.has_table():
web_1 | File "/usr/local/lib/python3.8/site-packages/django/db/migrations/recorder.py", line 56, in has_table
web_1 | return self.Migration._meta.db_table in self.connection.introspection.table_names(self.connection.cursor())
web_1 | File "/usr/local/lib/python3.8/site-packages/django/utils/asyncio.py", line 26, in inner
web_1 | return func(*args, **kwargs)
web_1 | File "/usr/local/lib/python3.8/site-packages/django/db/backends/base/base.py", line 260, in cursor
web_1 | return self._cursor()
web_1 | File "/usr/local/lib/python3.8/site-packages/django/db/backends/base/base.py", line 236, in _cursor
web_1 | self.ensure_connection()
web_1 | File "/usr/local/lib/python3.8/site-packages/django/utils/asyncio.py", line 26, in inner
web_1 | return func(*args, **kwargs)
web_1 | File "/usr/local/lib/python3.8/site-packages/django/db/backends/base/base.py", line 220, in ensure_connection
web_1 | self.connect()
web_1 | File "/usr/local/lib/python3.8/site-packages/django/db/utils.py", line 90, in __exit__
web_1 | raise dj_exc_value.with_traceback(traceback) from exc_value
web_1 | File "/usr/local/lib/python3.8/site-packages/django/db/backends/base/base.py", line 220, in ensure_connection
web_1 | self.connect()
web_1 | File "/usr/local/lib/python3.8/site-packages/django/utils/asyncio.py", line 26, in inner
web_1 | return func(*args, **kwargs)
web_1 | File "/usr/local/lib/python3.8/site-packages/django/db/backends/base/base.py", line 197, in connect
web_1 | self.connection = self.get_new_connection(conn_params)
web_1 | File "/usr/local/lib/python3.8/site-packages/django/utils/asyncio.py", line 26, in inner
web_1 | return func(*args, **kwargs)
web_1 | File "/usr/local/lib/python3.8/site-packages/django/db/backends/postgresql/base.py", line 185, in get_new_connection
web_1 | connection = Database.connect(**conn_params)
web_1 | File "/usr/local/lib/python3.8/site-packages/psycopg2/__init__.py", line 127, in connect
web_1 | conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
web_1 | django.db.utils.OperationalError: could not connect to server: Connection refused
web_1 | Is the server running on host "localhost" (127.0.0.1) and accepting
web_1 | TCP/IP connections on port 5433?
web_1 | could not connect to server: Cannot assign requested address
web_1 | Is the server running on host "localhost" (::1) and accepting
web_1 | TCP/IP connections on port 5433?
web_1 |
touristspots_database | CREATE EXTENSION
touristspots_database | CREATE EXTENSION
touristspots_database | CREATE EXTENSION
touristspots_database | CREATE EXTENSION
touristspots_database |
touristspots_database | waiting for server to shut down...2020-07-24 13:03:37.371 UTC [46] LOG: received fast shutdown request
touristspots_database | .2020-07-24 13:03:37.405 UTC [46] LOG: aborting any active transactions
touristspots_database | 2020-07-24 13:03:37.411 UTC [46] LOG: background worker "logical replication launcher" (PID 53) exited with exit code 1
touristspots_database | 2020-07-24 13:03:37.412 UTC [48] LOG: shutting down
touristspots_database | .2020-07-24 13:03:39.051 UTC [46] LOG: database system is shut down
touristspots_database | done
touristspots_database | server stopped
touristspots_database |
touristspots_database | PostgreSQL init process complete; ready for start up.
touristspots_database |
touristspots_database | 2020-07-24 13:03:39.395 UTC [1] LOG: starting PostgreSQL 12.3 (Debian 12.3-1.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
touristspots_database | 2020-07-24 13:03:39.405 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
touristspots_database | 2020-07-24 13:03:39.405 UTC [1] LOG: listening on IPv6 address "::", port 5432
touristspots_database | 2020-07-24 13:03:39.472 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
touristspots_database | 2020-07-24 13:03:39.596 UTC [92] LOG: database system was shut down at 2020-07-24 13:03:38 UTC
touristspots_database | 2020-07-24 13:03:39.647 UTC [1] LOG: database system is ready to accept connections
=====================================================================================================
No Dbeaver o banco está ativo...
Quando tento executar as migrações:
snowman on  80 [!?] is 📦 v0.1.0 via 🐍 v3.8.3
❯ docker-compose exec web python manage.py migrate
Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/django/db/backends/base/base.py", line 220, in ensure_connection
self.connect()
File "/usr/local/lib/python3.8/site-packages/django/utils/asyncio.py", line 26, in inner
return func(*args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/django/db/backends/base/base.py", line 197, in connect
self.connection = self.get_new_connection(conn_params)
File "/usr/local/lib/python3.8/site-packages/django/utils/asyncio.py", line 26, in inner
return func(*args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/django/db/backends/postgresql/base.py", line 185, in get_new_connection
connection = Database.connect(**conn_params)
File "/usr/local/lib/python3.8/site-packages/psycopg2/__init__.py", line 127, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: could not connect to server: Connection refused
Is the server running on host "localhost" (127.0.0.1) and accepting
TCP/IP connections on port 5433?
could not connect to server: Cannot assign requested address
Is the server running on host "localhost" (::1) and accepting
TCP/IP connections on port 5433?
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment