[BUGS] BUG #1238: postgres option -Q used in src/test/bench
The following bug has been logged online: Bug reference: 1238 Logged by: A Wu Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Beta Operating system: Linux 2.6.7-gentoo-r14 x86_64 Description:postgres option -Q used in src/test/bench Details: src/test/bench/create.sh and src/test/bench/runwisc.sh both invoke "postgres" with a -Q option which is not supported in 8.0 Beta1. Deleting -Q from both files allows the scripts to run to completion. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [BUGS] BUG #1238: postgres option -Q used in src/test/bench
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > src/test/bench/create.sh and src/test/bench/runwisc.sh both invoke > "postgres" with a -Q option which is not supported in 8.0 Beta1. These scripts really need to be thrown away or rewritten entirely. Benchmarks against a standalone backend are not interesting in the real world. I doubt anyone has tried to run these in the past five years... regards, tom lane ---(end of broadcast)--- TIP 8: explain analyze is your friend
[BUGS] Change Request
Hi I am a Tutor who teaches SQL and I like to be familiar with all Relational DBs and their SQL variants. I run WinXP HE under a single Account name and would like to install and use PostgreSQL. I have downloaded a version of PostgreSQL from http://pgfoundry.org/project/showfiles.php?group_id=107&release_id=48 and at present have installed V7.5. My problem:- (1) I don't want to use the "Install as a service" option as I do not want more than one account on my machine. (2) So I installed PostgreSQL by unchecking the "Install as a service" option. The problem now is I can't start PostgreSQL because I get the following error "execution of PostgreSQL by a user with administrative permissions is not permitted. The server must ". This appears to be a Catch22 situation. All I want is to install PostgreSQL as a WinXP Service and as a user with admin privileges be able to stop & start the PostgreSQL service. This is how I have both Oracle & MySQL installed. These are just WinXP services which are stopped by default and when I want to use them I just start the appropriate services and then use an appropriate GUI to run SQL. Is there some chance you could change your install package so that :- (1) I can install PostgreSQL as a service without having to create a new Account Name & Password OR (2) by pass install as a service but allow anyone to start the service? Bert PO Box 720 Belconnen ACT 2616 Australia +61+2+ 62541341 (h) 0427 541344 (Bert's Mobile) 0403 050965 (Mary's Mobile) --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.746 / Virus Database: 498 - Release Date: 31/08/2004 ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[BUGS] Sugestion
I would like to sugest a control panel ou icontray interface to postgre like service manager in MSSQL (icontray) or the Firebird Server manager (control panel). It would be very nice to control de service!
Re: [BUGS] Change Request
(1) I can install PostgreSQL as a service without having to create a new Account Name & Password why not? Its *VERY* standard procedure on all sorts of systems to run RDBMS servers as a dedicated user. there are all kinda system accounts already in XP used by various system services, whats one more? note, these are *NOT* regular user accounts, they don't typically show up on the "Welcome" login screen. instead of the stupified Control Panel -> User Accounts, try admin tools -> computer management -> local users and groups, which is the *real* NT Users panel... ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
