Yes!!
I have done this very successfully. I have mounts:
/usr/local/pgsql/data 8Gig slice on Primary IDE-Slave
/usr/local/pgsql/data28Gig slice on Secondary IDE-Master
/usr/local/pgsql/data34Gig slice on Primary IDE-Master
Then I move files from data/base/ to data2/base/ and creat
Hello,
I am using PostgreSQL 7.0.2 on RH 6.2
The DB works smoothly in the past 8 months but until recently, the
system would hang when doing insert or update statements.
When I use
ps aux
I found a lot of processes like
postgres localhost xxx xxx INSERT
postgres localhost xxx
At 07:21 6-6-01, you wrote:
>$dbconn1 = @pg_connect ("host=$dbhost dbname=$dbname user=$dbuser
>password=$dbpasswd");
>
>Edit /usr/local/lib/php.ini and make sure persistent connections is
>turned off.
This will work, as long as the machine is up, but pgsql isn't. However, if the
machine isn
Does PostgreSQL support (or some day will support) "partitioned tables"?
This is a feature currently available in oracle which allows you to
physically separate the data for a table based on values in a set of columns
and attach or remove the files from the table.
While searching for the answer i
"Nick Fankhauser" <[EMAIL PROTECTED]> writes:
> Does PostgreSQL support (or some day will support) "partitioned tables"?
It's not on anyone's radar screen AFAIK.
> Alternately, does anyone have an idea about how to address this need in a
> different way using existing tools?
Make a view that's
I have a sequence that I 'thought' was providing unique numbers but is
not. Is there someway to turn on unique-ness? Should I reload after
adding unique to the sequence? Any other thoughts on digging my way out
of the problem?
Thanks in advance!
--
Dave Stokes
[EMAIL PROTECTED]
817 329 93
On Wed, 6 Jun 2001, Dave Stokes wrote:
> I have a sequence that I 'thought' was providing unique numbers but is
> not. Is there someway to turn on unique-ness? Should I reload after
> adding unique to the sequence? Any other thoughts on digging my way out
> of the problem?
They should prov
Dave Stokes <[EMAIL PROTECTED]> writes:
> I have a sequence that I 'thought' was providing unique numbers but is
> not. Is there someway to turn on unique-ness?
Huh? nextval() should always produce unique values (unless the sequence
wraps around, of course).
regards, t
How did you conclude that it doesn't provide unique numbers? A sequence gives unique
values by definition (unless you allow it to cycle and you actually wrapped around the
2.1billion boundary)
cheers,
thalis
On Wed, 6 Jun 2001, Dave Stokes wrote:
> I have a sequence that I 'thought' was prov
>Huh? nextval() should always produce unique values (unless the sequence
>wraps around, of course).
What about explicitly overruling a sequence by INSERTing a specific value,
when it is not a primary key or defined as serial, but a manual sequence?
Stefan
--
I don't find it hard to meet exp
On Wed, 6 Jun 2001, Tom Lane wrote:
> "Nick Fankhauser" <[EMAIL PROTECTED]> writes:
> > Does PostgreSQL support (or some day will support) "partitioned tables"?
>
> It's not on anyone's radar screen AFAIK.
>
> > Alternately, does anyone have an idea about how to address this need in a
> > diff
11 matches
Mail list logo
