Versions Compared

Old Version 23

changes.mady.by.user Jonas Kluger

Saved on

compared with

New Version 24

changes.mady.by.user Jonas Kluger

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Now create a new library inside the software. Use the dbuser user_daselement to connect to the databas.

...

Code Block
# log in to the newly created database
psql --port=5432 de_munich_vfxelements

We have to create a publication for this library/database that all the other facilities can later subscribe to.

Code Block
# give the user_replication the correct priviliges to create a publication
GRANT ALL PRIVILEGES ON DATABASE de_munich_vfxelements TO user_replication;

# create publication for all tables
create publication muc_pub for all tables;
# #> the expected output is: CREATE PUBLICATION

# to show all publication use this command
\dRp

Configure subscriber server

...

command

description

\l

list all databases

\du

list all users

\dRp

lists available publications

\dRs

lists available subscriptions

ALTER USER user_name WITH PASSWORD 'new_password';

change user password

initdb: command not found

...