hi
my postgresql is:
depesz=# select version();
version
---
PostgreSQL 7.2devel on i686-pc-linux-gnu, compiled by GCC 3.0
(1 row)
(compiled from cvs 2 days ago).
int8 are working:
"Susan Lane" <[EMAIL PROTECTED]> writes:
> I ran the script and after it told me that it was creating my sequences, it
> said "Database handle destroyed without explicit disconnect".
That might be normal behavior for that script; I can't tell without an
Oracle installation to try it against, but
Chris <[EMAIL PROTECTED]> writes:
>>> I have a suggestion, as well: I think the PostgreSQL documentatio could
>>> use a section that discusses all the maintenance issues in one place.
>>
>> I agree. Do I hear a volunteer to write it?
> I'd be interested in looking at it.
> Is it just this todo
Hi,
> > I have a suggestion, as well: I think the PostgreSQL documentatio could
> > use a section that discusses all the maintenance issues in one place.
>
>I agree. Do I hear a volunteer to write it?
I'd be interested in looking at it.
Is it just this todo item : Add mention of VACUUM, log rot
On Mon, 6 Aug 2001 11:20:34 +0300, Timo Lehtinen <[EMAIL PROTECTED]> wrote:
> Hello!
>
> I'am very new to linux and postgresql. I just intalled Redhat7.1. and
> downloaded rpms and installed rpms. Now I'am stuck with startin the server
> itself. What do I have to do after I have installed rpms?
> (Is there any good reason for this, btw.? The major vendors [Oracle, SQL
Server, Sybase] support having logfiles (txn, redo, archive) on separate file
systems/devices for reliability and performance.)
>
My understanding is that you _can_ do this, by shutting down the server
moving the file
Lee Harr wrote:
> > (Is there any good reason for this, btw.? The major vendors [Oracle, SQL
> Server, Sybase] support having logfiles (txn, redo, archive) on separate file
> systems/devices for reliability and performance.)
> >
>
> My understanding is that you _can_ do this, by shutting down th
On Mon, 6 Aug 2001, Allan Engelhardt wrote:
> Peter Eisentraut wrote:
>
> > This won't work. You need to be able to write to the medium for a number
> > of reasons.
>
> Is the reason that PostgreSQL must have log files etc. in the same
> directory as the data files (it does not appear to suppo
"Kathi Arthur" <[EMAIL PROTECTED]> writes:
> When I'm connected to template1, \l only shows template1. In the "base" su=
> bdirectory, I do have the template1 subdir as well as the bullprod subdir w=
> ith all the schemas I want.
Perhaps you should explain exactly what you did to get into this s
Len, Tom, et al --
When I'm connected to template1, \l only shows
template1. In the "base" subdirectory, I do have the template1 subdir as
well as the bullprod subdir with all the schemas I want. So what am I
missing to make THAT db part of the system catalog (data dictionary)? I'm
sure
What do you get from "psql -l", or from "select * from pg_database"
after connecting to template1?
regards, tom lane
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Len --
No, the db is actually called "bullprod" -- I just
didn't want to explain the history behind THAT name!
I'll play around with the pg_dumpall but I think I
have bigger problems than that...
Thanks for the hint!
-- Kathi
- Original Message -
From:
Len
Morgan
Please bear with me for a stupid new-user
question. I've tried to solve my problem by looking at the online
documentation, FAQs and archived list servs (all very helpful!). But after
most of the night Friday and most of last night, I still don't get
it...
I have a database that is alread
Andrew Gould <[EMAIL PROTECTED]> writes:
> If a data analyst needed to perform analysis (select
> statements only, no updates, creates, etc) while
> traveling, would it be feasible to put a database on a
> DVD? Could PostgreSQL use it?
Since Postgres just stores its data in Unix files, you can p
Hi!
I have a problem with tables, i think it is a problem for experienced newbies, so i
thought it would not fit with the newbies mailing list, sorry if it was for the newbie
mailing list:
I want to create a table in a table, that means, if i have a row, in that row are many
columns, where on
If a data analyst needed to perform analysis (select
statements only, no updates, creates, etc) while
traveling, would it be feasible to put a database on a
DVD? Could PostgreSQL use it? Does the use of oid's
eliminate such possibilities?
Andrew Gould
__
"Ben-Nes Michael" <[EMAIL PROTECTED]> writes:
> [root@www he_IL]# gdb --core ./base/18729/core
Try mentioning the postgres executable too:
gdb /path/to/postgres /path/to/core
Until you can get us a backtrace that shows some names, not numbers,
there's not a lot we can do.
FWIW, I still
hello,
This weekend I read the User guide front to back. I hadn't done that
since 6.2 or thereabouts...
I have one request for improvement:
In the CREATE DATABASE chapter it may be usefull to include the options
for LATIN1 etc. I was a bit surprized that they weren't there seeing the
internatio
Title: Installing PostgreSQL 7.1.2 on SCO Open Server 5.0.5
Hi,
I tried to compile and install PostgreSQL 7.1.2 on SCO Open Server 5.0.5. Though not stated in doc/FAQ_SCO, it wasn't possible until I disabled shared library support (configure --disable-shared) and changed some lines in src/ba
took time but here it is after recompile with enable-debug
I attached a tex file contain the log and gdb output
[root@www he_IL]# gdb --core ./base/18729/core
GNU gdb 5.0rh-5 Red Hat Linux 7.1
Copyright 2001 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public L
20 matches
Mail list logo
