A database named lister-npm must be created to hold the names of npm packages.
Description
Description
| Status | Assigned | Task | ||
|---|---|---|---|---|
| Migrated | gitlab-migration | T1629 Deploy the npm ingestion in production | ||
| Migrated | gitlab-migration | T1634 Create database for npm lister |
Event Timeline
Comment Actions
Create role
Generate password for the user lister-npm (xkcdpass is your friend).
Then add it to the swh password store.
Then:
createuser -p 5434 -P lister-npm
password:Create db
createdb -p 5434 --lc-ctype=C.UTF-8 -T template1 lister-npm -O lister-npm
Check
postgres@host:~$ psql -p 5434 lister-npm psql (11.2 (Debian 11.2-1.pgdg90+1)) Type "help" for help. lister-npm=# \d Did not find any relations. lister-npm=# \conninfo You are connected to database "lister-npm" as user "postgres" via socket in "/var/run/postgresql" at port "5434".
Initialize schema
From your machine (for example):
$ workon swh
$ swh-lister --db-url postgres://${PG_USER}:${PG_USERPASS}@${PG_HOST}:${PG_PORT}/${PG_DBNAME} npm