From: "Joshua D. Drake" <[EMAIL PROTECTED]>
To: Jim Nasby <[EMAIL PROTECTED]>
CC: Sally Sally <[EMAIL PROTECTED]>, pgsql-general@postgresql.org
Subject: Re: [GENERAL] Unable to connect to a dabase
Date: Fri, 13 Jan 2006 16:02:11 -0800
LOG: database system was shut
I'm sorry that was not intentional.
From: "Jim C. Nasby" <[EMAIL PROTECTED]>
To: Sally Sally <[EMAIL PROTECTED]>
CC: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Unable to connect to a dabase
Date: Fri, 13 Jan 2006 16:55:16 -0600
Please don't hijack t
I had to kill a vacuum in the middle with -9. I shut down and restarted the
postgres server several times after that but I am unable to connect to the
db that I was initially running vacuum on
I'm doing "psql dbname" and it hangs for a while. I'm still waiting. Any
ideas?
Thanks
Does postgres automatically keep track of when a row was last modified?
Thanks
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Using perl DBI I recently read that if autocommit is turned on, it does a
commit after every transaction. I wanted to confirm if this also applies to
select statements.
When I'm loading data, I need to do a select before inserting a new row and
I don't want to commit after the select because it'
I am trying to figure out how I can change the default operator class of the
index created for my primary key field. Is it even possible since I am not
able to find the syntax?
Or do I need to create the primary key and then an additional index with the
operator class I want. (It would be a wast
After running for more than 24 hrs (I have a large db), vacuum failed with
this message:
ERROR: failed to re-find parent key in "pg_type_typname_nsp_index"
Has anybody encountered this before?
Thanks much
Sally
_
Check out Election
I think the same too but sometimes it seems in the real world performance is
given more value than a properly designed db. Or the long term flexiblity is
not taken into account given the short term requirements.
regards
Sally
From: Bruno Wolff III <[EMAIL PROTECTED]>
To: Sally Sally &
Dawid,
I am interested in the first point you made that:
having varchar(12) in every referencing table, takes more storage
space.
The thing is though, if I have a serial primary key then it would be an
additional column. Or you are saying the space taken by a VARCHAR(12) field
is more than two IN
Can you please elaborate on the point you just made as to why the primary
key should not relate to the data (even for a case when there is an existing
unique field that can be used to identify the record)
From: "Joshua D. Drake" <[EMAIL PROTECTED]>
To: Sally Sally <[EMAIL PRO
Hi all,
I am wandering about the pros and cons of creating a separate serial field
for a primary key when I already have a single unique field. This existing
unique field will have to be a character of fixed length (VARCHAR(12))
because although it's a numeric value there will be leading zeroes.
I was wandering how I can add a user to a specific db. There are several
databases but I want to add the user to only one of them. It seems when I
add a new user, it is entered in the pg_user table and I can log in to any
one of the other dbs (ofcourse I won't be able to do anything until I gran
I want to dump a database containing about five tables, each containing
about 25 million records. I wanted to run pg_restore per table all at the
same time. Would this have any undesirable consequences. I tried it on a
smaller database and it seems to work fine.
Let me know your thoughts ASAP
Th
When I try to connect to a remote server using DBI I get an error " expected
authentication request from server, but received S"
Has anyone encountered this? I am not quite sure what it is refering to?
Sally
_
Is your PC infected? Ge
Thank you all for replying. I appreciate the tips. Apologies to those who
were offended by the html formating.
Scott, quick question. The reason I assumed insert would be "safer" than
copy is because the docs say that in the case of copy it fails on a single
corrupted row whereas insert won't?
S
I had a few questions concerning the backup/restore process for pg.
1) Is it possible to dump data onto an existing database that contains data (assumning the schema of both are the same). Has anyone done this? I am thinking of this in order to expediate the data load process
2) I read that wh
16 matches
Mail list logo
