> From: Kevin Grittner
>Glyn Astill wrote:
>
>> How can I specifically catch superusers?
>
> Create a group (nobody?) that you don't grant to any users. Only
> superusers will be a member of it.
>
Ah of course, simple, thanks Kevin.
I can't help but f
> From: Tom Lane
>G lyn Astill writes:
>> I'm having what's hopefully a fairly trivial issue here with
> pg_hba.conf in 9.0.4; when I add in the following line
>
>> host all +ad_users 10.10.0.0/16 ldap details>
>
>> If I try to log in with a superuser account
Hi Guys,
I'm having what's hopefully a fairly trivial issue here with pg_hba.conf in
9.0.4; when I add in the following line
hostall +ad_users 10.10.0.0/16 ldap
If I try to log in with a superuser account from the 10.10.0.0/16 network it
appears to try to authen
Hi Guys,
Does anyone know of any tricks to replace primary key indexes without using
reindex? Or any other method that will not lock the table for an extended
amount of time on 8.4?
I've got a bloated primary key index on a table and I'd like to try and clean
it up without downtime.
A quick s
--- On Mon, 4/4/11, Tom Lane wrote:
> > --- On Mon, 4/4/11, Tom Lane
> wrote:
> >>> So it appears now that if I restore the
> database using
> >>> pg_restore, I end up with bloated indexes,
> which are fixed
> >>> with a vacuum full.
> >>>
> >>> The dump is a data only dump with the -Fc
> flag
--- On Mon, 4/4/11, Tom Lane wrote:
> > So it appears now that if I restore the database using
> pg_restore, I end up with bloated indexes, which are fixed
> with a vacuum full.
>
> > The dump is a data only dump with the -Fc flag,
>
> Data only dump? Then what is the state of the
> database yo
--- On Fri, 1/4/11, Glyn Astill wrote:
> --- On Fri, 1/4/11, Kenneth Marshall wrote:
> What
> > happens
> > if you run a REINDEX on both DB's to the index sizes?
> >
> > Regards,
> > Ken
> >
>
> Sorry for the lack of info there. Both are
--- On Fri, 1/4/11, Kenneth Marshall wrote:
> >
> > Just testing some new hardware on 9.0.3 and have
> restored one of our dumps from 8.4.7. What I'm seeing
> is although table sizes are the same, indexes are a lot
> bigger, approx 50%.
> >
> > I've done a search and so far can't find anything
Hey Guys,
Just testing some new hardware on 9.0.3 and have restored one of our dumps from
8.4.7. What I'm seeing is although table sizes are the same, indexes are a lot
bigger, approx 50%.
I've done a search and so far can't find anything, but have default fillfactors
changed? Or is it someth
> From: Lukasz Brodziak
> Subject: [ADMIN] Dropping all constraints in database
> To: pgsql-admin@postgresql.org
> Date: Monday, 14 March, 2011, 9:26
> Hello,
>
> Is there a way of disabling/dropping all constrainsts in a
> given
> database? I need to restore a db which has duplicate values
> in
Was thinking the same on Friday morning actually.
The last post I see on the Pgpool-II mailing list is from Tastsuo about an hour
before the tsunami hit.
Hopefully they're all well, I'm sure Postgresql is probably a low priority at
the moment.
--- On Sat, 12/3/11, Benjamin Krajmalnik wrote:
--- On Wed, 23/6/10, Tom Lane wrote:
> Glyn Astill
> writes:
> > Good point. No I've not seen it on a file
> smaller than 2GB, but the test I did was pretty basic - I
> just trimmed down the size of all of my tables to create a
> dump that was only 50Mb or so.
--- On Tue, 22/6/10, Kevin Grittner wrote:
> Glyn Astill
> wrote:
>
> > so far I can only get the same error with large dump
> files.
>
> "Large" being a relative term --
> ever see it on a file smaller than 2GB?
>
Good point. No I've not see
--- On Tue, 22/6/10, Igor Neyman wrote:
> From: Igor Neyman
> Subject: Re: [ADMIN] parallel option in pg_restore
> To: "John Rouillard"
> Cc: pgsql-admin@postgresql.org
> Date: Tuesday, 22 June, 2010, 17:34
>
> No piping, just regular restore from the backup file.
>
Same here. If only I co
> From: Igor Neyman
> Subject: Re: [ADMIN] parallel option in pg_restore
> To: "Tom Lane"
> Cc: pgsql-admin@postgresql.org
> Date: Tuesday, 22 June, 2010, 16:05
> > -Original Message-
> > From: Tom Lane [mailto:t...@sss.pgh.pa.us]
>
> > Sent: Tuesday, June 22, 2010 10:37 AM
> > To: Igor
--- On Fri, 30/4/10, Ross J. Reedstrom wrote:
> > Hi,
> >
> > I have a number of PostgreSQL servers which I often
> access through ssh
> > tunnel with Pgadmin3. I would like to double check
> which one I have landed
> > on (if the tunnel is really configured the way I
> want). Is there a way to
--- On Thu, 25/3/10, Richard Broersma wrote:
> wrote:
> > Thanks for quick answer. Sorry, this was a misstype.
> We are using 8.4 not
> > 8.8.
> >
> > We are using the OLEDB-Provider for ADO.
> > On 8.2 the connectionstring works, on 8,4 it does not
> work.
> > The database is local and accessed
Run a vacuum verbose and look at the output at the end.
Word is that as of 8.4 these parameters will autotune themselvs.
--- On Wed, 24/6/09, Allgood, John wrote:
> From: Allgood, John
> Subject: Re: [ADMIN] tuning our database by increasing shared buffer
> To: "Barbara Stephenson" , "Tom Lan
have you generated the ssl certificates too?
--- On Sun, 1/3/09, Lukas wrote:
> From: Lukas
> Subject: Re: [ADMIN] Postgesql and SSL
> To: pgsql-admin@postgresql.org
> Date: Sunday, 1 March, 2009, 8:37 AM
> Hello again,
>
> nope, no use of it.. Situation stays the same.. Does any
> one have
You defo have all the required openssl headers and libs and configure succeeds?
It's a longshot, but I wonder if the prefix is somehow making configure read
the string wrong? I've never really needed to use prefix, but what happend if
you try
./configure --prefix='/DB' --with-openssl
or perhap
> configure:2629: checking how to run the C preprocessor
> configure:2669: gcc -E conftest.c
> configure:2675: $? = 0
> configure:2706: gcc -E conftest.c
> conftest.c:8:28: error: ac_nonexistent.h: No such file or
> directory
> configure:2712: $? = 1
> configure: failed program was:
> | /* confd
MAIL PROTECTED], pgsql-admin@postgresql.org
> Date: Saturday, 6 December, 2008, 8:35 PM
> what does explain analyze yourqueryhere say?
>
> On Sat, Dec 6, 2008 at 1:33 PM, Glyn Astill
> <[EMAIL PROTECTED]> wrote:
> > Anyone?
> >
> >
> > --- On Fri, 5/
Anyone?
--- On Fri, 5/12/08, Glyn Astill <[EMAIL PROTECTED]> wrote:
> From: Glyn Astill <[EMAIL PROTECTED]>
> Subject: [GENERAL] Planner picking topsey turvey plan?
> To: [EMAIL PROTECTED]
> Date: Friday, 5 December, 2008, 2:23 PM
> Hi people,
>
> Does anyo
> From: Carol Walter <[EMAIL PROTECTED]>
> I'm running PostgreSQL version 8.2.10 on Solaris 10.
> How can I lock
> everyone out except the postgres user?
>
Do it in pg_hba.conf
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http:/
> The server only has one superuser, and for some reason he
> decided to
> remove the logon privilege on this user in PgAdmin III. So
> now he has
> lost superuser access to the database server.
>
> Is there some way to override this setting? Or some way to
> trick
> PostgreSQL into creating a ne
> I am also curious as to why an SQL dump from the production
> server would
> come out to 2.8G but a dump of an exact replica on a test
> box would come
> out to 3.0G. What determines the size and makeup of an SQL
> dump?
Why not repeat the dump without any compression then compare them with a f
You need to output it into a directory you have permission to write to.
Either change the permissions on documents, or write it into somewhere
you definately do have permissions (e.g. /tmp/log.sql) and then move it
to the desired location.
- Original Message
From: ria ulfa <[EMAIL PROTEC
Thanks Phillip,
I think the source of my problem was me being dumb and only capturing stdout,
rather than stderr and stdout! I needed the "2>&1" on the end.
- Original Message
> From: Phillip Smith <[EMAIL PROTECTED]>
> To: Glyn Astill <[EMAIL PROTECT
Hi chaps,
I was just wondering if anyone has any clever way of testing their backups
taken with pg_dump on a daily basis?
On a slightly separate note,
I've setup a daily restore onto a staging server that I intend to also use to
test the dumps, at the moment I've just set up a cron job. I'm su
Also check your DEP settings
- Original Message
> From: Scott Marlowe <[EMAIL PROTECTED]>
> To: Kranti K K Parisa™ <[EMAIL PROTECTED]>
> Cc: pgsql-admin@postgresql.org
> Sent: Thursday, 1 May, 2008 4:33:45 PM
> Subject: Re: [ADMIN] Urgent :: PostgreSQL on Vista Home Premium
>
> On Thu, M
Hi people,
I've tried posting on the general list about this, but I never get a
reply, so I'm trying here.
I have a function that is run each time an INSERT, DELETE or UPDATE
happens on a row and log into an audit table.
It is based on the info here:
http://www.alberton.info/postgresql_table_au
Aha.. excellent, thanks Tom!
Sorry, I shall try to RTFM in the future.
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Glyn Astill <[EMAIL PROTECTED]> writes:
> > I've setup a warm standby reading WAL files, however when I try
> to
> > shut it down I get the
Hi people,
I've setup a warm standby reading WAL files, however when I try to
shut it down I get the message "server does not shut down".
Can someone help please, I presume it has something to do with the
server being busy waiting for the next WAL file? What is the correct
way to shut down a serv
I guess a simpler way to say this is; is there a way we can make a
column in postgres to be encrypted but entirely transparent to the
user?
Could we do this with phgcrypto + some form of trigger or view etc?
--- Glyn Astill <[EMAIL PROTECTED]> wrote:
> Hi people,
>
> We nee
Hi people,
We need to encrypt an individual column in a table. I've noticed that
pgcrypto can do this.
However we have one problem, our software runs through a closed
source "connectivity kit" that allows it to use a postgres dbms, so
our programs cant sent an individual sql statement to give the
35 matches
Mail list logo
