Re: [GENERAL] Silent install 8.3 diiffers from 8.2
Well it is the administrator account running the install, don't think I could get any more privileged than that. Near as I can tell even though the message says check privileges, the installer really thinks there is another postgres running, however there is not. Even with previous installs wiped clean, and processes cleared out, even server reboot to make sure nothing is left over and restarted. If it is ran in interactive mode everything works fine. I can install interactive but I would prefer to script it. The original post in April "Silent install 8.3 diiffers from 8.2" appeared to have the same problem. I was hoping someone had figured out what was wrong. I have had no problems silent installing 8.2 versions and I am able to get silent install to work with 8.3.0 however with same options 8.3.3 does not work. Basic options with just: INTERNALLAUNCH=1 SERVICEDOMAIN="MYDOMAIN" SERVICEPASSWORD="MYSERVICEPW" SUPERPASSWORD="MYPGPW" PERMITTREMOTE=1 /qr Once it fails and unwinds I can still run silent 8.2.x, or silent 8.3.0, or interactive 8.3.3, but never works for silent 8.3.3! From: Martin Gainty [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2008 3:39 PM To: Blakely, Jerel (Mission Systems); pgsql-general@postgresql.org Subject: RE: [GENERAL] Silent install 8.3 diiffers from 8.2 Jerel- any chance of running the postgres start script under god rights e.g. runas /noprofile /user:mymachine\GOD net start PostsgreSQL ? Martin __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. ________________ Subject: Re: [GENERAL] Silent install 8.3 diiffers from 8.2 Date: Wed, 20 Aug 2008 12:43:44 -0500 From: [EMAIL PROTECTED] To: pgsql-general@postgresql.org Has this issue been resolved by anyone? I can install over and over manually but any attempt at silent install fails with the same. > "Service 'PostgreSQL Database Server 8.3' (pgsql-8.3) failed to start. > Verify that you have sufficient privileges to start system services." It works fine with 8.3.0 but not 8.3.3, what changes were made to the installer? I can verify that the previous version is un-installed, make sure the postgres\8.3 directory is clear, and reboot the machine to verify that no leftover processes remain? It still fails every time on silent install, however a manual install blasts right through with no problems. I would like to hand my sa a script and say just run this rather than hand him a script caviated with "Oh and by the way you have to do manual install on all 30 machines." Get thousands of games on your PC, your mobile phone, and the web with Windows(r). Game with Windows <http://clk.atdmt.com/MRT/go/108588800/direct/01/>
Re: [GENERAL] Silent install 8.3 diiffers from 8.2
Jerel- any chance of running the postgres start script under god rights e.g. runas /noprofile /user:mymachine\GOD net start PostsgreSQL ? Martin __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. Subject: Re: [GENERAL] Silent install 8.3 diiffers from 8.2 Date: Wed, 20 Aug 2008 12:43:44 -0500 From: [EMAIL PROTECTED] To: pgsql-general@postgresql.org RE: Silent install 8.3 diiffers from 8.2 Has this issue been resolved by anyone? I can install over and over manually but any attempt at silent install fails with the same. > "Service 'PostgreSQL Database Server 8.3' (pgsql-8.3) failed to start. > Verify that you have sufficient privileges to start system services." It works fine with 8.3.0 but not 8.3.3, what changes were made to the installer? I can verify that the previous version is un-installed, make sure the postgres\8.3 directory is clear, and reboot the machine to verify that no leftover processes remain? It still fails every time on silent install, however a manual install blasts right through with no problems. I would like to hand my sa a script and say just run this rather than hand him a script caviated with "Oh and by the way you have to do manual install on all 30 machines." _ Get thousands of games on your PC, your mobile phone, and the web with Windows®. http://clk.atdmt.com/MRT/go/108588800/direct/01/
Re: [GENERAL] Silent install 8.3 diiffers from 8.2
Has this issue been resolved by anyone? I can install over and over manually but any attempt at silent install fails with the same. > "Service 'PostgreSQL Database Server 8.3' (pgsql-8.3) failed to start. > Verify that you have sufficient privileges to start system services." It works fine with 8.3.0 but not 8.3.3, what changes were made to the installer? I can verify that the previous version is un-installed, make sure the postgres\8.3 directory is clear, and reboot the machine to verify that no leftover processes remain? It still fails every time on silent install, however a manual install blasts right through with no problems. I would like to hand my sa a script and say just run this rather than hand him a script caviated with "Oh and by the way you have to do manual install on all 30 machines."
Re: [GENERAL] Silent install 8.3 diiffers from 8.2
anyone ? - Syra Didelez - Apogee Portal Deployment Manager Apogee Portal Hotfix Manager Agfa-Gevaert N.V. Tel.: +32 3 444 4237 http://www.agfa.com
[GENERAL] Silent install 8.3 diiffers from 8.2
"You should probably send those logs to the list, rather than straight to me. However, this line sticks out at me: 2008-04-07 07:43:14 GMT FATAL: lock file "postmaster.pid" already exists 2008-04-07 07:43:14 GMT HINT: Is another postmaster (PID 3724) running in data directory "F:/B"? Is it possible that the old server wasn't shut down cleanly on remove? Is there really a postmaster.pid file present? -- Craig Ringer" Hi, Crais, sorry to bother you directly ! The previous server was shut down (killed 6 postgres.exe processes) and then removed completely, both directories basedir & datadir are empty when starting the install. And yes, there is a postmaster.pid file created during install. It might not be important, but 'usually' there are 4 postgres.exe processes showing up. Here there are 6 .. it might look like the server is trying to be started up twice ... -also regardig the error in the application log about the lock file... thus, here the log files: the system event log shows the following: TypeDateTimeSource CategoryEvent UserComputer Information 4/7/20089:44:18 AM Service Control Manager None7036N/A GS2479 --> The PostgreSQL Database Server 8.3 service entered the stopped state. Information 4/7/20089:43:14 AM Service Control Manager None7035SYSTEM GS2479 --> The PostgreSQL Database Server 8.3 service was successfully sent a start control. Information 4/7/20089:43:09 AM Service Control Manager None7036N/A GS2479 --> The PostgreSQL Database Server 8.3 service entered the stopped state. Information 4/7/20089:42:05 AM Service Control Manager None7035SYSTEM GS2479 --> The PostgreSQL Database Server 8.3 service was successfully sent a start contro Information 4/7/20089:41:59 AM Service Control Manager None7036N/A GS2479 --> The PostgreSQL Database Server 8.3 service entered the stopped state. Information 4/7/20089:40:55 AM Service Control Manager None7035SYSTEM GS2479 --> The PostgreSQL Database Server 8.3 service was successfully sent a start control. Information 4/7/20089:40:49 AM Service Control Manager None7036N/A GS2479 -->The PostgreSQL Database Server 8.3 service entered the stopped state. Information 4/7/20089:39:43 AM Service Control Manager None7035SYSTEM GS2479 --> The PostgreSQL Database Server 8.3 service was successfully sent a start control. Information 4/7/20089:38:13 AM Service Control Manager None7036N/A GS2479 --> The Windows Installer service entered the running state. Information 4/7/20089:38:13 AM Service Control Manager None7035SYSTEM GS2479 --> The Windows Installer service was successfully sent a start control. the application event log: TypeDateTimeSource CategoryEvent UserComputer Error 4/7/20089:43:14 AM PostgreSQL None0 N/A GS2479 --> 2008-04-07 07:43:14 GMT FATAL: lock file "postmaster.pid" already exists 2008-04-07 07:43:14 GMT HINT: Is another postmaster (PID 3724) running in data directory "F:/B"? Information 4/7/20089:43:14 AM PostgreSQL None0 N/A GS2479 --> Waiting for server startup... Information 4/7/20089:43:09 AM PostgreSQL None0 N/A GS2479 --> Timed out waiting for server startup Error 4/7/20089:42:05 AM PostgreSQL None0 N/A GS2479 -->2008-04-07 07:42:05 GMT FATAL: lock file "postmaster.pid" already exists 2008-04-07 07:42:05 GMT HINT: Is another postmaster (PID 3724) running in data directory "F:/B"? Information 4/7/20089:42:05 AM PostgreSQL None0 N/A GS2479 --> Waiting for server startup... Information 4/7/20089:41:59 AM PostgreSQL None0 N/A GS2479 --> Timed out waiting for server startup Error 4/7/20089:40:55 AM PostgreSQL None0 N/A GS2479 --> 2008-04-07 07:40:55 GMT FATAL: lock file "postmaster.pid" already exists 2008-04-07 07:40:55 GMT HINT: Is another postmaster (PID 3724) running in data directory "F:/B"? Information 4/7/20089:40:55 AM PostgreSQL None0 N/A GS2479 --> Waiting for server startup... Warning 4/7/20089:40:49 AM Userenv None1517SYSTEM GS2479 --> Windows saved user GS2479\postgres registry while an application or service was still using the registry during log off. The memory used by the user's registry has not been freed. The registry will be unloaded when it is no longer in use. This is often caused by services running as a user account, try configuring the services to run in either the LocalService or NetworkService account. Information 4/7/20089:40:48 AM PostgreSQL None0 N/A
Re: [GENERAL] Silent install 8.3 diiffers from 8.2
"You should probably send those logs to the list, rather than straight to me. However, this line sticks out at me: 2008-04-07 07:43:14 GMT FATAL: lock file "postmaster.pid" already exists 2008-04-07 07:43:14 GMT HINT: Is another postmaster (PID 3724) running in data directory "F:/B"? Is it possible that the old server wasn't shut down cleanly on remove? Is there really a postmaster.pid file present? -- Craig Ringer" Hi, Crais, sorry to bother you directly ! The previous server was shut down (killed 6 postgres.exe processes) and then removed completely, both directories basedir & datadir are empty when starting the install. And yes, there is a postmaster.pid file created during install. It might not be important, but 'usually' there are 4 postgres.exe processes showing up. Here there are 6 .. it might look like the server is trying to be started up twice ... -also regardig the error in the application log about the lock file... thus, here the log files: the system event log shows the following: TypeDateTimeSource CategoryEvent UserComputer Information 4/7/20089:44:18 AM Service Control Manager None7036N/A GS2479 --> The PostgreSQL Database Server 8.3 service entered the stopped state. Information 4/7/20089:43:14 AM Service Control Manager None7035SYSTEM GS2479 --> The PostgreSQL Database Server 8.3 service was successfully sent a start control. Information 4/7/20089:43:09 AM Service Control Manager None7036N/A GS2479 --> The PostgreSQL Database Server 8.3 service entered the stopped state. Information 4/7/20089:42:05 AM Service Control Manager None7035SYSTEM GS2479 --> The PostgreSQL Database Server 8.3 service was successfully sent a start contro Information 4/7/20089:41:59 AM Service Control Manager None7036N/A GS2479 --> The PostgreSQL Database Server 8.3 service entered the stopped state. Information 4/7/20089:40:55 AM Service Control Manager None7035SYSTEM GS2479 --> The PostgreSQL Database Server 8.3 service was successfully sent a start control. Information 4/7/20089:40:49 AM Service Control Manager None7036N/A GS2479 -->The PostgreSQL Database Server 8.3 service entered the stopped state. Information 4/7/20089:39:43 AM Service Control Manager None7035SYSTEM GS2479 --> The PostgreSQL Database Server 8.3 service was successfully sent a start control. Information 4/7/20089:38:13 AM Service Control Manager None7036N/A GS2479 --> The Windows Installer service entered the running state. Information 4/7/20089:38:13 AM Service Control Manager None7035SYSTEM GS2479 --> The Windows Installer service was successfully sent a start control. the application event log: TypeDateTimeSource CategoryEvent UserComputer Error 4/7/20089:43:14 AM PostgreSQL None0 N/A GS2479 --> 2008-04-07 07:43:14 GMT FATAL: lock file "postmaster.pid" already exists 2008-04-07 07:43:14 GMT HINT: Is another postmaster (PID 3724) running in data directory "F:/B"? Information 4/7/20089:43:14 AM PostgreSQL None0 N/A GS2479 --> Waiting for server startup... Information 4/7/20089:43:09 AM PostgreSQL None0 N/A GS2479 --> Timed out waiting for server startup Error 4/7/20089:42:05 AM PostgreSQL None0 N/A GS2479 -->2008-04-07 07:42:05 GMT FATAL: lock file "postmaster.pid" already exists 2008-04-07 07:42:05 GMT HINT: Is another postmaster (PID 3724) running in data directory "F:/B"? Information 4/7/20089:42:05 AM PostgreSQL None0 N/A GS2479 --> Waiting for server startup... Information 4/7/20089:41:59 AM PostgreSQL None0 N/A GS2479 --> Timed out waiting for server startup Error 4/7/20089:40:55 AM PostgreSQL None0 N/A GS2479 --> 2008-04-07 07:40:55 GMT FATAL: lock file "postmaster.pid" already exists 2008-04-07 07:40:55 GMT HINT: Is another postmaster (PID 3724) running in data directory "F:/B"? Information 4/7/20089:40:55 AM PostgreSQL None0 N/A GS2479 --> Waiting for server startup... Warning 4/7/20089:40:49 AM Userenv None1517SYSTEM GS2479 --> Windows saved user GS2479\postgres registry while an application or service was still using the registry during log off. The memory used by the user's registry has not been freed. The registry will be unloaded when it is no longer in use. This is often caused by services running as a user account, try configuring the services to run in either the LocalService or NetworkService account. Information 4/7/20089:40:48 AM PostgreSQL None0 N/A
Re: [GENERAL] Silent install 8.3 diiffers from 8.2
[EMAIL PROTECTED] wrote: > With postgresql-8.3-int.msi I always run into the following security > error: > > "Service 'PostgreSQL Database Server 8.3' (pgsql-8.3) failed to start. > Verify that you have sufficient privileges to start system services." What are the full details from the system event log? -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Silent install 8.3 diiffers from 8.2
Hello, With the postgresql-8.2-int.msi, i used to do a succesful install with the following options BASEDIR=C:\Postgres DATADIR=D:\PostgresData INTERNALLAUNCH=1 DOSERVICE=1 CREATESERVICEUSER=1 SERVICEACCOUNT=postgres SERVICEDOMAIN=%COMPUTERNAME% SERVICEPASSWORD=123qwe-. DOINITDB=1 ENCODING=UTF-8 PERMITREMOTE=1 SUPERUSER=DBA SUPERPASSWORD=supersecret With postgresql-8.3-int.msi I always run into the following security error: "Service 'PostgreSQL Database Server 8.3' (pgsql-8.3) failed to start. Verify that you have sufficient privileges to start system services." When pressing cancel, I should expect a cleanup, but the bin and lib directories in the basedir still remain. This together with 6 postgres.exe processes I am using exactly the smae options as above, and I have removed the postgres user before starting the silent install. With 8.2 I could do this over and over again, with 8.3 it seems not to work. - Syra Didelez - Apogee Portal Deployment Manager Apogee Portal Hotfix Manager Agfa-Gevaert N.V. Tel.: +32 3 444 4237 http://www.agfa.com
Re: [GENERAL]silent install
2007/10/12, Richard Huxton <[EMAIL PROTECTED]>: > > Please remember to cc: the list. sorry. The first result of that search is this page: > http://pgfoundry.org/pipermail/pginstaller-devel/2005-November/000712.html > If you read the next couple of messages you get to this page: > http://pgfoundry.org/pipermail/pginstaller-devel/2005-November/000714.html > In what way is that "no answer"? > > Did you try connecting the spelling mistake? What happened? shame for my carelessness. i find the answer now ,and it works. thank you for you patience.
Re: [GENERAL]silent install
Please remember to cc: the list. longlong wrote: i have done what you said before,there always are people asking and no answer. spelling error can be the reason or not? Try using http://www.google.com/ Search for "postgresql silent install error 2711" - the top result seems relevant. In particular you have a spelling error here: "CREATESERICEUSER=1" The first result of that search is this page: http://pgfoundry.org/pipermail/pginstaller-devel/2005-November/000712.html If you read the next couple of messages you get to this page: http://pgfoundry.org/pipermail/pginstaller-devel/2005-November/000714.html In what way is that "no answer"? Did you try connecting the spelling mistake? What happened? -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL]silent install
longlong wrote: hi all, msiexec /i D:\usr\local\postgre\postgresql-8.2-int.msi /qb INTERNALLAUNCH=1 ADDLOCAL=server,psql,docs SERVICEDOMAIN="%COMPUTERNAME%" CREATESERICEUSER=1 BASEDIR="d:\usr\local\postgres" SERVICEACCOUNT="postgres" SERVICEPASSWORD="postgres" SUPERPASSWORD="11" PERMITREMOTE=1 i try to the silent installing ,but i always failed: ..this may indicate a problem with this package.The error code is 2711. is there any solution ? Try using http://www.google.com/ Search for "postgresql silent install error 2711" - the top result seems relevant. In particular you have a spelling error here: "CREATESERICEUSER=1" -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[GENERAL]silent install
hi all, msiexec /i D:\usr\local\postgre\postgresql-8.2-int.msi /qb INTERNALLAUNCH=1 ADDLOCAL=server,psql,docs SERVICEDOMAIN="%COMPUTERNAME%" CREATESERICEUSER=1 BASEDIR="d:\usr\local\postgres" SERVICEACCOUNT="postgres" SERVICEPASSWORD="postgres" SUPERPASSWORD="11" PERMITREMOTE=1 i try to the silent installing ,but i always failed: ..this may indicate a problem with this package.The error code is 2711. is there any solution ?
[GENERAL] silent install of postgres for an embedded purposes
Hi. I am new to postgres and I am porting an application to windows that is using postgresql as it's backend. I am also trying to do a silent install of postgres. I would also like to install postgres on a usb thumbdrive. It is just for demo purposes. 1) Can you have more than one instance of postgres on a machine? I have tried the following and it is failing because I have postgres installed. msiexec postgresql-8.2int.msi /qr INTERNALLAUNCH=1 ADDLOCAL=server,psql SERVICEDOMAIN="%COMPUTERNAME%" SERVICEPASSWORD="postgres" SUPERPASSWORD="postgres" BASEDIR="c:\postgres" 2) Can you install it on a usb thumbdrive? e.g. msiexec postgresql-8.2-int.msi /qr INTERNALLAUNCH=1 ADDLOCAL=server,psql SERVICEDOMAIN="%COMPUTERNAME%" SERVICEPASSWORD="postgres" SUPERPASSWORD="postgres" BASEDIR="f:\postgres" 3) How do I import and export a database? I assume I have to do some type of backup and recovery. ---(end of broadcast)--- TIP 6: explain analyze is your friend
