[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