Marion McKelvie [EMAIL PROTECTED] writes:
Many thanks - you're right, the references are stored (by the application
using the database) in a column of type text.
Yuck :-(. A possible solution is to dump the schema and data separately
(schema in a plain text dump, data in an -Fc or -Ft dump
Good idea but I'm not sure if the application will then handle the changed
column type correctly. I'll give it a go and let you know...
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Tom Lane
Sent: 07 April 2004 07:08
To: Marion McKelvie
Cc: [EMAIL
Good news - the restore worked fine with the new column type and the
application worked fine once I'd added a duplicate column of type text. So
at least I have a workable recovery procedure!
Many thanks for your help.
Marion
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
i have a problem adding a user i.e
addusr does not exist in my redhut linux.
thanks in advance.
__
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway
http://promotions.yahoo.com/design_giveaway/
---(end of
At this time, we do not have point in time recovery. That is slated for 7.5 (we
hope). There is also no way to perform incremenatals (yet).
-Original Message-
From: [EMAIL PROTECTED] on behalf of Eric Yum
Sent: Mon 4/5/2004 7:34 PM
To: [EMAIL
Good morning,
I am porting my application from Unix/Linux to Windows (NT, 2000) and need
to use postgres with tcl extension library.
Is there a good location to obtain both/either of these?
The only postgres I found at this point is some beta version, however, it
tells me that it cannot find the
I've been running a postgres for 2 or 3 years without a problem. This
morning my disk space for the database filled up. I need to know what
transaction/log files I can truncate or delete without compromising the
system. These files are located under /var/lib/pgsql/data/
Many of them have dates
On Wednesday, April 07, 2004 1:26 AM Tom Lane wrote:
But to get back to the point of this discussion: to allow PG
to use raw devices instead of filesystems, we'd first have to do a ton of
portability work
...
[The following is said in a low, tentative voice :) ]
I wonder if writing the
mopeace pliz wrote:
i have a problem adding a user i.e
addusr does not exist in my redhut linux.
Try useradd.
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do
Tom Bakken wrote:
I've been running a postgres for 2 or 3 years without a problem.
This morning my disk space for the database filled up. I need to
know what transaction/log files I can truncate or delete without
compromising the system. These files are located under
/var/lib/pgsql/data/
Tom Bakken [EMAIL PROTECTED] writes:
I've been running a postgres for 2 or 3 years without a problem. This
morning my disk space for the database filled up. I need to know what
transaction/log files I can truncate or delete without compromising the
system. These files are located under
I'm running version 7.1.2. I was able to drop several tables. That cleared
up some disk space, but for some reason now, the database won't restart.
How can you determine where the problem is when you're running
/etc/rc.d/init.d/postgresql restart? Any ideas on that would be
appreciated.
I've
Tom,
I'm not finding any mention of CHECKPOINT in my references. Is that
something from a version newer than 7.1.2?
Tom Bakken
Information Resource Manager
Texas USDA, Rural Development
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 07, 2004 12:22
I looked in the pg_log file and it's missing xlogtemp.1091.:
[EMAIL PROTECTED] data]# tail pg_log
DEBUG: Redo record at (1, 516646732); Undo record at (0, 0); Shutdown TRUE
DEBUG: NextTransactionId: 28728439; NextOid: 9098648
FATAL 2: ZeroFill(/var/lib/pgsql/data/pg_xlog/xlogtemp.1033) failed:
Tom Bakken [EMAIL PROTECTED] writes:
I'm not finding any mention of CHECKPOINT in my references. Is that
something from a version newer than 7.1.2?
You're running 7.1.2? My, that *is* an old installation. You really
ought to think about an update, particularly if you might be approaching
the
Tom Bakken [EMAIL PROTECTED] writes:
FATAL 2: ZeroFill(/var/lib/pgsql/data/pg_xlog/xlogtemp.1091) failed: No
such file or directory
/usr/bin/postmaster: Startup proc 1091 exited with status 512 - abort
I'm sure I didn't delete it.
This is just trying to make a new, empty xlog file. I don't
Of course, I was planning to upgrade but as with most things, too little,
too late...
At this point, I just want to keep it running until I can move to my planned
new platform. Can you tell me where to start with CHECKPOINT?
If it's any help, my problem appears to be a missing file. This is
Tom,
Here's the situation:
[EMAIL PROTECTED] init.d]# cd /var/lib/pgsql/data/
[EMAIL PROTECTED] data]# ls -l
total 1494316
-rw---1 postgres postgres4 Jun 21 2001 PG_VERSION
drwx--6 postgres postgres 4096 Sep 17 2003 base
drwx--2 postgres postgres 4096 Oct
Tom Bakken [EMAIL PROTECTED] writes:
Here's the situation:
[EMAIL PROTECTED] init.d]# cd /var/lib/pgsql/data/
[EMAIL PROTECTED] data]# ls -l
total 1494316
-rw---1 postgres postgres4 Jun 21 2001 PG_VERSION
drwx--6 postgres postgres 4096 Sep 17 2003 base
Hi,
we have table having 23 million rows.
This is the table structure.
Table Request:
Column |Type | Modifiers
---+-+---
origindb | character(1)| not null
uid | integer | not
hi all, there is a way to use my own index with pk constraint instead of the
implicitly created one?
why? just because i don't like the name, maybe can i change the generated
name?
thanx in advance,
Jaime Casanova
_
Help STOP SPAM
On Wed, 7 Apr 2004, Jaime Casanova wrote:
hi all, there is a way to use my own index with pk constraint instead of the
implicitly created one?
why? just because i don't like the name, maybe can i change the generated
name?
You should be able use the full version with the constraint naming
hi all, again.
i can't find how can i store bynary fields (images, ¿¿pdfs?? is it
possible?) in postgres. i'm using vb as frontend.
any help??
thanx in advance,
Jaime Casanova
_
Tired of spam? Get advanced junk mail protection
Tom,
Doh!! I created that log file and let it get out of hand.
OK, it's truncated and now I've got plenty of space, but it's still
complaining that it can't find the xlogtemp.1405:
DEBUG: database system was shut down at 2004-04-07 12:14:38 CDT
DEBUG: CheckPoint record at (1, 516646732)
The keyword you want is large objects.
-kaolin fire
-http://erif.org/code/fallingup/
On Apr 7, 2004, at 2:42 PM, Jaime Casanova wrote:
hi all, again.
i can't find how can i store bynary fields (images, ¿¿pdfs?? is it
possible?) in postgres. i'm using vb as frontend.
any help??
thanx in
On Wed, 7 Apr 2004, Hemapriya wrote:
Hi,
we have table having 23 million rows.
This is the table structure.
Table Request:
Column |Type | Modifiers
---+-+---
origindb | character(1)| not null
uid
Tom Bakken [EMAIL PROTECTED] writes:
OK, it's truncated and now I've got plenty of space, but it's still
complaining that it can't find the xlogtemp.1405:
FATAL 2: ZeroFill(/var/lib/pgsql/data/pg_xlog/xlogtemp.1405) failed: No
such file or directory
I think the no such file errno is
sorry if my questions are so primitive or show all my poor knowledge but ask
is the way to find the right path. the dumber the question the smarter i
will become.
_
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
On Wed, Apr 07, 2004 at 14:03:54 -0700,
Hemapriya [EMAIL PROTECTED] wrote:
Indexes:
request_pkey primary key, btree (origindb, uid)
I do max Query like this
select max(uid) from request where originDB=1;
it took around 20 min to return the result.. Since
max, count functions do
Sam Barnett-Cormack [EMAIL PROTECTED] writes:
On Wed, 7 Apr 2004, Hemapriya wrote:
Column |Type | Modifiers
---+-+---
origindb | character(1)| not null
uid | integer | not null
...and on Wed, Apr 07, 2004 at 01:26:02AM -0400, Tom Lane used the keyboard:
After that, we get to implement our own filesystem-equivalent management
of disk space allocation, disk I/O scheduling, etc. Are we really
smarter than all those kernel hackers doing this for a living? I doubt it.
Grega,
Furthermore, this filesystem would be a blazing one stop solution for
all replication issues PostgreSQL currently suffers from, as its main
design goal was to present a consistent file system image across the
servers in a cluster.
Does it work, though? Without Oracle admin tools?
On Wed, Apr 07, 2004 at 09:09:16AM -0700, Josh Berkus wrote:
If your intention in this test is to show the superiority of raw devices, let
me give you a reality check: barring some major corporate backing getting
involved, we can't possibly implement our own PG-FS for database support. We
...and on Wed, Apr 07, 2004 at 09:09:16AM -0700, Josh Berkus used the keyboard:
Does it work, though? Without Oracle admin tools?
Hello, Josh. :)
Well, as I said, that's why I was asking - I'm willing to give it a go
if nobody can prove me wrong. :)
Now, if both goals can be achieved in
34 matches
Mail list logo