Timeline for Permission denied with Copy command when using network share
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 14, 2017 at 18:56 | comment | added | Brad Mathews |
As to using COPY...FROM STDIN I had to try that because my (very old) ADO.Net technique was throwing out of memory errors on a really large Excel spreadsheet I was trying to import. Using DataReader to avoid the memory issues and BeginBinaryImport was 2-3 times faster than previous technique and the code is a lot shorter and cleaner.
|
|
| Jul 14, 2017 at 18:50 | comment | added | Brad Mathews | Well, looks like I am SOL on this unless I want to run the Postgres service under a named account. I do not know the ramifications of doing that so am not prepared to at this time. I'll stick with programmaticaly copying the files to the server for the time being. | |
| Jul 12, 2017 at 16:49 | comment | added | Brad Mathews | I have a few other places where that technique may be better than the more generic ADO.Net focused method I use for Excel, dBase and other file types, but for text files, the COPY command is King. 150,000 records in <600ms King which other methods cannot come close to matching. I am on the trail of how to give Network Service access to the file, but not being part of a domain is complicating that. I'll post when I finish figuring it out. | |
| Jul 11, 2017 at 4:06 | history | edited | jjanes | CC BY-SA 3.0 |
grammar and clarity
|
| Jul 11, 2017 at 4:04 | comment | added | jjanes | But isn't the user who owns the database file required to be the one it runs as? I thought "runs as" might be confused with the postgres user logged into the backend. | |
| Jul 11, 2017 at 2:28 | comment | added | Craig Ringer | Wording slightly unclear - the access is done as the user that the database server is running as. Usually a service user. | |
| Jul 11, 2017 at 2:23 | history | answered | jjanes | CC BY-SA 3.0 |