Replying to Avatar Ezofox

For paid relay operators: If a user has switched profiles from an old publickey to a new one and they are admitted to your relay with the old public key. You can update an existing public key to the latest one without having to have the readmit themselves, if you would like to. Steps to do it:

1) Run: 'docker ps' and find the container ID associated with postgresql instance running for Nostream.

2) Run: docker ps exec -it psql -U nostr_ts_relay (Make sure to remove <> angle brackets).

3) Once connected to postgresql as that user, execute this: UPDATE users SET pubkey = '\x' WHERE pubkey='\x'; (Make sure to remove <> angle brackets).

Avatar
Enki 2y ago

Useful.

#[0]

Reply to this note

Please Login to reply.

Discussion

No replies yet.