If I execute the following commands:
sudo -u postgres psql
it shows that uuid_generate_v4() does exist. It seems that the function exists for the postgres database, but not dirtsand. If I connect to the dirtsand database and perform the following:
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
then uuid_generate_v4() is visible to the dirtsand database. I know that I created the extension when following the instructions on how to set up dirtsand, however, it may be that roles/permissions/authorities may not have been set up properly.
I'll try running the dirtsand setup instructions again, paying attention to what user does the setup. Perhaps that will avoid these issues.
I don't know if this is the right place to post questions about setting up a new shard. If it isn't, then please let me know.
If I try to add a new account to my dirtsand database, I get the following error. Have I missed a step in setting up my server?
ds-918> addacct testacct xxxxxx44
Postgres SELECT error: ERROR: function uuid_generate_v4() does not exist
LINE 1: SELECT uuid_generate_v4()
HINT: No function matches the given name and argument types. You might need to add explicit type casts.