Skip to content

Instantly share code, notes, and snippets.

@michelp
Created March 5, 2019 07:26
Show Gist options
  • Select an option

  • Save michelp/2a29d23dc5663db5a1ef106341defa60 to your computer and use it in GitHub Desktop.

Select an option

Save michelp/2a29d23dc5663db5a1ef106341defa60 to your computer and use it in GitHub Desktop.
postgres=# \i /tests/single.sql
Going to single user mode
waiting for server to shut down...2019-03-05 07:25:44.650 UTC [108] LOG: received fast shutdown request
.2019-03-05 07:25:44.652 UTC [108] LOG: aborting any active transactions
2019-03-05 07:25:44.653 UTC [116] FATAL: terminating connection due to administrator command
2019-03-05 07:25:44.665 UTC [108] LOG: background worker "logical replication launcher" (PID 115) exited with exit code 1
2019-03-05 07:25:44.665 UTC [110] LOG: shutting down
2019-03-05 07:25:44.693 UTC [108] LOG: database system is shut down
done
server stopped
PostgreSQL stand-alone backend 11.2
backend> select vector_bool(10);
1: vector_bool (typeid = 12369, len = -1, typmod = -1, byval = f)
----
matrix new: (GrB_Matrix *) v = new (type, vlen = 10, vdim = 1, Ap:0, csc:1, hyper:-1 0.0625, plen:1) line 59 file /home/postgres/GraphBLAS/Source/GrB_Vector_new.c
Calloc: *Ahandle = calloc (1 = 1, sizeof (struct GB_Matrix_opaque) = 216) line 74 file /home/postgres/GraphBLAS/Source/GB_new.c
Calloc: A->p = calloc (A->plen+1 = 2, sizeof (int64_t) = 8) line 182 file /home/postgres/GraphBLAS/Source/GB_new.c
1: vector_bool = "<vector_bool(10):[0,0,0,0,0,0,0,0,0,0][]>" (typeid = 12369, len = -1, typmod = -1, byval = f)
----
vector free: vector_free (v) line 23 file /home/postgres/GraphBLAS/Source/GrB_Vector_free.c
Free: (A->p, A->plen+1 = 2, sizeof (int64_t) = 8) line 39 file /home/postgres/GraphBLAS/Source/GB_ph_free.c
Free: (*matrix, 1 = 1, sizeof (struct GB_Matrix_opaque) = 216) line 34 file /home/postgres/GraphBLAS/Source/GB_free.c
backend> waiting for server to start....2019-03-05 07:26:10.928 UTC [135] LOG: listening on IPv4 address "127.0.0.1", port 5432
2019-03-05 07:26:10.928 UTC [135] LOG: could not bind IPv6 address "::1": Cannot assign requested address
2019-03-05 07:26:10.928 UTC [135] HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
2019-03-05 07:26:10.933 UTC [135] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432"
2019-03-05 07:26:10.957 UTC [136] LOG: database system was shut down at 2019-03-05 07:26:10 UTC
2019-03-05 07:26:10.967 UTC [135] LOG: database system is ready to accept connections
done
server started
Multi user model resumed
You are now connected to database "postgres" as user "postgres".
postgres=#
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment