We had an out of space problem that affected the 7.3.1 server we are running.
Some tables in various databases were being restored and there are
continuously running processes that insert data into several tables fairly
often. We have 30+ databases on this server.
My question is this: how do I f
http://techdocs.postgresql.org/oresources.php
look under Administration Tools and ERD tools.
Robert Treat
On Wed, 2003-02-05 at 01:42, [EMAIL PROTECTED] wrote:
> Hi,
>
> We are using postgresql for linux for the past 1 and half yr.
> Our database gets increasing in no. of tables, datas ...etc
On Mon, 3 Feb 2003, Donny Drummonds wrote:
> If I do not index the column from the where clause the query returns
> the 150,000 rows in 4 and a half minutes. If in do index the column
> from the where clause using a btree the 150,000 rows return in 11 and
> a half minutes.
>
> Any insight would be
thanks Geoffrey for posting the observation.
I hope you will soon find the answer to your
question on investigation.
regds
mallah.
On Thursday 06 February 2003 09:27 pm, Geoffrey Wossum wrote:
> On Thursday 06 February 2003 06:31 am, Rajesh Kumar Mallah wrote:
> > In my case the message "Inva
If I understand correctly, you should be able to copy the files directly if
the database is shut down (completely stopped, not just idle).
But have you considered running pg_dump from your other machine? As long as
you set postgresql to accept remote connections and pg_hba.conf allows them
from
Ian Burrell <[EMAIL PROTECTED]> writes:
> I just recreated the problem with a slightly different command. The
> problem was caused by using a list file to skip loading some function
> definitions that were causing problems. The command that loaded
> everything into template1 was:
> pg_restore
> "Geoffrey" == Geoffrey Wossum <[EMAIL PROTECTED]> writes:
Geoffrey> Hi all, I have a database cluster running on PostgreSQL
Geoffrey> 7.1.3 compiled from source, on Debian Linux. I want to
Geoffrey> upgrade the cluster to PostgreSQL 7.3.x.
Geoffrey> In order to get the data over, I ran: PGU
I am running a dual athlon 1800 with an gig of ram. I am running postgres
7.2. I have a table that hs 15 million rows. I have a query that has one
columns and the select cluase and one column in the where clause with no
joining or sub-queries. If I do not index the column from the where clause
Hi Tom,
sorry for not replying for so long. LC_ALL is set to 'en_us'. We finally got
it to run by setting LC_MESSAGES to 'C'. But since we will have to redo this
we'll try -d then.
thanks a lot
Gerd
.
"Tom Lane" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> "
Hi,
I am new to PostgreSQL. I am running PostgreSQL on top of Cygwin on Windows
NT.
I am able to initialize the database cluster and create template1. I log in
and even create a 'test' table.
But querying it results in the error.
ERROR: pg_class_aclcheck: invalid user id 1730
Someone please help
Tom,
User was able to recreate the problem, but this time only on table got
duplicated 'gui_config'. So here is the info you wanted:
select ctid,xmin,xmax,oid,* from pg_class where relname = 'gui_config';
ctid | xmin | xmax | oid | relname | reltype | relowner | relam |
relfilenode | relp
You are correct someone had rebuilt pg_dump, psql and postmaster without
encryption, but forgot to do pg_restore as they thought we would only be
using psql for restoring databases. Sorry about that.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 02, 20
Hi
I try install postgresql-7.3.1 in win2000,I don't
know where
I can start, I'm very confuse with the install
instruction for windows,pls help me
cheers
jim
Sorry, the owner of the database decided to reload the database and we have
lost the duplicate entries. If it happens again I will send you the info.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 01, 2003 12:42 PM
To: Chris White
Cc: [EMAIL PROTECTED
> Reading between the lines of the error message, it looks to me like
> meiway.com's mail server is programmed to take the MAIL FROM address,
> connect back to the sending server
Wrong, but it's an understandable error when firing from the hip with head
up the ass.
The attempt to deliver is m
Hi,
We are using postgresql for linux for the past 1
and half yr.
Our database gets increasing in no. of tables,
datas ...etc.
We want to manage the postgresql database using
some freeware management tool.
So that I can create, delete tables and add datas
and all the other management activ
Dear list:
I need to move all databases from one fiscal server to other,
but, the
main problem I have is: I can't dump databases, for internal problems
from hdd. My question is, so, how can rescue all databases in 'cp
command' way in posgresql version 7.0 ?
Needing to know:
Hi, in 7.3 this changed.
type :
CREATE DOMAIN lo AS oid;
And everything works well.
Daniel
<[EMAIL PROTECTED]> schrieb im Newsbeitrag
OF0B8A93EA.20F6C498-ON65256CC3.0043C73A@LocalDomain">news:OF0B8A93EA.20F6C498-ON65256CC3.0043C73A@LocalDomain...
> Hi,
> I need to create a large object - a p
Hi ,
While installing Postgres-libs- 7.3.1
binaries on RedHat 8.0 , I get a dependency
problem.
RPM reports dependency error
postgresql-libs=7.2.2 required .
So I installed the Postgresql-libs-7.2.2 (as
RPM wants) and I still get the same error even though the libs are on the
sy
Hey,
I want to use the word group as a
table field name.
It's a reserved word, I
guess.
Is there any way I can comment it,
or adjust it, so that I can use the word.
Thanks
Gareth KirwanProgramming & Development,Thermeon Europe
Ltd,[EMAIL PROTECTED]
Tel: +44 (0) 129
Ignore me - just use quotation marks
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Gareth
KirwanSent: 06 February 2003 10:24To:
[EMAIL PROTECTED]Subject: [ADMIN] Reserved
words
Hey,
I want to use the word group as a
table
Hi,
I saw I can define a table that specifies a ON UPDATE CASCADE for a Foreign Key.
I have a lot of tables with FK´s, and a lot of others with others FK's for the firts
ones, and so on, and I haven´t defined the ON CASCADE clause on the FK´s tables.
Now I need to update a primary key on the "m
Hmmm I face the same problem and it got solved.
In my case the message "Invalid command \N" was coming
during COPY command execution when some other SQL command had
failed prior to COPY execution. ie the COPY command and data
in that part were perfectly fine.
how i came to know abt it was by r
Hi,
restoration with -d -D are extremely slow unless you enclose
em in a transaction block.
could you please redirect the error while restoring from "COPY"
version of dump and post your observation.
regds
mallah.
On Thursday 06 February 2003 01:09 am, Geoffrey Wossum wrote:
> -- Fo
"Yudha Setiawan" <[EMAIL PROTECTED]> writes:
> Somebody please give me more explanation about=20
> using "Update" syntax with cursor. I've seen this
> on manual of postgre(sql-update.html). Here it is
> the example;
> UPDATE table SET column =3D expression [, ...]
>WHERE CURRENT OF
On Wed, 2003-02-05 at 15:04, Matias Monteverde wrote:
> Dear list:
>
> I need to move all databases from one fiscal server to other,
> but, the
> main problem I have is: I can't dump databases, for internal problems
> from hdd. My question is, so, how can rescue all databases in 'cp
> com
On Thu, 2003-02-06 at 07:22, [EMAIL PROTECTED] wrote:
> Hi,
>
> I saw I can define a table that specifies a ON UPDATE CASCADE for a Foreign Key.
>
> I have a lot of tables with FK´s, and a lot of others with others FK's for the firts
>ones, and so on, and I haven´t defined the ON CASCADE clause
"Chris White" <[EMAIL PROTECTED]> writes:
> User was able to recreate the problem, but this time only on table got
> duplicated 'gui_config'. So here is the info you wanted:
> select ctid,xmin,xmax,oid,* from pg_class where relname = 'gui_config';
> ctid | xmin | xmax | oid | relname | rel
On Thursday 06 February 2003 06:31 am, Rajesh Kumar Mallah wrote:
> In my case the message "Invalid command \N" was coming
> during COPY command execution when some other SQL command had
> failed prior to COPY execution. ie the COPY command and data
> in that part were perfectly fine.
Ah, found m
Geoffrey Wossum <[EMAIL PROTECTED]> writes:
> Apparently PostgreSQL 7.1.3 didn't really enforce the length on VARCHAR(#)'s,
> which is why this never caused a problem with it.
Well, it did, but it did silent truncation instead of complaining.
This was determined to be not spec compliant ...
> Now
On Mon, 3 Feb 2003, Donny Drummonds wrote:
> I am running a dual athlon 1800 with an gig of ram. I am running postgres
> 7.2. I have a table that hs 15 million rows. I have a query that has one
> columns and the select cluase and one column in the where clause with no
> joining or sub-queries.
David Gilbert <[EMAIL PROTECTED]> writes:
> I find that the whole database dumps do not have 'create user' and
> 'create group' commands.
Those are dumped by pg_dumpall, but not by pg_dump. Since users and
groups span all databases in an installation, it wouldn't be very useful
for pg_dump to inc
"GB" <[EMAIL PROTECTED]> writes:
> sorry for not replying for so long. LC_ALL is set to 'en_us'. We finally got
> it to run by setting LC_MESSAGES to 'C'. But since we will have to redo this
> we'll try -d then.
You can easily experiment with initdb without having to reset your existing
database.
Matias Monteverde <[EMAIL PROTECTED]> writes:
> main problem I have is: I can't dump databases, for internal problems
> from hdd. My question is, so, how can rescue all databases in 'cp
> command' way in posgresql version 7.0 ?
If the data is so messed up that pg_dump doesn't work, I really doubt
34 matches
Mail list logo
