pgloader error : permission denied to set parameter "lc_messages"

Поиск
Список
Период
Сортировка
От ascot.moss@gmail.com
Тема pgloader error : permission denied to set parameter "lc_messages"
Дата
Msg-id CD60E33F-0D3D-40E0-A4F4-A7458037BE5B@gmail.com
обсуждение исходный текст
Ответ на Re: File System backup  (Kevin Grittner <kgrittn@ymail.com>)
Ответы Re: pgloader error : permission denied to set parameter "lc_messages"  (Adrian Klaver <adrian.klaver@gmail.com>)
Список pgsql-general
Hi,

I am trying to load CSV files into postgresql via pgloader, it returned the following error, any suggestions to fix it?

I have a line "lc_messages = C" in my pgloader.conf, would this line cause the problem?

regards


pgloader     ERROR    permission denied to set parameter "lc_messages"
pgloader     ERROR    permission denied to set parameter "lc_messages"

Traceback (most recent call last):
  File "/usr/bin/pgloader", line 779, in <module>
    ret = load_data()
  File "/usr/bin/pgloader", line 687, in load_data
    (started[s], finished[s]), summary[s])
  File "/usr/lib/pymodules/python2.7/pgloader/pgloader.py", line 142, in __init__
    self._read_conf(name, config, db)
  File "/usr/lib/pymodules/python2.7/pgloader/pgloader.py", line 328, in _read_conf
    self.columns = self.db.get_all_columns(self.table)
  File "/usr/lib/pymodules/python2.7/pgloader/db.py", line 153, in get_all_columns
    self.reset()
  File "/usr/lib/pymodules/python2.7/pgloader/db.py", line 189, in reset
    self.set_pg_options()
  File "/usr/lib/pymodules/python2.7/pgloader/db.py", line 117, in set_pg_options
    raise PGLoader_Error, e
pgloader.tools.PGLoader_Error: permission denied to set parameter "lc_messages"




В списке pgsql-general по дате отправления:

Предыдущее
От: Frank Broniewski
Дата:
Сообщение: Re: .pgpass being ignored
Следующее
От: Albe Laurenz
Дата:
Сообщение: Re: [HACKERS] Frontend/backend protocol improvements proposal (request).