Hi
(windows :: pg8.4.4 ::pgadmin 1.10)
in old pc i had 3 different tablespace and each tablespace had one database
Now i dont have old pc ! but i have copy of each tablespace .
now in new pc i have installed the same version PG and need to rergister
this 3 database how can i do it ?
r
Scott Marlowe-2 wrote:
>
> On Wed, May 19, 2010 at 10:38 AM, mnavahan wrote:
>>
I think so. Look up "SECURITY DEFINER"
>>
>> seems goods i need try to it ...
>>
>>
Not that I know of. You're talking connect / disconnect triggers right?
>> YES how do it ?
>
> It's not reall
On Fri, 4 Jun 2010 11:25:55 -0400
RBN wrote:
> Can someone suggest some appropriate initial configuration
> parameters and shared memory settings for the following hardware?
>
> I'm running Debian on a Dell with 4x6 core CPU and 128GB memory and
> writing to a coraid with 9 x 32GB SSDs RAID 10
On Jun 4, 2010, at 13:54 , Gnanakumar wrote:
> In case, if I decide to clean the old WAL archives and set right PITR from
> today onwards by taking base backup, so that I can start managing and
> maintaining atleast from now onwards, what is the correct way/method of
> removing files from pg_xlog/,
Can someone suggest some appropriate initial configuration parameters and
shared memory settings for the following hardware?
I'm running Debian on a Dell with 4x6 core CPU and 128GB memory and writing
to a coraid with 9 x 32GB SSDs RAID 10 using jfs with 8 drives active and 1
as spare.
I'm consi
"Gnanakumar" wrote:
> My pg_xlog/ and walarchive/ directory locations are
> "/usr/local/pgsql/data/pg_xlog" and "/mnt/pitr/walarchive"
> respectively.
>
> In case, if I decide to clean the old WAL archives and set right
> PITR from today onwards by taking base backup, so that I can start
> mana
Hi Florian,
I'm moving this discussion to pgsql-admin. To give a picture of my original
question, it is given below, so that other users in this mailing list will
understand my original problem statement.
> If you point it at a cluster's own pg_xlog directory, it won't work.
> You might want to
