[Stork-dev] installation problems

[Slawek Figiel]

Hello Brendan!

If your database maintenance user is not `postgres`, you should provide 
its username and password using the following with the `db-create` command:

- the maintenance user name in the `--db-maintenance-user` flag or 
`STORK_DATABASE_MAINTENANCE_USER_NAME`
- the maintenance password (optional) in the `--db-maintenance-password 
` or `STORK_DATABASE_MAINTENANCE_PASSWORD`
- the maintenance database name in the `--db-maintenance-name` or 
`STORK_DATABASE_MAINTENANCE_NAME`

Use the `--force` flag if the database already exists, or drop it manually.

I hope it solves your problem.

Regards
Slawek Figiel

On 21/10/2023 00:11, Brendan Kearney wrote:
> 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
>