create user

sudo -u postgres createuser teleschirm_development_andi

set password

ALTER USER teleschirm_development_andi WITH PASSWORD 'password';

teleschirm_development=> select pg_get_serial_sequence('locations', 'id');
 pg_get_serial_sequence  
-------------------------
 public.locations_id_seq
(1 row)

teleschirm_development=> ALTER SEQUENCE locations_id_seq RESTART WITH 2000;
ALTER SEQUENCE