[pgadmin-support] Password
Good day, I've been using PGAdmin and still now my problem is that it does not require a password in the login before accessing the databases. You just need a username which "postgres" has the admin, and even if you don't type a password it still logs in. Hope the next version will have this one included. Thank you very much. Gilbert B. Gabog MiS, Globalink Holdings Corp. Philippines "Do right things right, the first time and everytime" ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [pgadmin-support] Password
pgAdmin doesn't enforce security, PostgreSQL does. If you can login without a password, you must have misconfigured PostgreSQL. Check your pg_hba.conf file. Regards, Dave _Original message Subject:[pgadmin-support] Password Sender: "..:: Gilbert B. Gabog ::.." <[EMAIL PROTECTED]> Date: Wed, 9 Oct 2002 08:44:53 + Good day, I've been using PGAdmin and still now my problem is that it does not require a password in the login before accessing the databases. You just need a username which "postgres" has the admin, and even if you don't type a password it still logs in. Hope the next version will have this one included. Thank you very much. Gilbert B. Gabog MiS, Globalink Holdings Corp. Philippines "Do right things right, the first time and everytime" ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster ---(end of broadcast)--- TIP 3: 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
[pgadmin-support] Speed
Fellow pgAdministrators, Shortly I went trying to use pgAdmin. I know pgAdmin uses ODBC, and I know that it is not the quickest form of connection you can get. I can live with that... but I wondered if any of you is experiencing this kind of performance as well, or have experienceD, and know a solution ;-) Connecting itself takes 5 seconds (I can live with that, no problem) Clicking on 'Databases' makes me wait at least 10 minutes (I have only one database of my own, aside the default databases) I cannot live with that... Listing the tables takes another 10 minutes at least etc etc... everything just takes ages... I really do not exaggerate, and think there ought to be a way to fix it... I have: pgAdmin 1.2.0 with databases on Postgres 7.2.2 Today I upgraded pgODBC, but that did not really help... anyone? ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [pgadmin-support] Speed
I don't know how big your database is, but I have one with 23 tables of varying sizes, the largest of which is 25,000 records. Each step in the hierarchy, ie open connection, open database, open table, takes about 2 seconds. My server is a Dell P3 600mz and my client is a Dell P3 400mz. I use the same pgAdmin, but Postgres 7.2.1. Are you running any other protocols besides tcp/ip? [EMAIL PROTECTED] wrote: >Fellow pgAdministrators, > >Shortly I went trying to use pgAdmin. I know pgAdmin uses ODBC, and I know >that it is not the quickest form of connection you can get. >I can live with that... but I wondered if any of you is experiencing this >kind of performance as well, or have experienceD, and know a solution ;-) > >Connecting itself takes 5 seconds (I can live with that, no problem) >Clicking on 'Databases' makes me wait at least 10 minutes (I have only one >database of my own, aside the default databases) I cannot live with that... >Listing the tables takes another 10 minutes at least etc etc... everything >just takes ages... > >I really do not exaggerate, and think there ought to be a way to fix it... >I have: >pgAdmin 1.2.0 with databases on Postgres 7.2.2 >Today I upgraded pgODBC, but that did not really help... anyone? > > > >---(end of broadcast)--- >TIP 2: you can get off all lists at once with the unregister command >(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) > > > > ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
