I've got a database which includes large objects. In that past,
for the few times I've used lobjs, I've written a quick script to
handle backups, but this time we've got a slightly more complex
system.
Does anyone have a general-purpose system for backing up dbs
with lobjs, or s
"Dave Cramer" <[EMAIL PROTECTED]> writes:
> When I run VACUUM ANALYZE it fails and all the backend connections are
> closed. Has anyone else run into this problem?
There should be a core dump file from the crashed backend in your
database subdirectory --- can you provide a backtrace from it?
El Mar 23 Ene 2001 12:38, Frank Joerdens escribió:
> I am faced with the task of installing, configuring, and tuning my
> database, which is currently running under Linux, under Solaris 7 on a
> brand-new and shiny Sun UltraSPARC (3 CPUs, 768 MB RAM), because the
> sysadmin at the site hasn't used
> Shouldn't it be possible to build vacuum as an ongoing internal PG
process,
> instead of a seperate operation? How does Oracle byepass this? Must be
some
> way that can be implemented.
Well, here's what it comes down to: Do you want updates to happen
quickly, and vacuum when load is low, or
> With best regards.
> Sanjay.
>
> At 05:53 PM 1/23/01 , Tom Lane wrote:
> >[EMAIL PROTECTED] writes:
> >> - Is 2 minutes a standard time for vacuuming a 500.000 rows table ?
> >> - Can it be reduced ?
> >> - In a far future, what are the problems we can run into not vacuuming
> >> that table ?
Hi,
when I looked at the database-section of my bookstore browsing for the Practi-
cal SQL Handbook I found a book on postgres from Addison Wesley. Is that one
any good (I didn't have the time to look into it).
Konstantin
--
Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: [EMAIL PROTEC
Tom,
Shouldn't it be possible to build vacuum as an ongoing internal PG process,
instead of a seperate operation? How does Oracle byepass this? Must be some
way that can be implemented.
Any pointers to further reading to brush up my theory in this regard please?
IAC, regarding the actual inquir
hi guys
I just realized that this is occuring because of a the absence of a
primary key in the other table.
Thus the copy command exited without any failure notice..
Thanx
Anand
On Wed, Jan 24, 2001 at 12:29:18AM +0530, Anand Raman wrote:
>hi guys
>
>I am having a strange problem with \copy .
hi guys
I am having a strange problem with \copy ..
When i am trying to copy from the a csv file \copy doesnt report any
error and quietly returns to the command prompt..
However when i do a select count(*) from the table it returns no rows.,.
can anyone help me with this..
A sample dialog is
When I run VACUUM ANALYZE it fails and all the backend connections are
closed. Has anyone else run into this problem?
--DC--
Tom Lane <[EMAIL PROTECTED]> writes:
> > sparc_solaris - SUN SPARC on Solaris 2.4, 2.5, 2.5.1
>
> After you build PG and test it, send us a port report, and we'll add
> Solaris 7 to the list of recently tested platforms. That's how it
> works ...
>
We've had client running pgsql 7.0 on Solari
[EMAIL PROTECTED] writes:
> - Is 2 minutes a standard time for vacuuming a 500.000 rows table ?
> - Can it be reduced ?
> - In a far future, what are the problems we can run into not vacuuming
> that table ? We have already seen that after a month, some transactions
> involving where id >= some_
>For one of our customer, we are running a PostgreSQL database on a
> dynamic PHP-driven site. This site has a minimum of 40 visitors at a
> time and must be responsive 24h a day.
And from the bandwidth and hit logs, they cannot determine a time of day
when there are hardly any hits? Possible
Ok, after some more playing, this works.
CREATE FUNCTION invoice_payment() RETURNS OPAQUE AS '
BEGIN
UPDATE invoice_master SET total = total - NEW.amount,updated = now(),
is_paid=(CASE WHEN total::numeric = NEW.amount::numeric THEN TRUE::bool ELSE
FALSE::bool END) WHERE invoice_id = NEW.invoi
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Can someone explain why cname and date from table c gets printed in this
> > query?
>
> Say what?
>
> test=# CREATE TABLE a (id INTEGER, name TEXT, aname TEXT);
> CREATE
> test=# CREATE TABLE b (id INTEGER, name TEXT, bname TEXT);
> CREATE
> test=#
"Mitch Vincent" <[EMAIL PROTECTED]> writes:
> ERROR: Unable to identify an operator '=' for types 'numeric' and 'float8'
> You will have to retype this query using an explicit cast
> --- amount and total are both numeric(9,2),
Hm, then "(total - NEW.amount) = 0.00::numeric" should work,
hi,
i have posgresql 6.4 and jdbc6.4.
i am making a query returning like 6000 registers. I would like to
restrict the query in order to show the result 100 by 100 registers.
how can i make that SQL query?
if i make " select * from files order by (name)";
thanks in advance,
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Can someone explain why cname and date from table c gets printed in this
> query?
Say what?
test=# CREATE TABLE a (id INTEGER, name TEXT, aname TEXT);
CREATE
test=# CREATE TABLE b (id INTEGER, name TEXT, bname TEXT);
CREATE
test=# CREATE TABLE c (id IN
I was wondering if there is a ER diagram of the system tables..
As pgsql doesn't have a command to change the type of a field, I thought
to make a procedure that do that, changing the system tables.
Tks
--
Nelio Alves Pereira Filho
IFX Networks - www.ifx.com.br
+55 11 3365-5863
[EMAIL PROTECTED
> I don't think recovery mode actually does much in 7.0.* --- I think it's
> just a stub (Vadim might know better though). In 7.1 it means the thing
> is replaying the WAL log after a crash. In any case it shouldn't
> create a lockup condition like that.
>
> The only cases I've ever heard of whe
Frank Joerdens <[EMAIL PROTECTED]> writes:
> I am faced with the task of installing, configuring, and tuning my
> database, which is currently running under Linux, under Solaris 7 on a
> brand-new and shiny Sun UltraSPARC (3 CPUs, 768 MB RAM), because the
> sysadmin at the site hasn't used or inst
Interesting idea. I hadn't thought of trying this.
Thanks.
Tim
- Original Message -
From: "Prasanth Kumar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 22, 2001 7:03 PM
Subject: Re: [GENERAL] Data entry screen building utilities
>
> >Rather than writing PostgreSQL
"Mitch Vincent" <[EMAIL PROTECTED]> writes:
> Hmm, this is the third time this has happened.. I am using 7.1 Bert 3, so I
> expected some things like this... When deleting and adding functions back,
> when I run them I get :
> ERROR: plpgsql: cache lookup for proc 49237 failed
> -- What's happe
Hi,
Is it safe to recompile postgres to get support for other procedural
languages going.
I have tried to compile just the languages in the src/interfaces
directory but to no avail.
What is the best way to get them going after you install Postgres.
Thanks
Jeff Meeks
[EMAIL PROTEC
"I haven't looked at it extensively, but is there a reason why you wouldn't
want to use it?"
I was hoping for something that would help me quickly put together some
screens, without extensive coding. I didn't think such a utility existed but
it was worth asking :-)
Tim
- Original Message -
Hello,
For one of our customer, we are running a PostgreSQL database on a
dynamic PHP-driven site. This site has a minimum of 40 visitors at a
time and must be responsive 24h a day.
One of the table has 500.000 rows and is very frequently accessed
(it is the table registering basic user
Thanks for the idea, but like you stated lynx is too crude an interface.
Tim
- Original Message -
From: "Robert B. Easter" <[EMAIL PROTECTED]>
To: "Tim Barnard" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, January 22, 2001 11:07 PM
Subject: Re: [GENERAL] Data entry screen build
Alexander Jerusalem <[EMAIL PROTECTED]> writes:
> you are right, I have the same problem on RedHat. After I inserted -e it
> works so far. But there's something else that seems strange to me I'm not
> quite sure if I'm reading this right since I understand only half of what
> happens in this sc
First, you read the installation instructions. Then, if specific problems
come up you send specific problem reports. But I think we have this
platform pretty much covered. Good luck.
Frank Joerdens writes:
> I am faced with the task of installing, configuring, and tuning my
> database, which
Can someone explain why cname and date from table c gets printed in this
query?
Thanks.
> SELECT * FROM a FULL OUTER JOIN b USING (id)
>
> id | name | aname | name | bname | name | cname |date
> +--++--++--+-+
> 1 | Bob | aname1 |
Ok, it appears now I have an error.. Unless I'm going crazy, this started
after I had to do a restore because of one of those cache lookup errors.. I
changed nothing, still, this is what I get..
CREATE FUNCTION invoice_payment() RETURNS OPAQUE AS '
BEGIN
UPDATE invoice_master SET total = tot
> Bruce Momjian writes:
>
> > Added to TODO:
> >
> > * Remove unused pg_variable table
>
> While you're at it: Remove unused pg_inheritproc and pg_ipl tables.
Added to TODO:
* Remove unused pg_variable, pg_inheritproc, pg_ipl tables
--
Bruce Momjian| h
"Mitch Vincent" <[EMAIL PROTECTED]> writes:
> is_paid is never updated...
It's not possible that is_paid is never updated; that command *will*
replace the total, updated, and is_paid columns with *something*.
It may be that in the cases you've checked, it gets updated to the
same value it had bef
33 matches
Mail list logo
