Re: shp2pgsql error under windows
## Raivo Rebane (raivor...@gmail.com): > Raivo@DESKTOP-69FUU49 /cygdrive/f/3D-data/Kataster > > $ cat kataster.sql | less > > > > S^@E^@T^@ ^@C^@L^@I^@E^@N^@T^@_^@E^@N^@C^@O^@D^@I^@N^@G^@ ^@T^@O^@ That's a BOM and the rest looks like UTF-16 (or UCS-2). You can use recode (also available in Cygwin) to convert that. You could also use shp2pgsql in Cygwin and be done with that (Windows is a quite bloated bootloader for Cygwin, but you do you)). Regards, Christoph -- Spare Space
shp2pgsql error under windows
Hi I am usingPS F:\3D-data\Kataster> shp2pgsql -g piirid SHP_KATASTRIYKSUS kataster > kataster.sql under Windows 10 And it’s output is full of zeroe Cygwin helps to find them out, Raivo@DESKTOP-69FUU49 /cygdrive/f/3D-data/Kataster $ cat kataster.sql | less S^@E^@T^@ ^@C^@L^@I^@E^@N^@T^@_^@E^@N^@C^@O^@D^@I^@N^@G^@ ^@T^@O^@ ^@U^@T^@F^@8^@;^@^M^@ ^@S^@E^@T^@ ^@S^@T^@A^@N^@D^@A^@R^@D^@_^@C^@O^@N^@F^@O^@R^@M^@I^@N^@G^@_^@S^@T^@R^@I^@N^@G^@S^@ ^@T^@O^@ ^@O^@N^@;^@^M^@ ^@B^@E^@G^@I^@N^@;^@^M^@ ^@C^@R^@E^@A^@T^@E^@ ^@T^@A^@B^@L^@E^@ ^@"^@k^@a^@t^@a^@s^@t^@e^@r^@"^@ ^@(^@g^@i^@d^@ ^@s^@e^@r^@i^@a^@l^@,^@^M^@ ^@"^@t^@u^@n^@n^@u^@s^@"^@ ^@v^@a^@r^@c^@h^@a^@r^@(^@2^@5^@)^@,^@^M^@ ^@"^@h^@k^@o^@o^@d^@"^@ ^@v^@a^@r^@c^@h^@a^@r^@(^@4^@)^@,^@^M^@ ^@"^@m^@k^@_^@n^@i^@m^@i^@"^@ ^@v^@a^@r^@c^@h^@a^@r^@(^@1^@0^@0^@)^@,^@^M^@ ^@"^@o^@v^@_^@n^@i^@m^@i^@"^@ ^@v^@a^@r^@c^@h^@a^@r^@(^@1^@0^@0^@)^@,^@^M^@ ^@"^@a^@y^@_^@n^@i^@m^@i^@"^@ ^@v^@a^@r^@c^@h^@a^@r^@(^@1^@0^@0^@)^@,^@^M^@ ^@"^@l^@_^@a^@a^@d^@r^@e^@s^@s^@"^@ ^@v^@a^@r^@c^@h^@a^@r^@(^@2^@4^@0^@)^@,^@^M^@ ^@"^@r^@e^@g^@i^@s^@t^@r^@"^@ ^@d^@a^@t^@e^@,^@^M^@ ^@"^@m^@u^@u^@d^@e^@t^@"^@ ^@d^@a^@t^@e^@,^@^M^@ ^@"^@s^@i^@h^@t^@1^@"^@ ^@v^@a^@r^@c^@h^@a^@r^@(^@4^@5^@)^@,^@^M^@ ^@"^@s^@i^@h^@t^@2^@"^@ ^@v^@a^@r^@c^@h^@a^@r^@(^@4^@5^@)^@,^@^M^@ ^@"^@s^@i^@h^@t^@3^@"^@ ^@v^@a^@r^@c^@h^@a^@r^@(^@4^@5 How to generate proper sql output Regards Raivo
Re: Error on Windows
Igor Korot wrote: > The following code compiles and executes but returns an error: > > [quote] > Invalid byte sequence for encoding UTF8 > [/quote] > > [code] > char *values[2]; > values[0] = NULL, values[1] = NULL; > values[0] = new char[schemaName.length() + 1]; > values[1] = new char[tableName.length() + 1]; > memset( values[0], '\0', schemaName.length() + 1 ); > memset( values[1], '\0', tableName.length() + 1 ); > strcpy( values[0], m_pimpl->m_myconv.to_bytes( schemaName.c_str() > ).c_str() ); > strcpy( values[1], m_pimpl->m_myconv.to_bytes( tableName.c_str() > ).c_str() ); > int len1 = (int) schemaName.length(); > int len2 = (int) tableName.length(); > int length[2] = { len1, len2 }; > int formats[2] = { 1, 1 }; > PGresult *res = PQexecParams( m_db, m_pimpl->m_myconv.to_bytes( > query.c_str() ).c_str(), 2, NULL, values, length, formats, 1 ); > ExecStatusType status = PQresultStatus( res ); > if( status != PGRES_COMMAND_OK && status != PGRES_TUPLES_OK ) > { > result = 1; > std::wstring err = m_pimpl->m_myconv.from_bytes( > PQerrorMessage( m_db ) ); > errorMsg.push_back( L"Error executing query: " + err ); > PQclear( res ); > } > [/code] > > in the "err" variable. > > Looking under MSVC debugger I see for a tableName a following sequence: > > 97 98 99 223 > > What can I do to eliminate the error? I'd say you should set the client encoding correctly. Looks like the bytes represent "abcß" in some LATIN-? encoding. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
Error on Windows
Hi, ALL, The following code compiles and executes but returns an error: [quote] Invalid byte sequence for encoding UTF8 [/quote] [code] char *values[2]; values[0] = NULL, values[1] = NULL; values[0] = new char[schemaName.length() + 1]; values[1] = new char[tableName.length() + 1]; memset( values[0], '\0', schemaName.length() + 1 ); memset( values[1], '\0', tableName.length() + 1 ); strcpy( values[0], m_pimpl->m_myconv.to_bytes( schemaName.c_str() ).c_str() ); strcpy( values[1], m_pimpl->m_myconv.to_bytes( tableName.c_str() ).c_str() ); int len1 = (int) schemaName.length(); int len2 = (int) tableName.length(); int length[2] = { len1, len2 }; int formats[2] = { 1, 1 }; PGresult *res = PQexecParams( m_db, m_pimpl->m_myconv.to_bytes( query.c_str() ).c_str(), 2, NULL, values, length, formats, 1 ); ExecStatusType status = PQresultStatus( res ); if( status != PGRES_COMMAND_OK && status != PGRES_TUPLES_OK ) { result = 1; std::wstring err = m_pimpl->m_myconv.from_bytes( PQerrorMessage( m_db ) ); errorMsg.push_back( L"Error executing query: " + err ); PQclear( res ); } [/code] in the "err" variable. Looking under MSVC debugger I see for a tableName a following sequence: 97 98 99 223 What can I do to eliminate the error? Thank you.
Re: Strange error in Windows 10 Pro
Just to put a finishing note to this thread: I am placing the blame on the mfg of the PC - was supposed to be a NEW, but had a Reburbished sticker on the bottom of the case. Now, whether it was the PC mfg or Microsoft's fault, I really could care less - the PC became useless for installing PostgreSQL - versions 8.4.5, 9.6.7 or 10.3. The install ALWAYS failed at the very last step - the building of the internal folders, etc of the *data* folder. So, in frustration, I have chosen to install 8.4.5 on an older PC running XP. It just works! I don't like it, but I am constrained by the owner's wishes. Thanks, for offering each of your individual helps. Regards, Dale Seaburg On 4/21/2018 3:08 PM, Dale Seaburg wrote: Thanks Adrian for the suggestion of running the installer with Admin rights. Unfortunately, I get the same results. It appears that all of the folders within C:\Program Files\PostgreSQL\9.6 path are created, and populated, BUT, when the items in the *data* folder are to be created, or copied into, it leaves an error message as noted previously. The *data* folder is empty. It's almost as if the PC is missing a critical .dll needed in the *data* folder filling function (my guess). Again, I am at a loss as to what to do. Dale On 4/20/2018 11:13 PM, Dale Seaburg wrote: Oops, my mistake. I'll let this serve the list with what I've tried so far. Thanks, Adrian for the reminder. I hope tomorrow to visit the customer and try the Admin user method of installing. Dale On 4/20/2018 11:03 PM, Adrian Klaver wrote: On 04/20/2018 07:52 PM, Dale Seaburg wrote: Please also reply to list. Ccing list to put it front of more eyes. Thanks, Adrian, for suggestion(s). On 4/20/2018 9:35 PM, Adrian Klaver wrote: On 04/20/2018 07:16 PM, Dale Seaburg wrote: I am attempting to install a fresh copy of postgresql-9.6.8-2-windows-x86 on a new DELL PC with Windows 10 Pro. It This was downloaded from where? downloaded from https://www.postgresql.org/download/windows/, selecting to use the installer pointed to near the beginning of that page. The actual website that contained the installer file was: "https://www.enterprisedb.com/thank-you-downloading-postgresql?anid=209611;. gets near the end of the install when the message says it is attempting to start the the database server. There's a long pause, followed by an error message: "Failed to load SQL modules into the database cluster". Using File Explorer, i notice the 9.6\base\ folder is empty? Has anyone else seen this before? I have no clue where to look for the issue. You are running as Admin user? I can't say that I was. Will check this next time (maybe tomorrow) when I am customer's site. I didn't even think about right-clicking on the installer and selecting run-as-admin. I know I did not deliberately use Admin user on the test PC mentioned below, and it installed with no problems. As a double-check on a different PC with Windows 10 Pro, I get no error message, and the database is installed correctly. Dale Seaburg
RE: Strange error in Windows 10 Pro
From: Dale Seaburg [mailto:kg...@verizon.net] Sent: Monday, April 23, 2018 10:10 PM To: pgsql-general@lists.postgresql.org Subject: Re: Strange error in Windows 10 Pro Thanks to Moreno and Igor for the Event Viewer suggestions. Here are a few lines of log file where they differ between a good install and a bad incomplete install. The good install was from my Shop PC with Windows 10 Pro. BTW, I had success with another Dell PC with Win 10 Pro about 4 months ago. This problem appears to be a one-off. Good Install: Called AclCheck(C:\Program Files\PostgreSQL\9.6\data) Called IsVistaOrNewer()... 'winmgmts' object initialized... Version:10. MajorVersion:10 Executing icacls to ensure the SHOP-PC\Dale account can read the path C:\Program Files\PostgreSQL\9.6\data Executing batch file 'rad0510A.bat'... processed file: C:\Program Files\PostgreSQL\9.6\data Successfully processed 1 files; Failed processing 0 files Bad Install: Called AclCheck(D:\PostgreSQL\9.6\data) Called IsVistaOrNewer()... 'winmgmts' object initialized... Version:10. MajorVersion:10 Executing icacls to ensure the WINDOWS-6BEGVO1\don king account can read the path D:\PostgreSQL\9.6\data Executing batch file 'rad6DBC7.bat'... Notice the last four lines of the Good Install vs the last two lines of the Bad Install. There is no indication of processing, or whether it was successful or not in the bad install. As you can see, I even took Igor's suggestion to install in a non-system (Program Files) path, to no success. Again, not sure what to do. Open for suggestions... I'm almost ready to call Dell and complain about a "bad" Win 10 Pro install. Dale Dale, The problem isn’t in “bad” Win10 Pro install. The problem is that Win10 on this machine is configured differently from Win10 machine where your install worked fine. In Windows there is a “default” association between file types/extensions and programs that execute these files by default. Batch files like 'rad6DBC7.bat' shouldn’t have any association, Win OS knows that this type should be executed by OS, like .exe types. But sometimes Windows users change it, and associate .bat files with Notepad (or some other text editor) in order to be able to edit batch scripts. By the way, batch file names are different in “good” and “bad” installations because those are temporary files created by vbs scripts that are running during install. So, in order to fix this you need to dissociate .bat type/extension from Notepad, or whatever text editor it is associated on the “bad” Windows. If you don’t know where to look for this feature in Win OS, ask someone who’s more familiar with windows environment. Pretty sure that’s the solution of your problem. Regards, Igor Neyman
Re: Strange error in Windows 10 Pro
Il 24/04/2018 04:09, Dale Seaburg ha scritto: Thanks to Moreno and Igor for the Event Viewer suggestions. Here are a few lines of log file where they differ between a good install and a bad incomplete install. The good install was from my Shop PC with Windows 10 Pro. BTW, I had success with another Dell PC with Win 10 Pro about 4 months ago. This problem appears to be a one-off. Good Install: Called AclCheck(C:\Program Files\PostgreSQL\9.6\data) Called IsVistaOrNewer()... 'winmgmts' object initialized... Version:10. MajorVersion:10 Executing icacls to ensure the SHOP-PC\Dale account can read the path C:\Program Files\PostgreSQL\9.6\data Executing batch file 'rad0510A.bat'... processed file: C:\Program Files\PostgreSQL\9.6\data Successfully processed 1 files; Failed processing 0 files Bad Install: Called AclCheck(D:\PostgreSQL\9.6\data) Called IsVistaOrNewer()... 'winmgmts' object initialized... Version:10. MajorVersion:10 Executing icacls to ensure the WINDOWS-6BEGVO1\don king account can read the path D:\PostgreSQL\9.6\data Executing batch file 'rad6DBC7.bat'... It would be interesting to have the next 2 lines in "Bad install", like in "good install", to know if rad6DBC7.bat excecution terminated with or without errors so if there's an error it would be nice to see it. I assume D: to be a secondary local drive or anyway a local partition not a network or external one... Thanks Moreno.-
Re: Strange error in Windows 10 Pro
On 04/23/2018 07:09 PM, Dale Seaburg wrote: Thanks to Moreno and Igor for the Event Viewer suggestions. Here are a few lines of log file where they differ between a good install and a bad incomplete install. The good install was from my Shop PC with Windows 10 Pro. BTW, I had success with another Dell PC with Win 10 Pro about 4 months ago. This problem appears to be a one-off. So is the below from the bitrock_installer logs or the Event Viewer logs? Big difference I notice is C:\ vs D:\. Where is D:\? Good Install: /Called AclCheck(C:\Program Files\PostgreSQL\9.6\data)// //Called IsVistaOrNewer()...// // 'winmgmts' object initialized...// // Version:10.// // MajorVersion:10// //Executing icacls to ensure the SHOP-PC\Dale account can read the path C:\Program Files\PostgreSQL\9.6\data// // Executing batch file 'rad0510A.bat'...// // processed file: C:\Program Files\PostgreSQL\9.6\data// //Successfully processed 1 files; Failed processing 0 files/ Bad Install: /Called AclCheck(D:\PostgreSQL\9.6\data)// //Called IsVistaOrNewer()...// // 'winmgmts' object initialized...// // Version:10.// // MajorVersion:10// //Executing icacls to ensure the WINDOWS-6BEGVO1\don king account can read the path D:\PostgreSQL\9.6\data// // Executing batch file 'rad6DBC7.bat'...// // /Notice the last four lines of the *Good Install* vs the last two lines of the *Bad Install*. There is no indication of processing, or whether it was successful or not in the bad install. As you can see, I even took Igor's suggestion to install in a non-system (Program Files) path, to no success. Again, not sure what to do. Open for suggestions... I'm almost ready to call Dell and complain about a "bad" Win 10 Pro install. Dale -- Adrian Klaver adrian.kla...@aklaver.com
Re: Strange error in Windows 10 Pro
As you may have noticed in the Bad Install section, the user's name was 'don king' - with an embedded space. I created a new user 'Dale' to test out whether that name might be causing a problem. The new name also failed to complete an install. Dale On 4/23/2018 9:09 PM, Dale Seaburg wrote: Thanks to Moreno and Igor for the Event Viewer suggestions. Here are a few lines of log file where they differ between a good install and a bad incomplete install. The good install was from my Shop PC with Windows 10 Pro. BTW, I had success with another Dell PC with Win 10 Pro about 4 months ago. This problem appears to be a one-off. Good Install: /Called AclCheck(C:\Program Files\PostgreSQL\9.6\data)// //Called IsVistaOrNewer()...// // 'winmgmts' object initialized...// // Version:10.// // MajorVersion:10// //Executing icacls to ensure the SHOP-PC\Dale account can read the path C:\Program Files\PostgreSQL\9.6\data// // Executing batch file 'rad0510A.bat'...// // processed file: C:\Program Files\PostgreSQL\9.6\data// //Successfully processed 1 files; Failed processing 0 files/ Bad Install: /Called AclCheck(D:\PostgreSQL\9.6\data)// //Called IsVistaOrNewer()...// // 'winmgmts' object initialized...// // Version:10.// // MajorVersion:10// //Executing icacls to ensure the WINDOWS-6BEGVO1\don king account can read the path D:\PostgreSQL\9.6\data// // Executing batch file 'rad6DBC7.bat'...// /
Re: Strange error in Windows 10 Pro
Thanks to Moreno and Igor for the Event Viewer suggestions. Here are a few lines of log file where they differ between a good install and a bad incomplete install. The good install was from my Shop PC with Windows 10 Pro. BTW, I had success with another Dell PC with Win 10 Pro about 4 months ago. This problem appears to be a one-off. Good Install: /Called AclCheck(C:\Program Files\PostgreSQL\9.6\data)// //Called IsVistaOrNewer()...// // 'winmgmts' object initialized...// // Version:10.// // MajorVersion:10// //Executing icacls to ensure the SHOP-PC\Dale account can read the path C:\Program Files\PostgreSQL\9.6\data// // Executing batch file 'rad0510A.bat'...// // processed file: C:\Program Files\PostgreSQL\9.6\data// //Successfully processed 1 files; Failed processing 0 files/ Bad Install: /Called AclCheck(D:\PostgreSQL\9.6\data)// //Called IsVistaOrNewer()...// // 'winmgmts' object initialized...// // Version:10.// // MajorVersion:10// //Executing icacls to ensure the WINDOWS-6BEGVO1\don king account can read the path D:\PostgreSQL\9.6\data// // Executing batch file 'rad6DBC7.bat'...// // /Notice the last four lines of the *Good Install* vs the last two lines of the *Bad Install*. There is no indication of processing, or whether it was successful or not in the bad install. As you can see, I even took Igor's suggestion to install in a non-system (Program Files) path, to no success. Again, not sure what to do. Open for suggestions... I'm almost ready to call Dell and complain about a "bad" Win 10 Pro install. Dale // On 4/23/2018 9:54 AM, Moreno Andreo wrote: Il 21/04/2018 22:35, Adrian Klaver ha scritto: On 04/21/2018 01:08 PM, Dale Seaburg wrote: Thanks Adrian for the suggestion of running the installer with Admin rights. Unfortunately, I get the same results. It appears that all of the folders within C:\Program Files\PostgreSQL\9.6 path are created, and populated, BUT, when the items in the *data* folder are to be created, or copied into, it leaves an error message as noted previously. The *data* folder is empty. It's almost as if the PC is missing a critical .dll needed in the *data* folder filling function (my guess). Again, I am at a loss as to what to do. Have you looked at the system logs e.g. Event Viewer? If you look in %temp%", there should be one or more files named "bitrock_installer" or something similar (search for "bitrock"), that's the setup log with what's went good and what not. Another hint I had since 9.1 times (it was 2012, I guess) was to avoid installing Postgres under system folders (c:\program files, c:\users, and so on) because in some cases there could be some nasty behaviors... try installing on something like c:\PG96... HTH Cheers, Moreno.-
Re: Strange error in Windows 10 Pro
Il 21/04/2018 22:35, Adrian Klaver ha scritto: On 04/21/2018 01:08 PM, Dale Seaburg wrote: Thanks Adrian for the suggestion of running the installer with Admin rights. Unfortunately, I get the same results. It appears that all of the folders within C:\Program Files\PostgreSQL\9.6 path are created, and populated, BUT, when the items in the *data* folder are to be created, or copied into, it leaves an error message as noted previously. The *data* folder is empty. It's almost as if the PC is missing a critical .dll needed in the *data* folder filling function (my guess). Again, I am at a loss as to what to do. Have you looked at the system logs e.g. Event Viewer? If you look in %temp%", there should be one or more files named "bitrock_installer" or something similar (search for "bitrock"), that's the setup log with what's went good and what not. Another hint I had since 9.1 times (it was 2012, I guess) was to avoid installing Postgres under system folders (c:\program files, c:\users, and so on) because in some cases there could be some nasty behaviors... try installing on something like c:\PG96... HTH Cheers, Moreno.-
Re: Strange error in Windows 10 Pro
On 04/21/2018 01:08 PM, Dale Seaburg wrote: Thanks Adrian for the suggestion of running the installer with Admin rights. Unfortunately, I get the same results. It appears that all of the folders within C:\Program Files\PostgreSQL\9.6 path are created, and populated, BUT, when the items in the *data* folder are to be created, or copied into, it leaves an error message as noted previously. The *data* folder is empty. It's almost as if the PC is missing a critical .dll needed in the *data* folder filling function (my guess). Again, I am at a loss as to what to do. Have you looked at the system logs e.g. Event Viewer? Dale On 4/20/2018 11:13 PM, Dale Seaburg wrote: Oops, my mistake. I'll let this serve the list with what I've tried so far. Thanks, Adrian for the reminder. I hope tomorrow to visit the customer and try the Admin user method of installing. Dale On 4/20/2018 11:03 PM, Adrian Klaver wrote: On 04/20/2018 07:52 PM, Dale Seaburg wrote: Please also reply to list. Ccing list to put it front of more eyes. Thanks, Adrian, for suggestion(s). On 4/20/2018 9:35 PM, Adrian Klaver wrote: On 04/20/2018 07:16 PM, Dale Seaburg wrote: I am attempting to install a fresh copy of postgresql-9.6.8-2-windows-x86 on a new DELL PC with Windows 10 Pro. It This was downloaded from where? downloaded from https://www.postgresql.org/download/windows/, selecting to use the installer pointed to near the beginning of that page. The actual website that contained the installer file was: "https://www.enterprisedb.com/thank-you-downloading-postgresql?anid=209611;. gets near the end of the install when the message says it is attempting to start the the database server. There's a long pause, followed by an error message: "Failed to load SQL modules into the database cluster". Using File Explorer, i notice the 9.6\base\ folder is empty? Has anyone else seen this before? I have no clue where to look for the issue. You are running as Admin user? I can't say that I was. Will check this next time (maybe tomorrow) when I am customer's site. I didn't even think about right-clicking on the installer and selecting run-as-admin. I know I did not deliberately use Admin user on the test PC mentioned below, and it installed with no problems. As a double-check on a different PC with Windows 10 Pro, I get no error message, and the database is installed correctly. Dale Seaburg -- Adrian Klaver adrian.kla...@aklaver.com
Re: Strange error in Windows 10 Pro
Oops, my mistake. I'll let this serve the list with what I've tried so far. Thanks, Adrian for the reminder. I hope tomorrow to visit the customer and try the Admin user method of installing. Dale On 4/20/2018 11:03 PM, Adrian Klaver wrote: On 04/20/2018 07:52 PM, Dale Seaburg wrote: Please also reply to list. Ccing list to put it front of more eyes. Thanks, Adrian, for suggestion(s). On 4/20/2018 9:35 PM, Adrian Klaver wrote: On 04/20/2018 07:16 PM, Dale Seaburg wrote: I am attempting to install a fresh copy of postgresql-9.6.8-2-windows-x86 on a new DELL PC with Windows 10 Pro. It This was downloaded from where? downloaded from https://www.postgresql.org/download/windows/, selecting to use the installer pointed to near the beginning of that page. The actual website that contained the installer file was: "https://www.enterprisedb.com/thank-you-downloading-postgresql?anid=209611;. gets near the end of the install when the message says it is attempting to start the the database server. There's a long pause, followed by an error message: "Failed to load SQL modules into the database cluster". Using File Explorer, i notice the 9.6\base\ folder is empty? Has anyone else seen this before? I have no clue where to look for the issue. You are running as Admin user? I can't say that I was. Will check this next time (maybe tomorrow) when I am customer's site. I didn't even think about right-clicking on the installer and selecting run-as-admin. I know I did not deliberately use Admin user on the test PC mentioned below, and it installed with no problems. As a double-check on a different PC with Windows 10 Pro, I get no error message, and the database is installed correctly. Dale Seaburg
Re: Strange error in Windows 10 Pro
On 04/20/2018 07:52 PM, Dale Seaburg wrote: Please also reply to list. Ccing list to put it front of more eyes. Thanks, Adrian, for suggestion(s). On 4/20/2018 9:35 PM, Adrian Klaver wrote: On 04/20/2018 07:16 PM, Dale Seaburg wrote: I am attempting to install a fresh copy of postgresql-9.6.8-2-windows-x86 on a new DELL PC with Windows 10 Pro. It This was downloaded from where? downloaded from https://www.postgresql.org/download/windows/, selecting to use the installer pointed to near the beginning of that page. The actual website that contained the installer file was: "https://www.enterprisedb.com/thank-you-downloading-postgresql?anid=209611;. gets near the end of the install when the message says it is attempting to start the the database server. There's a long pause, followed by an error message: "Failed to load SQL modules into the database cluster". Using File Explorer, i notice the 9.6\base\ folder is empty? Has anyone else seen this before? I have no clue where to look for the issue. You are running as Admin user? I can't say that I was. Will check this next time (maybe tomorrow) when I am customer's site. I didn't even think about right-clicking on the installer and selecting run-as-admin. I know I did not deliberately use Admin user on the test PC mentioned below, and it installed with no problems. As a double-check on a different PC with Windows 10 Pro, I get no error message, and the database is installed correctly. Dale Seaburg -- Adrian Klaver adrian.kla...@aklaver.com
Re: Strange error in Windows 10 Pro
On 04/20/2018 07:16 PM, Dale Seaburg wrote: I am attempting to install a fresh copy of postgresql-9.6.8-2-windows-x86 on a new DELL PC with Windows 10 Pro. It This was downloaded from where? gets near the end of the install when the message says it is attempting to start the the database server. There's a long pause, followed by an error message: "Failed to load SQL modules into the database cluster". Using File Explorer, i notice the 9.6\base\ folder is empty? Has anyone else seen this before? I have no clue where to look for the issue. You are running as Admin user? As a double-check on a different PC with Windows 10 Pro, I get no error message, and the database is installed correctly. Dale Seaburg -- Adrian Klaver adrian.kla...@aklaver.com
Strange error in Windows 10 Pro
I am attempting to install a fresh copy of postgresql-9.6.8-2-windows-x86 on a new DELL PC with Windows 10 Pro. It gets near the end of the install when the message says it is attempting to start the the database server. There's a long pause, followed by an error message: "Failed to load SQL modules into the database cluster". Using File Explorer, i notice the 9.6\base\ folder is empty? Has anyone else seen this before? I have no clue where to look for the issue. As a double-check on a different PC with Windows 10 Pro, I get no error message, and the database is installed correctly. Dale Seaburg