Hi,
Is it somehow possible to create a UNIQUE constraint that relies on non-unique
ONE-column indexes and uses index-combination feature in 8.1 ?
The alternative, which we use now, is to create a unique MULTI-column index on
the respective coulumns.
Thanks
PostgreSQL 8.1.0 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.0.3 2005
(prerelease) (Debian 4.0.2-4)
Hi,
Am having some doubts whether a new db should be with SQL_ASCII or UTF-8
encoding. We expect ALL of our data to be ASCII. At the same time, I guess,
it's possible that some user may
--- Tom Lane [EMAIL PROTECTED] wrote:
ow [EMAIL PROTECTED] writes:
Are there any negative effects related to the selection of UTF-8 over
SQL_ASCII
There will be a speed penalty; whether it's significant in your
application is something you can only determine by experiment.
I see
--- Tom Lane [EMAIL PROTECTED] wrote:
It seems risky, but you could probably get away with that as long
as the database locale (LC_COLLATE/LC_CTYPE) is C ... which is really
the only one that's safe with SQL_ASCII anyway ...
I actually created the cluster with:
test1:~#
PostgreSQL 8.1.0 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.0.3 2005
(prerelease) (Debian 4.0.2-4)
Hi,
Can't get pg_hba.conf with trust to work:
[EMAIL PROTECTED]:~$ psql -U postgres
psql: FATAL: Ident authentication failed for user postgres
If I do su postgres and then psql -U
In postgresql.conf I have #listen_addresses = 'localhost' and I am logged in
directly into the box, without telnet, ssh or whatever.
But psql -U postgres -h localhost DID WORK (after I entered the password) and
that's a big step forward, thanks.
I'm still not sure why I needed to enter the
--- Stephan Szabo [EMAIL PROTECTED] wrote:
Are you sure you're using the configuration below (ie, you're editing the
I was sure... :-)
correct file and have at least used sighup after the change)? It sure
looks like the server thinks the method is ident which would be the
default for the
pg 7.4.2 on RH 7.3
Hi,
Am getting Out of memory error and pgSql is getting killed when running the
following statement in psql:
insert into tableA
select * from tableB
where testdate = '2000-01-01' and testdate = '2002-12-31'
TableB contains about 120 million records. The insert/select affects
pgSql 7.4.0
Hi,
If a *schema* is dumped and then restored on a different server, will it be
necessary to also restore system schemas, e.g. pg_catalog?
Thanks
__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
pgSql 7.4.0
Hi,
Suppose, there are two (2) schemas in the database: schemaA and schemaB.
schemaA is relatively small and updated all the time, schemaB is huge and
updated occasionally, maybe several times a day. The whole database, with
schemaA and schemaB, is dumped once a week, say Sunday, and
pgSql 7.4.0 on RH7.3
Hi,
It appears that pgSql somehow logs messages to BOTH /var/log/messages and
/var/log/pgsql. I expected that it would only log to /var/log/pgsql.
Any ideas? Thanks
-
/etc/syslog.conf
# Save postgresql logs
--- ow [EMAIL PROTECTED] wrote:
pgSql 7.4.0 on RH7.3
Hi,
It appears that pgSql somehow logs messages to BOTH /var/log/messages and
/var/log/pgsql. I expected that it would only log to /var/log/pgsql.
It appears I forgot to add local0.none on the /var/log/messages line in
/etc
--- Tom Lane [EMAIL PROTECTED] wrote:
Actually you can only have 4 billion SQL commands per xid, because the
CommandId datatype is also just 32 bits. I've never heard of anyone
running into that limit, though.
Perhaps noone yet had a table with 4B records in pgSql. Otherwise, how would
Hi,
Hypothetical situation: a table containing, say, 10 billion rows is backed up
and then restored with pg_restore. Would this lead to the transaction id
wraparound issue since 10B rows are imported in one batch?
Thanks
__
Do you Yahoo!?
Free Pop-Up Blocker
--- ow [EMAIL PROTECTED] wrote:
Hi,
Is there a way to uncompress (for the purpose of editting) a pg_dump file
created with --format=c --compress=6 options? Tried the obvious uncompress
fileName but got fileName: not in compressed format error.
Never mind, it's pg_restore -f fileName
--- Ivan [EMAIL PROTECTED] wrote:
Over MySQL as I used it until now.
What are your issues with mySql?
__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
---(end of broadcast)---
--- Bruce Momjian [EMAIL PROTECTED] wrote:
ow wrote:
--- Bruce Momjian [EMAIL PROTECTED] wrote:
Yep, we want to do something, but not sure what. We have:
* Allow triggers to be disabled [trigger]
I think the following should be added to the Allow triggers
--- Rudi Starcevic wrote:
I'm not trying to upset anyone just trying to help you get an answer for your
issues.
Who knows what you're trying to do? You did not provide any answers and why you
decided to quote the *same* email *twice* if it was sent only *once* I may
never know.
Anyway,
--- Jeff [EMAIL PROTECTED] wrote:
On Mon, 17 Nov 2003 10:40:20 -0800 (PST)
Stephan Szabo [EMAIL PROTECTED] wrote:
By the way, what does your schema look like? I created an 80M row fk
table and 20K row pk table with an int4 key between them and indexes on
the two key fields. It took
--- Stephan Szabo [EMAIL PROTECTED] wrote:
Well, I've been trying to deal with the particular case at hand, ie, get
your load in a more reasonable amount of time assuming that you had more
constraints and this was going to be a particular problem for you in the
immediate term. I've mentioned
--- Stephan Szabo [EMAIL PROTECTED] wrote:
Like I said, it's been discussed and I would expect some form of this for
7.5 although I can't say for certain. Enough people were interested in
the discussion that it's likely to happen with a little championing.
Does not appear like it's on the
--- Bruce Momjian [EMAIL PROTECTED] wrote:
Yep, we want to do something, but not sure what. We have:
* Allow triggers to be disabled [trigger]
Will ppl remember some time from now that it also deals with FK constraints and
pg_restore/dump options?
Thanks
pgSql 7.4.rc2
--- Peter Eisentraut [EMAIL PROTECTED] wrote:
If you you pg_dump and dump schema and data together, then there is some
magic to temporarily disable foreign key constraints. Try it out.
Dunno. Don't see any magic so far. In fact, pg_restore appears to use
internally the same SQL
--- Peter [EMAIL PROTECTED] wrote:
Read again. No one was talking of pg_restore.
Perhaps I should clarify.
First, I ran pg_dump to extract schema and data *together*. Then I ran
pg_restore to restore the db. It took about 1 hour to create tables and copy
the data, then about 40 min to create
--- Stephan Szabo [EMAIL PROTECTED] wrote:
Only assuming that no changes were made between dump and restore. This
could be changes to schema or data done manually, but it could also be a
locale or possibly encoding change if you have any textual foreign keys.
I'm restoring the database,
--- ow [EMAIL PROTECTED] wrote:
Perhaps I should clarify.
First, I ran pg_dump to extract schema and data *together*. Then I ran
pg_restore to restore the db. It took about 1 hour to create tables and copy
the data, then about 40 min to create indexes, then pg_restore spent 4.5
hours
--- Peter Eisentraut [EMAIL PROTECTED] wrote:
If you you pg_dump and dump schema and data together, then there is some
magic to temporarily disable foreign key constraints. Try it out.
Perhaps you can adopt the statements to your particular restoration method
as well, if it turns out
--- James Rogers [EMAIL PROTECTED] wrote:
I've just received the okay to purchase maxed out SMP Opteron servers
with Fiber Channel storage arrays to run Postgres, and those will be
Linux with XFS file systems as well.
Any particular brand of the storage array you'd recommend? Thanks
--- Bruce Momjian [EMAIL PROTECTED] wrote:
Rather than restart the server (kicking everyone out), does 'reload'
help to keep new users out and let the old ones leave on their own?
Not really ... users (old or new) should not work with the db unless it's
completely loaded. Restarting the
Hi,
It appears that pgSql can be configured to log the executed statements.
However, the log does not appear to contain any info about who's running the
statement. Any way to change this?
Thanks
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail
--- Oli Sennhauser [EMAIL PROTECTED] wrote:
What about having two database clusters on a server for separating HA
from not so HA databases? You can take down one db cluster. And people
can still work on the other one (DB Cluster does nothing has to do with
hardware or os cluster).
There's
--- Bruce Momjian [EMAIL PROTECTED] wrote:
You can restrict pg_hba.conf to not allow connections just to one
database if you want.
True, but that still would not prevent users who are already connected from
accessing the db, would it?
Thanks
__
Do you
--- Bruce Momjian [EMAIL PROTECTED] wrote:
No, I guess that is the problem. You can use restart, which will kick
everyone out, or you can use reload, but that doesn't kick people out of
the single database you want.
Restarting the db server triggers the whole chain of events: other dbs are
pgSql 7.4.rc2
Hi,
Am somewhat lost about how one should use pg_restore with large dbs. For
simplicity, let's assume that db has only one (1) table with huge amout of
rows. Tried several approaches:
1) dump the data only, create the table with all indexes and constraints (from
script that has
--- Peter Eisentraut [EMAIL PROTECTED] wrote:
ow writes:
1) dump the data only, create the table with all indexes and constraints
(from
script that has nothing to do with pg_restore), import the data. The import
part was running for hours (14+) with no end in sight. Had to kill
Hi,
Trying to restore a table that has about 80 million records. The database was
dumped and restored according to the following procedure:
1) dump the db, data only
time /usr/local/pgsql/bin/pg_dump -abf ./pgsql.7.4.rc1.pgdump.Z --format=c
--compress=6 -U postgres testdb
2) create db schema
--- ow [EMAIL PROTECTED] wrote:
Hi,
Trying to restore a table that has about 80 million records. The database was
[...]
I meant pg7.4.rc2, of course. Thanks
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http
Hi,
Is there a way to take the database offline to keep users out?
Is there a way to take the database offline but still allowing pg_restore to
run against it?
Thanks
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
pgSql 7.4.rc1
Hi,
Is there a way to force VACUUME VERBOSE to show timestamp for each entry it
writes ?
Thanks
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
---(end of
39 matches
Mail list logo
