[GENERAL] test
Re: [GENERAL] createdb.exe prompting for password on Vista
And how would I enable this? I've tried all the created password options with no luck. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Sullivan Sent: 28 May 2007 02:52 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] createdb.exe prompting for password on Vista On Sun, May 27, 2007 at 09:02:56PM +0200, Greg Quinn wrote: I am using createdb to automatically create a database from a .sql file, but in Vista it seems to prompt me for the postgres password. How can I stop this from happening? I'm not using the -W or -password option so why does it ask me for a password? You must have password authentication enabled. You'd have to change it to trust, I guess. A -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *did* exactly what you told them to. That actually seems sort of quaint now. --J.D. Baldwin ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [GENERAL] createdb.exe prompting for password on Vista
Setting the authentication option to trust seems to work but now I'm worried my application won't need a password for users accessing the database. It is a client-server application so I don't know which IP addresses can/can't use it and I'm not relying my application to be on a windows domain/active directory. I'm thinking the best way to get around it is change the auth option to trust in my installer, create the database, and then automatically set the auth option back to md5. Not the most elegant solution but it will work for now. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Sullivan Sent: 28 May 2007 07:46 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] createdb.exe prompting for password on Vista On Mon, May 28, 2007 at 07:18:47PM +0200, Greg Quinn wrote: And how would I enable this? I've tried all the created password options with no luck. You'll need to look at http://www.postgresql.org/docs/8.2/static/client-authentication.html. Sorry, I know nothing about Windows, so if there's some Windows-specific tricks, you may need to know that. A -- Andrew Sullivan | [EMAIL PROTECTED] Everything that happens in the world happens at some place. --Jane Jacobs ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[GENERAL] createdb.exe prompting for password on Vista
I am using createdb to automatically create a database from a .sql file, but in Vista it seems to prompt me for the postgres password. How can I stop this from happening? I'm not using the -W or -password option so why does it ask me for a password? Here is my command... createdb.exe -U postgres myDb Thanks
[GENERAL] Problems running PostGreSQL silent install
I have seen many problems like this in the forum, but cannot see a solution for mine... I have created an account with restricted privileges for the service. Everything works fine until I get an error running the silent install. Failed to run initdb: 1! I then check the logfile, and it says The files belonging to this database system will be owned by user postgres2. This user must also own the server process. The database cluster will be initialized with locale C. initdb: directory C:/Program Files/PostgreSQL/8.1/data exists but is not empty If you want to create a new database system, either remove or empty the directory C:/Program Files/PostgreSQL/8.1/data or run initdb with an argument other than C:/Program Files/PostgreSQL/8.1/data. The problem is, that I am trying to install a second instance of PostGreSQL on another port in another location my test computer. Is this possible? Here is my silent install .bat script file msiexec.exe /i postgresql-8.1-int.msi /qr INTERNALLAUNCH=1 ADDLOCAL=server,psql BASEDIR=c:\postgres SERVICEDOMAIN=%COMPUTERNAME% SERVICEACCOUNT=postgres2 SERVICEPASSWORD=test SUPERPASSWORD=o2BS#9798 LISTENPORT=9092 ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] Problems running PostGreSQL silent install
Thank you for the reply. But then are you saying I don't even really need to use the MSI in the first place? I can just copy the files to a folder. Then run initdb and pg_ctl? I am bundling PostGreSQL with my software package. And will be using Installshield to copy my program files to the client computer. Now can I just get the PostGresql folder, put it where I want, then Run initdb and pg_ctl? -Original Message- From: Magnus Hagander [mailto:[EMAIL PROTECTED] Sent: Friday, October 27, 2006 10:22 PM To: Greg Quinn; [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Subject: RE: [GENERAL] Problems running PostGreSQL silent install No, the MSI instlaler only lets you install once instance on each machine. (Unless you are talking different versions, that is). You can, however, install one instance with the MSI installer, and then manually run initdb and pg_ctl register to set up a second service with a different data directory. //Magnus ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[GENERAL] Question about openSSL
1.) I went to the OpenSSL ste, and tried to download opnSSL, but I only saw Linux files. Is OpenSSL supported ni Windows? 2.) I am using the Npgsql.NET data provider to connect, but it doesnt support SSL yet, when will it support SSL? Thanks