This thread belongs on the pg_reorg mailing list, so I am moving it there.
On Tue, Nov 27, 2012 at 10:37 PM, suhas.basavaraj12 wrote:
> Hi,
>
> Found a peculiar issue with reorg_trigger on one of the important table
> in the db.
>
> SELECT>ERROR: must be superuser to use reorg_trigger functi
On Thu, Jun 7, 2012 at 8:12 AM, ROMAIN, ERICKA W CTR DISA PEO-MA
wrote:
> I am trying to get Postgres to use SHA as the password hash algorithm instead
> of MD5. This is a security requirement. I am running PostgreSQL 8.4 on a Red
> Hat Linux platform. I have installed pgcrypto and ran pgcrypto.
On Wed, Oct 13, 2010 at 4:53 AM, Joy Martin Omello
wrote:
> Hi
>
> I have a system running postgresql that I have installed on two different
> servers. My challenge is that I need another server that I can install the
> same system but to be in position to combine the three different but similar
>
On Thu, Oct 7, 2010 at 11:42 PM, Andreas wrote:
> Hi,
>
> I just recently activated the system objects in pgAdmin.
> Now I'm wondering if it's normal to have 5 pg_toast_temp and 5 pg_temp
> schemas.
>
> It's a PG 8.4.0 server of the OpenSuse distribution that works pretty well.
It's normal to ha
On Mon, Apr 19, 2010 at 11:52 AM, Sergey Konoplev wrote:
> On 19 April 2010 15:27, Steph L wrote:
>> How to disconnect a single user in Postgresql 8.2.5 from a database ?
> AFAIK the only way is to upgrade to 8.4 and use pg_terminate_backend():
> http://www.postgresql.org/docs/8.4/interactive/fun
On Feb 12, 2010, at 4:58 AM, Renato Oliveira wrote:
> Dear all,
>
> I have a server running 8.2.4 and has a database 170GB in size.
> Currently I am backing it up using pg_dump and it takes around 28 hours,
> sadly.
That's suspiciously slow for a pg_dump alone. I have a ~168 GB database which
at 11:03 AM, Josh Kupershmidt wrote:
> On Wed, Feb 10, 2010 at 10:30 AM, Iñigo Martinez Lasala <
> imarti...@vectorsf.com> wrote:
>
>> H...
>>
>> What about
>> UPDATE pg_trigger SET tgenabled = false;
>>
>> Restore data, and after done:
>>
[Resending, forgot to CC list]
On Wed, Feb 10, 2010 at 10:47 AM, Josh Kupershmidt wrote:
>
> On Wed, Feb 10, 2010 at 10:09 AM, Iñigo Martinez Lasala <
> imarti...@vectorsf.com> wrote:
>
>> Two questions.
>>
>> I could, of course, create a data-only d
On Feb 10, 2010, at 4:30 AM, Iñigo Martinez Lasala wrote:
>
> Third one, and we haven't been able to fix it, is we cannot restore data dump
> via psql due to psql does not have an option to disable triggers. So, when
> restoring data, it fails. So... is there any way to disable in a psql sessio
I'd like a way to allow non-superusers to cancel their own queries.
Wearing a DBA hat sometimes, I get requests from users asking that their
long-running or erroneous queries be killed. These users have typically
executed their queries through phpPgAdmin or some other method that doesn't
allow the
10 matches
Mail list logo
