Re: Database setup for pgarchives
От | Sahil Harpal |
---|---|
Тема | Re: Database setup for pgarchives |
Дата | |
Msg-id | CAKi=nnfENiGVhbM9Arr-xNP6qRTtQ4phgc5HwJ-N-jQhWf6LNA@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Database setup for pgarchives (Sahil Harpal <sahilharpal1234@gmail.com>) |
Список | pgsql-www |
Also I created a database in the WSL but I'm not getting how can I add the pgsql-hackers list in the database which is required to load the data using mbox.Could you please share the SQL query that I need to use for the list name and listgroup insertion?
This insertion part is done using following queries.
- INSERT INTO listgroups (groupid, groupname, sortkey) VALUES (1, 'Developer lists', 1);
- INSERT INTO lists (listid, listname, shortdesc, description, active, groupid, subscriber_access) VALUES (1, 'pgsql-hackers', 'pgsql-hackers', 'The PostgreSQL developers team lives here. Discussion of current development issues, problems and bugs, and proposed new features. If your question cannot be answered by people in the other lists, and it is likely that only a developer will know the answer, you may re-post your question in this list. You must try elsewhere first!', True, 1, True);
Now the execution of load_message.py gives below error:
Failed to parse mbox:
b'/bin/sh: 1: formail: not found\n'
b'/bin/sh: 1: formail: not found\n'
В списке pgsql-www по дате отправления: