[GENERAL] No password prompt logging into Postgres 8.4

Using th new postgresql 8.4.0 (compiled) On Ubuntu 8.10 I did an initdb, added a password to the postgres user and then changed the pg_hba.conf to: local all all md5 host all all 127.0.0.1/32 md5 Restarted Postgresql. If I log in normally: postg...@ben-desktop:~$ psq

Re: [GENERAL] usage of indexes for inner joins

Sequence scans of an empty table are going to be faster than an index scan, so the database uses the sequence scan. Put some data in the tables (some thousands or millions of records) and then see if it uses an index scan. Ben ""Jan Theodore Galkowski"" <[EMAIL PROTECTED]> wrote in message ne

Re: [GENERAL] It's time to support GRANT SELECT,UPDATE,...,...,... ON database.* to username

<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > I don't care if it's part of the SQL standard or not. I don't care if > oracle does it or not. You're losing mysql converts as they go > through the tutorial and get to this point. Or worse, they just "grant > all" because it's easie

Re: [GENERAL] Database Security

Look at changing your pg_hba.conf file If you have a line in the file like: hostall all 127.0.0.1/32 trust change it to: hostall all 127.0.0.1/32 md5 then run: pg_ctl reload should get you whare you want to be. Ben "Danilo Freitas da Co

Re: [GENERAL] why postgresql over other RDBMS

Better support! Where else can you get feedback from the actual programmers (sometimes within minutes of writing a message) than here? Ben > Hi > I was wondering, apart from extensive procedural language support > and being free, > what are other major advantages of Postgresql over other major

Re: [GENERAL] role passwords and md5()

I thought I read this be for I sent it. :-( What I meant to say was: Does the password hash change (and how?) Or is the original username kept somewhere is the system tables? Regards, Ben "Ben Trewern" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > How does

Re: [GENERAL] role passwords and md5()

How does this work when you rename a role? Does the is the password hash changed (and how?) or is the original username kept somewhere in the system tables? Regards, Ben "Andrew Kroeger" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Lutz Broedel wrote: >> Dear list, >> >> I a

Re: [GENERAL] Providing user based previleges to Postgres DB

Providing user based previleges to Postgres DBSee: http://www.postgresql.org/docs/8.2/interactive/user-manag.html Regards, Ben <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Hi All, Currently in one of the projects we want to restrict the unauthorized users to the Postgres D

Re: [GENERAL] role passwords and md5()

Looks like the password gets cleared when you rename a role. Regards, Ben "Ben Trewern" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] >I thought I read this be for I sent it. :-( > > What I meant to say was: > Does the password hash change (and how?)

Re: [GENERAL] Webappication and PostgreSQL login roles

I think it's something like SELECT 'md5' + md5(password + username); Regards, Ben "Thorsten Kraus" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] This would be a possible way. Now the question is which algorithm implementation of md5 PostgreSQL us

Re: [GENERAL] Webappication and PostgreSQL login roles

You could originally connect to the database as some kind of power user. Check the password against the pg_shadow view (you would need to md5 your password somehow) and then do a SET SESSION AUTHORIZATION (or SET ROLE) to change your permissions. Not sure how secure this would be but it's the w

Re: [GENERAL] UPGRADATION TO 8.1

So what's he meant to do? Write a longer question just so the mandatory disclamer that his company attaches to his e-mail takes up a lower percentage of his e-mail? (or should he not ask the question at all?) Regards, Ben > > Btw, I personally find a payload/noise ratio of 1/6 atrocious, > a

Re: [GENERAL] plpgsql and insert

Depending on what client side library you are using you could use the RETURNING clause, see the docs: http://www.postgresql.org/docs/8.2/static/sql-insert.html Regards, Ben "Jamie Deppeler" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi, > > Have a quick question is possible

Re: [GENERAL] sudden drop in delete performance

Did you 'vacuum analyze' after you did the update? Make sure you have the correct indexes in place on your foreign keys. Did you have fsync off on your previous installation? Give some more details and I'm sure people will be able to give better advice than me. Regards, Ben ""surabhi.ahuja"

Re: [GENERAL] What is the Best Postgresql Load Balancing Solution available ?

You can try using pg_pconnect instead of pg_connect.  It has some downsides so see the docs.   Also - check your memory usage, it may be you could fix this by reducing work_mem or similar.   Regards,   Ben "Najib Abi Fadel" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]...Hi

Re: [GENERAL] What is the Best Postgresql Load Balancing Solution available ?

The solution you need all depends on the problem you are having. If you explain how your application is written PHP, Java, etc and where your performance problems are coming from, then someone could give you a better answer! Regards, Ben "Najib Abi Fadel" <[EMAIL PROTECTED]> wrote in message

Re: [GENERAL] pgFoundry.org not working!

Working again now! Regards, Ben "Ben Trewern" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I'm currently getting: > > "PgFoundry Could Not Connect to Database" > > when I try to visit http://pgfoundry.org > > Regards, > &

[GENERAL] pgFoundry.org not working!

I'm currently getting: "PgFoundry Could Not Connect to Database" when I try to visit http://pgfoundry.org Regards, Ben ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] could not create shared memory segment in Windows XP

Have you got Cygwin installed? I had similar problems due to Cygwin being eariler in my PATH than Pg. Regards, Ben "Andrus" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I'm unable to create database cluster in Windows 2000 server. > > initdb returns error > > FATAL: could no

Re: [GENERAL] Connecting

I'd try zeoslib (http://forum.zeoslib.net.ms/ or http://sourceforge.net/projects/zeoslib/) instead of ODBC.  The 6.1.5 version (with patches) works with Delphi 4 and always worked well for me.   Regards,   Ben "Bob Pawley" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... I'm

Re: [GENERAL] Seeking a better PL/pgSQL editor-debugger

PG Lightning does Code Completion.  I don't think there is a frontend tool that can step through a PL/pgSQL function.   Ben ""Ken Winter"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... Is a better PL/pgSQL editor / debugger than pgAdmin III or phpPgAdmin available a

Re: [GENERAL] Alternative to knoda, kexi and rekall?

For administration try pgAdmin III but to make applications you could try Gambas see: http://gambas.sourceforge.net/ or even Lazarus see: http://www.lazarus.freepascal.org/ For internet stuff try Ruby on Rails. It has a bit of a steep learning curve to start with but it's a RAD tool when you g

Re: [GENERAL] PostgreSQL, Lazarus and zeos ?

You need the cvs version of zeoslib to work with Lazarus. It's also the 6.5.something version. The old 5.x only worked with Delphi. See the Lazarus forums for more information. Ben >""Zlatko Matiæ"" <[EMAIL PROTECTED]> wrote in message >news:[EMAIL PROTECTED] >Hi. >Someone mentioned Lazar

Re: [GENERAL] When is Like different to =

reate the index. When I dropped the index Like and = started working correctly. BTW should there be check so an error is thrown if I try to change a function used in an index from IMMUTABLE to STABLE? Ben "Ben Trewern" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECT

[GENERAL] When is Like different to =

All, I've a query: SELECT c.code, c.pc_no, jl.event_no, jl.order_number, jl.location, s.status, cs.commercial_status FROM ((codes as c JOIN job_list as jl ON c.id = jl.code_id) JOIN status as s ON jl.event_no = s.event_no) JOIN commercial_status AS cs on jl.event_no = cs.event_n

Re: [GENERAL] Now() function

BTW in Postgresql 8.0 you can do: ALTER TABLE foo ALTER foo_timestamp TYPE timestamp(0) with timezone; It'll do the truncation for you. Regards, Ben "Michael Glaesemann" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > On Jun 10, 2005, at 11:37 AM, Michael Glaesemann wrote: > >

Re: [GENERAL] Delphi personal (was Playing with PostgreSQL and Access VBA)

I'm pretty sure that zeosdbo needs a version of Delphi with TDataset support. I don't think that the Personal editions have that. You can use the direct access parts of Zeos with the personal editions but then you might as well use Free Pascal and Lazarus as they have just ported ZeosDbo see

Re: [GENERAL] Binary or compiled version?

I haven't had any joy trying to install the Redhat RPMs on mandrake 10.1. It might be me but I did take some time trying. I also tried using the SRPMs and building my own but that didn't work either. Since then I've compiled my version and it works great. The only thing I needed to do was mes

Re: [GENERAL] CURRENT_TIMESTAMP vs actual time

Try SELECT timeofday()::TIMESTAMP; Regards, Ben ""Christopher J. Bottaro"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi, > I understand that CURRENT_TIMESTAMP marks the beginning of the current > transaction. I want it to be the actual time. How do I do this? > timeofday()

Re: [GENERAL] to_char bug?

Thanks, sometimes the obvious just passes me by. :-( >If the number is negative there needs to be room for the minus sign... "Martijn van Oosterhout" wrote in message news:[EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off al

Re: [GENERAL] to_char bug?

whole story ie leading blanks and I assume trailing zeros if applicable. Regards, Ben "Tom Lane" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > "Ben Trewern" <[EMAIL PROTECTED]> writes: >> It seems that to_char(1, '000')

[GENERAL] to_char bug?

Is there any reason why : SELECT char_length(to_char(1, '000')); Gives a result char_length - 4 (1 row) It seems that to_char(1, '000') gives a string " 001" with a space in front. Is this a bug? Regards, Ben ---(end of broadcast)--

[GENERAL] Pg 8.0rc5 to 8.0.1 update

Hi, Just a quick question. Do I need to do an initdb to upgrade a cluster from v8.0rc5 to v8.0.1 or can I just do a make install. TIA Ben ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] Fwd: Problem installing Postgresql on MDK10.0

I think you have to install ncurses. On Mdk 10 its libncurses5-devel I think. Try that and see what happens. Regards, Ben ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.htm

[GENERAL] pg_dump/pg_dumpall do not correctly dump search_path

All, There seems to be a bug in pg_dumpall: For one of my dbs I've done: ALTER DATABASE dbname SET search_path = mw, public; If I do a pg_dumpall I get a line like: ALTER DATABASE dbname SET search_path TO 'mw, public'; note the 's. It's also in a place in the dump before the mw schema is created