On Fri, Jun 8, 2012 at 1:30 PM, Lonni J Friedman wrote:
> I've looked at iostat output both before & during pg_basebackup runs,
> and I'm not seeing any indication that the problem is due to disk IO
> bottlenecks. The numbers don't vary very much at all between the good
> & bad times. This is ty
On Sat, Jun 9, 2012 at 4:30 AM, Lonni J Friedman wrote:
> On Thu, Jun 7, 2012 at 11:04 PM, Craig Ringer wrote:
>> On 06/08/2012 09:01 AM, Lonni J Friedman wrote:
>>>
>>> On Thu, Jun 7, 2012 at 5:07 PM, Jerry Sievers
>>> wrote:
You might try stopping pg_basebackup in place with SIGSTOP
Thank you, Kevin, for this detailed info. It was very helpful.
Best wishes,
-igor
-Original Message-
From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov]
Sent: June-06-12 12:39 PM
To: Igor Shmain; pgsql-admin@postgresql.org
Subject: RE: [ADMIN] Data split -- Creating a copy of data
Am 08.06.2012 05:43, schrieb sgm:
Dear admin,
I have a question about PITR backup in a single server, the method is
make a base backup, and backup the WAL archive log(eg, every day at
11:30 pm). But if the OS' harddisk is broken(eg,14:00 pm),the system
can't start, we have to recover the data
On Thu, Jun 7, 2012 at 11:04 PM, Craig Ringer wrote:
> On 06/08/2012 09:01 AM, Lonni J Friedman wrote:
>>
>> On Thu, Jun 7, 2012 at 5:07 PM, Jerry Sievers
>> wrote:
>>>
>>> You might try stopping pg_basebackup in place with SIGSTOP and check
>>>
>>> if problem goes away. SIGCONT and you should
Am 08.06.2012 08:59, schrieb Tom Lane:
"Della-Croce, Gregory" writes:
I am new at the Postgres DBA - Admin stuff. So when asked to create a read
only profile for our database in Postgres 8.4 I did the following:
* create role RO_User password 'xxx' NOSUPERUSER NOCREATEDB
NOC
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.
sgm wrote:
> I have a question about PITR backup in a single server, the method
> is make a base backup, and backup the WAL archive log(eg, every
> day at 11:30 pm). But if the OS' harddisk is broken(eg,14:00
> pm),the system can't start, we have to recover the database on a
> another server usi
Dear admin,
I have a question about PITR backup in a single server, the method is make a
base backup, and backup the WAL archive log(eg, every day at 11:30 pm). But if
the OS' harddisk is broken(eg,14:00 pm),the system can't start, we have to
recover the database on a another server using the ba
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.sql. I also
created a function SHA-256. The function looks like:
CREATE OR RE
"Della-Croce, Gregory" writes:
> I am new at the Postgres DBA - Admin stuff. So when asked to create a read
> only profile for our database in Postgres 8.4 I did the following:
> * create role RO_User password 'xxx' NOSUPERUSER NOCREATEDB
> NOCREATEROLE INHERIT LOGIN;
> *
"Della-Croce, Gregory" writes:
> I am new at the Postgres DBA ó Admin stuff. So when asked to create a read
> only profile for our database in Postgres
> 8.4 I did the following:
>
> · create role RO_User password 'xxx' NOSUPERUSER NOCREATEDB
> NOCREATEROLE INHERIT LOGIN;
>
>
On Fri, 8 Jun 2012 08:29:30 -0400, Della-Croce, Gregory wrote:
The commands worked fine. But when I connected as RO_User and did a
select against a simple table in the DB, I got access denied on the
table.
Check the permissions for that user on the schema public, too.
Jan
--
professional: htt
I am new at the Postgres DBA - Admin stuff. So when asked to create a read
only profile for our database in Postgres 8.4 I did the following:
* create role RO_User password 'xxx' NOSUPERUSER NOCREATEDB
NOCREATEROLE INHERIT LOGIN;
* select 'grant select on ' || tablenam
14 matches
Mail list logo
