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 PROTECT
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 PRO
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 broadcast)-
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 PROTECTED]
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 th
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 d
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/dat
"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 und
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 go
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 P
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 approachin
"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.
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 fro
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 null
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 w
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 wi
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)
DEBUG
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 adva
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 nul
"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 i
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*.
http://j
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
Sam Barnett-Cormack <[EMAIL PROTECTED]> writes:
> On Wed, 7 Apr 2004, Hemapriya wrote:
>> Column |Type | Modifiers
>> ---+-+---
>> origindb | character(1)| not null
>> uid | integer | no
Dear Group,
Thanks for all your support to my previous
postings. I am currently using Postgresql 7.3.4-2PGDG. The problem I
am facing is that when I take a dump of the DB using pg_dump and restore
it using the cat pg_dump_file |psql dbname, I find that some views and
funct
...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 i
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 tool
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
34 matches
Mail list logo
