Skip to content

Instantly share code, notes, and snippets.

@stevekuznetsov
Created February 9, 2016 04:00
Show Gist options
  • Save stevekuznetsov/594fd145cad9c80e3d96 to your computer and use it in GitHub Desktop.
Save stevekuznetsov/594fd145cad9c80e3d96 to your computer and use it in GitHub Desktop.
postgres setup error
$ PGPASSWORD=password psql --host=localhost --port=5432 --username=admin --dbname=db -f postgresql/creation.sql
psql:postgresql/creation.sql:1: ERROR: could not open extension control file "/opt/rh/rh-postgresql94/root/usr/share/pgsql/extension/uuid-ossp.control": No such file or directory
CREATE TYPE
psql:postgresql/creation.sql:9: ERROR: function uuid_generate_v4() does not exist
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
psql:postgresql/creation.sql:16: ERROR: relation "object_references" does not exist
psql:postgresql/creation.sql:22: ERROR: relation "object_references" does not exist
psql:postgresql/creation.sql:30: ERROR: function uuid_generate_v4() does not exist
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
psql:postgresql/creation.sql:35: ERROR: function uuid_generate_v4() does not exist
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
psql:postgresql/creation.sql:41: ERROR: relation "resources" does not exist
psql:postgresql/creation.sql:46: ERROR: relation "object_references" does not exist
psql:postgresql/creation.sql:51: ERROR: function uuid_generate_v4() does not exist
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
psql:postgresql/creation.sql:57: ERROR: relation "role_bindings" does not exist
psql:postgresql/creation.sql:64: ERROR: relation "role" does not exist
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment