[Stork-dev] installation problems

Brendan Kearney bpk678 at gmail.com
Fri Oct 20 22:11:24 UTC 2023


list members,

i put up an instance of postgres and stork on my desktop to pilot the 
effort, and took some liberties with elevated privs because i was on my 
desktop.  i got things mostly working and now want to move the 
installation to my servers, and perform the install with my own id on 
the servers.  this has led to issues with permissions and access that 
should not be.

when the db create routine is run, using:

stork-tool \
        db-create \
        --db-host postgres.bpk2.com \
        -p 5433 \
        --db-name stork \
        --db-user stork

stork-tool \
        db-init \
        -d stork \
        --db-host postgres.bpk2.com \
        -p 5433 \
        --db-sslmode disable

stork-tool \
         db-up \
         -d stork \
         --db-host postgres.bpk2.com \
         -p 5433 \
         --db-sslmode disable

my id is used to create all of the tables and the stork db user cannot 
access a bunch of tables.  i also note that all of the options specified 
when creating the database are not populated. owner, encoding, 
lc_collate, etc are not set.  my id is setup with every priv except 
initiate streaming replication.

why is it that my id cannot create the database properly?  is there an 
assumption that the creation of the database must be done as the 
postgres user?  i cannot get the database created in any usable fashion 
when using my id, and i dont want to resort to using elevated privs 
beyond what my id already has.  any insight would be appreciated.

thank you,

brendan



More information about the stork-dev mailing list