[BUGS] BUG #4233: Unable to install postgresql-8.3.3 into WindowsXP, an installer error
The following bug has been logged online: Bug reference: 4233 Logged by: Arkady Sherman Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: Windows XP Description:Unable to install postgresql-8.3.3 into WindowsXP, an installer error Details: When I try to install the postgresql (8.3.2, 8.3.3) with the msi installer, 1. Download postgresql-8.3.3-1.zip for Windows 2. Extract the files into a directory 3. Run postgresql-8.3.msi after a form with the language selection the installer gets hanged with the three msiexec.exe processes running. If to kill the MsiExec.exe with the following command line "C:\WINNT\system32\MsiExec.exe -Embedding C24956E9C064D059DFD7FCAA1CBBA8F1 C" the installation seems to continue normally. The log file before the process killing is following: === Verbose logging started: 12.06.2008 11:21:23 Build type: SHIP UNICODE 3.01.4001.5512 Calling process: C:\WINNT\system32\msiexec.exe === MSI (c) (5C:C0) [11:21:23:187]: Resetting cached policy values MSI (c) (5C:C0) [11:21:23:187]: Machine policy value 'Debug' is 0 MSI (c) (5C:C0) [11:21:23:187]: *** RunEngine: *** Product: D:\temp\postgresql-8.3-int.msi *** Action: *** CommandLine: ** MSI (c) (5C:C0) [11:21:23:187]: Machine policy value 'DisableUserInstalls' is 0 MSI (c) (5C:C0) [11:21:25:796]: SOFTWARE RESTRICTION POLICY: Verifying package --> 'D:\temp\postgresql-8.3-int.msi' against software restriction policy MSI (c) (5C:C0) [11:21:25:796]: Note: 1: 2262 2: DigitalSignature 3: -2147287038 MSI (c) (5C:C0) [11:21:25:796]: SOFTWARE RESTRICTION POLICY: D:\temp\postgresql-8.3-int.msi is not digitally signed MSI (c) (5C:C0) [11:21:25:812]: SOFTWARE RESTRICTION POLICY: D:\temp\postgresql-8.3-int.msi is permitted to run because the user token authorizes execution (marked SANDBOX_INERT). MSI (c) (5C:C0) [11:21:25:937]: Cloaking enabled. MSI (c) (5C:C0) [11:21:25:937]: Attempting to enable all disabled priveleges before calling Install on Server MSI (c) (5C:C0) [11:21:25:953]: End dialog not enabled MSI (c) (5C:C0) [11:21:25:953]: Original package ==> D:\temp\postgresql-8.3-int.msi MSI (c) (5C:C0) [11:21:25:953]: Package we're running from ==> C:\DOCUME~1\ai\LOCALS~1\Temp\37265bc.msi MSI (c) (5C:C0) [11:21:25:984]: APPCOMPAT: looking for appcompat database entry with ProductCode '{B823632F-3B72-4514-8861-B961CE263224}'. MSI (c) (5C:C0) [11:21:25:984]: APPCOMPAT: no matching ProductCode found in database. MSI (c) (5C:C0) [11:21:25:984]: MSCOREE not loaded loading copy from system32 MSI (c) (5C:C0) [11:21:25:984]: Machine policy value 'TransformsSecure' is 0 MSI (c) (5C:C0) [11:21:25:984]: User policy value 'TransformsAtSource' is 0 MSI (c) (5C:C0) [11:21:25:984]: Machine policy value 'DisablePatch' is 0 MSI (c) (5C:C0) [11:21:25:984]: Machine policy value 'AllowLockdownPatch' is 0 MSI (c) (5C:C0) [11:21:25:984]: Machine policy value 'DisableLUAPatching' is 0 MSI (c) (5C:C0) [11:21:25:984]: Machine policy value 'DisableFlyWeightPatching' is 0 MSI (c) (5C:C0) [11:21:25:984]: Looking for storage transform: lang_ru MSI (c) (5C:C0) [11:21:25:984]: Validating transform 'lang_ru' with validation bits 0 MSI (c) (5C:C0) [11:21:25:984]: Transform 'lang_ru' is valid. MSI (c) (5C:C0) [11:21:25:984]: Note: 1: 2205 2: 3: Patch MSI (c) (5C:C0) [11:21:25:984]: Note: 1: 2205 2: 3: PatchPackage MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: _Tables 3: -2147287038 MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: _Columns 3: -2147287038 MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: Media 3: -2147287038 MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: File 3: -2147287038 MSI (c) (5C:C0) [11:21:26:000]: TRANSFORM: 'PatchPackage' table is missing or empty. No pre-transform fixup necessary. MSI (c) (5C:C0) [11:21:26:000]: TRANSFORM: Applying regular transform to database. MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: _Tables 3: -2147287038 MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: _Columns 3: -2147287038 MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: _Validation 3: -2147287038 MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: AdminExecuteSequence 3: -2147287038 MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: Condition 3: -2147287038 MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: AdminUISequence 3: -2147287038 MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: AdvtExecuteSequence 3: -2147287038 MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: Binary 3: -2147287038 MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: CheckBox 3: -2147287038 MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: ComboBox 3: -2147287038 MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: Component 3: -2147287038 MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: ControlCondition 3: -2147287038 MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: ControlEvent 3: -2147287038 MSI (c) (5C:C0) [11:21:26:000]: Note: 1: 2262 2: CustomAction 3: -2147287038 MS
[BUGS] BUG #4234: VACUUM dies in without error in a PGAgent job
The following bug has been logged online: Bug reference: 4234 Logged by: Lawrence Cohan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.5 Operating system: Linux 4.1.1 Description:VACUUM dies in without error in a PGAgent job Details: We are using PGAgent to do the maintenance and I noticed from the server status that there's no VACCUM running against the database however the job still says "Running" and the value is still "r" on the job step from pgagent.pga_jobsteplog.jslstatus The job has three steps as described below: 1_Analyze_db that does analyze verbose; 2_Vaccum_db that does vacuum verbose: 3_Analyze_db that does analyze verbose; the second step is set to "Ignore" if Fail so the analyze will kick off anyway. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #4056: docu wrong for sqlerrmc[70]
The following bug has been logged online: Bug reference: 4056 Logged by: Michael Enke Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: Linux CentOS 5.1 Description:docu wrong for sqlerrmc[70] Details: In the 8.3.1 documentation, "32.11.2. sqlca" is written: char sqlerrmc[70]; But a sizeof(sqlca.sqlerrm.sqlerrmc) tells me: 150 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] Fwd: BUG #4235: docu wrong for sqlerrmc[70]
re-directing wayward bug report... -- Forwarded Message -- Subject: BUG #4235: docu wrong for sqlerrmc[70] Date: Thursday 12 June 2008 From: "Michael Enke" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] The following bug has been logged online: Bug reference: 4235 Logged by: Michael Enke Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: Linux CentOS 5.1 Description:docu wrong for sqlerrmc[70] Details: In the 8.3.1 documentation, "32.11.2. sqlca" is written: char sqlerrmc[70]; But a sizeof(sqlca.sqlerrm.sqlerrmc) tells me: 150 --- -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] Fwd: BUG #4235: docu wrong for sqlerrmc[70]
Robert Treat wrote: > re-directing wayward bug report... > > -- Forwarded Message -- > > Subject: BUG #4235: docu wrong for sqlerrmc[70] > Date: Thursday 12 June 2008 > From: "Michael Enke" <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > > > > The following bug has been logged online: > > Bug reference: 4235 > Logged by: Michael Enke > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.3.1 > Operating system: Linux CentOS 5.1 > Description:docu wrong for sqlerrmc[70] > Details: > > In the 8.3.1 documentation, "32.11.2. sqlca" is written: > char sqlerrmc[70]; > But a sizeof(sqlca.sqlerrm.sqlerrmc) tells me: 150 Good point. I have updated the documentation to use the same macro the C file uses. -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + Index: doc/src/sgml/ecpg.sgml === RCS file: /cvsroot/pgsql/doc/src/sgml/ecpg.sgml,v retrieving revision 1.85 diff -c -c -r1.85 ecpg.sgml *** doc/src/sgml/ecpg.sgml 3 Dec 2007 23:49:50 - 1.85 --- doc/src/sgml/ecpg.sgml 12 Jun 2008 19:13:28 - *** *** 4061,4067 struct { int sqlerrml; ! char sqlerrmc[70]; } sqlerrm; char sqlerrp[8]; long sqlerrd[6]; --- 4061,4067 struct { int sqlerrml; ! char sqlerrmc[SQLERRMC_LEN]; } sqlerrm; char sqlerrp[8]; long sqlerrd[6]; -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs