Re: [ADMIN] hba conf ident sameuser not working

David Bear <[EMAIL PROTECTED]> writes: > now, back on teancum that has the tunnel on port , I do this: > [EMAIL PROTECTED]:~> psql -p -h localhost -U tlhowell > psql: FATAL: Ident authentication failed for user "tlhowell" > [EMAIL PROTECTED]:~> psql -p -h localhost -U iddwb > psql:

Re: [ADMIN] hba conf ident sameuser not working

On Wed, Feb 15, 2006 at 11:27:36AM +0100, Peter Eisentraut wrote: > David Bear wrote: > > now, when I connection to postgres from remote machines I ssh into > > the pg server, but I tunnel postgres traffic. The ident sameuser > > prevents tunneled connections from working. > > That is not true. P

Re: [ADMIN] Switch log (WAL)

On Sun, 2006-02-12 at 11:47 +0100, [EMAIL PROTECTED] wrote: > How Can I do that ? This is on my todo list for 8.2, but not yet at the top. Best Regards, Simon Riggs ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore yo

Re: [ADMIN] constraint_exclusion on OLTP tables

On Mon, 2006-02-13 at 09:50 -0500, Chris Hoover wrote: > The problem I am having is how can you safely move records between > main_table_live and one of the other partition tables? Obviously, > this will have to happen as our users work the data and the records > enter into on of the 2 closed sta

Re: [ADMIN] making duplicate of database for development

I made a dump with pg_dump -s -Fp --no-owner and removed the database and schema definition ontop of the dump. Then i imported it into my new database. Seems to work. Is this how you do it? :) Tilman Baumann schrieb: >hi. > >I like to make a copy of my existing database as a playgound/sandbox fo

[ADMIN] making duplicate of database for development

hi. I like to make a copy of my existing database as a playgound/sandbox for developing. Is there any advise ho to achive this? Maybe there are tips how to work with it. Recommended workflows for taking a snapsot of one database and transfer it to another (including schema) and backmerging the c

Re: [ADMIN] Best filesystem

Martha Stewart called it a Good Thing when [EMAIL PROTECTED] (Arnau) wrote: >Which is the best filesystem in linux for postgresql? nowadays I'm > using ext3, I don't know if other filesystems like XFS, reiser... would > be better from the performance point of view. Do you care more about perfo

[ADMIN] Best filesystem

Hi all, Which is the best filesystem in linux for postgresql? nowadays I'm using ext3, I don't know if other filesystems like XFS, reiser... would be better from the performance point of view. Cheers! -- Arnau ---(end of broadcast)--- TIP 3: Hav

[ADMIN] how test postgresql.conf settings?

Hi all, I'm testing different configurations of postgresql 8.1 running on debian. The method I was following was: - change the postgresql.conf - restart postgres (/etc/init.d/postgresql restart ) - execute my test queries I have noticed that this is not enough to flush the cache, I don'

Re: [ADMIN] hba conf ident sameuser not working

David Bear wrote: > now, when I connection to postgres from remote machines I ssh into > the pg server, but I tunnel postgres traffic. The ident sameuser > prevents tunneled connections from working. That is not true. Please give more detail so we can figure out what is really wrong. -- Peter