Skip to content

Instantly share code, notes, and snippets.

@volkanunsal
Created April 10, 2015 18:01
Show Gist options
  • Save volkanunsal/1778cf691223e77f2e30 to your computer and use it in GitHub Desktop.
Save volkanunsal/1778cf691223e77f2e30 to your computer and use it in GitHub Desktop.
The database cluster will be initialized with locale "en_US.utf8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory /var/lib/postgresql/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
[2015-041.548093918Z] selecting default shared_buffers ... 128MB
creating configuration files ... ok
creating template1 database in /var/lib/postgresql/data/base/1 ... ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating collations ... ok
creating conversions ... ok
creating dictionaries ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
loading PL/pgSQL server-side language ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok
syncing data to disk ... ok
WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
postgres -D /var/lib/postgresql/data
or
pg_ctl -D /var/lib/postgresql/data -l logfile start
PostgreSQL stand-alone backend 9.3.6
backend> statement: ALTER USER "postgres" WITH SUPERUSER PASSWORD 'password' ;
backend>
Creating pg_hba.conf...
Creating pg_hba.conf complete.
Creating postgresql.conf...
Creating replication user...
PostgreSQL stand-alone backend 9.3.6
backend> backend> Creating replication user complete.
Creating example database...
PostgreSQL stand-alone backend 9.3.6
backend> backend> backend> backend> Creating example database complete.
PostgreSQL stand-alone backend 9.3.6
backend> statement: CREATE DATABASE template_postgis
backend> statement: UPDATE pg_database SET datistemplate = TRUE WHERE datname = 'template_postgis'
backend>
PostgreSQL stand-alone backend 9.3.6
backend> backend>
PostgreSQL stand-alone backend 9.3.6
backend> 1: addtosearchpath (typeid = 25, len = -1, typmod = -1, byval = f)
----
1: addtosearchpath = "topology has been added to end of database search_path " (typeid = 25, len = -1, typmod = -1, byval = f)
----
backend>
PostgreSQL stand-alone backend 9.3.6
LOG: database system was shut down at 2015-04-10 17:59:18 GMT
LOG: autovacuum launcher started
LOG: database system is ready to accept connections
LOG: connection received: host=104.131.66.183 port=46406
LOG: replication connection authorized: user=replication
LOG: connection received: host=104.131.66.183 port=46407
LOG: replication connection authorized: user=replication
LOG: disconnection: session time: 0:00:01.000 user=replication database= host=104.131.66.183 port=46407
LOG: disconnection: session time: 0:00:01.370 user=replication database= host=104.131.66.183 port=46406
The database cluster will be initialized with locale "en_US.utf8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory /var/lib/postgresql/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
creating configuration files ... ok
creating template1 database in /var/lib/postgresql/data/base/1 ... ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating collations ... ok
creating conversions ... ok
creating dictionaries ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
loading PL/pgSQL server-side language ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok
syncing data to disk ... ok
WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
postgres -D /var/lib/postgresql/data
or
pg_ctl -D /var/lib/postgresql/data -l logfile start
PostgreSQL stand-alone backend 9.3.6
backend> statement: ALTER USER "postgres" WITH SUPERUSER PASSWORD 'password' ;
backend>
Creating .pgpass
Cleaning up old cluster directory
Starting base backup as replicator
transaction log start point: 0/9000028 on timeline 1
pg_basebackup: starting background WAL receiver
0/36356 kB (0%), 0/1 tablespace (...lib/postgresql/data/backup_l36365/36365 kB (100%), 1/1 tablespace
transaction log end point: 0/90000F0
pg_basebackup: waiting for background process to finish streaming ...
pg_basebackup: base backup completed
Creating pg_hba.conf...
Creating pg_hba.conf complete.
Creating postgresql.conf...
Writing recovery.conf file
Creating the staging directory to hold the master's log files
LOG: database system was interrupted; last known up at 2015-04-10 17:55:36 GMT
LOG: entering standby mode
LOG: redo starts at 0/9000028
LOG: consistent recovery state reached at 0/90000F0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment