Unix Technical Forum

Question about multi-volume prostrct add V8.3

This is a discussion on Question about multi-volume prostrct add V8.3 within the pgsql Databases forums, part of the PostgreSQL category; --> Hello, running Progress V8.3C11 under SCO Unix OSR5.0x, multi-volume databases. I defined a database_name.st file with 5 fixed volume ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Databases

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-10-2008, 12:39 AM
=?ISO-8859-1?Q?Fr=E9d=E9ric_STOCK?=
 
Posts: n/a
Default Question about multi-volume prostrct add V8.3

Hello,

running Progress V8.3C11 under SCO Unix OSR5.0x, multi-volume databases.
I defined a database_name.st file with 5 fixed volume (500000 blks) and
1 variable volume.
when I'll see the variable volume begins to grow, I'd like to add some
volumes.
Qu: do I'll have to fix the size of the 6th volume to its actual size,
or could I fix it to 500000 blks ?
and add a new variable volume in all cases.

Thank's.
F. STOCK

--
****************
Enlever ".remove-me" dans l'adresse.
Remove ".remove-me" from e-mail.
****************
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-10-2008, 12:39 AM
cecsno
 
Posts: n/a
Default Re: Question about multi-volume prostrct add V8.3


=?ISO-8859-1?Q?Fr=E9d=E9ric_STOCK?= Wrote:
> Hello
>
> running Progress V8.3C11 under SCO Unix OSR5.0x, multi-volum
> databases
> I defined a database_name.st file with 5 fixed volume (500000 blks
> an
> 1 variable volume
> when I'll see the variable volume begins to grow, I'd like to ad
> som
> volumes
> Qu: do I'll have to fix the size of the 6th volume to its actua
> size
> or could I fix it to 500000 blks
> and add a new variable volume in all cases
>
> Thank's
> F. STOC
>
> -
> ***************
> Enlever ".remove-me" dans l'adresse
> Remove ".remove-me" from e-mail
> ****************

When adding an extent, the variable exting will be fixed at its curren
size. To get around this, create a new .st file with your desire
layout. Backup you database with the probkup utility, delete th
existing db and do a prostrct create from the new .st file. Then do
prorest

--
cecsn
-----------------------------------------------------------------------
cecsno's Profile: http://www.progresstalk.com/member.p...nfo&userid=423
View this thread: http://www.progresstalk.com/showthre...?threadid=7196

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-10-2008, 12:39 AM
=?ISO-8859-1?Q?Fr=E9d=E9ric_STOCK?=
 
Posts: n/a
Default Thank's (Was: Question about multi-volume prostrct add V8.3)

Hello,

thank's .

F. STOCK


cecsno a écrit :

>=?ISO-8859-1?Q?Fr=E9d=E9ric_STOCK?= Wrote:
>
>
>>Hello,
>>
>>running Progress V8.3C11 under SCO Unix OSR5.0x, multi-volume
>>databases.
>>I defined a database_name.st file with 5 fixed volume (500000 blks)
>>and
>>1 variable volume.
>>when I'll see the variable volume begins to grow, I'd like to add
>>some
>>volumes.
>>Qu: do I'll have to fix the size of the 6th volume to its actual
>>size,
>>or could I fix it to 500000 blks ?
>>and add a new variable volume in all cases.
>>
>>Thank's.
>>F. STOCK
>>
>>--
>>****************
>>Enlever ".remove-me" dans l'adresse.
>>Remove ".remove-me" from e-mail.
>>****************
>>
>>

>When adding an extent, the variable exting will be fixed at its current
>size. To get around this, create a new .st file with your desired
>layout. Backup you database with the probkup utility, delete the
>existing db and do a prostrct create from the new .st file. Then do a
>prorest.
>
>
>
>


--
****************
Enlever ".remove-me" dans l'adresse.
Remove ".remove-me" from e-mail.
****************
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 07:56 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com