| From: | "ascot(dot)moss(at)gmail(dot)com" <ascot(dot)moss(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL general <pgsql-general(at)postgresql(dot)org> |
| Cc: | ascot(dot)moss(at)gmail(dot)com |
| Subject: | pgloader error : permission denied to set parameter "lc_messages" |
| Date: | 2013-06-25 07:05:20 |
| Message-ID: | CD60E33F-0D3D-40E0-A4F4-A7458037BE5B@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2013-06-25 07:16:44 | Re: [HACKERS] Frontend/backend protocol improvements proposal (request). |
| Previous Message | Frank Broniewski | 2013-06-25 06:36:55 | Re: .pgpass being ignored |