Copying Roles between instances

[sri_c003]

Say, I created an NPrinting instance, and created a bunch of roles. And then I want to copy these roles to another instance of NPrinting (same version).

How do i achieve this, not going the backup and restore route since that would apply to all other areas too.

I want a copy of only the various security roles.

This would help me back them up and restore in case I am going for a wipe and clean installation too.

[sri_c003]

Lech...

When i do psql --help, it lists out various options, along with the below:

-d, --dbname=DBNAME

database name to connect to (default: "npadmin")

  -U, --username=USERNAME  database user name (default: "npadmin")

And this is the output I see when i execute the command to connect:

C:\Users\npadmin>psql -U localhost  -p 4992  npadmin

Password for user localhost:

psql: FATAL:  password authentication failed for user "localhost"

I am doing this via command prompt, and not qlik. Hoping this doesn't matter.

Also, when i try to do the backup using the same password, it works with no errors and generates the backup properly (verified by restoring the same).

[sri_c003]

I guess I shall try installing NPrinting again, on a fresh box, and try connecting.

[Lech_Miszkiewicz]

i connect to it using pgAdmin

in configuration you just put:

to simplify i would install it locally on NPrinting server and use:

server name: localhost

port: 4992

db name: nprinitng

user:     postgres

pwd: password you created when installing nprinitng

that's all.

connectivity with different user will not work