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 "psq
No, pg_ident.conf is empty (i.e. contains only comments). My impression was
that with "trust" nothing was needed in pg_ident.conf, no?
Thanks
--- Andy Shellam <[EMAIL PROTECTED]> wrote:
> Does your pg_ident.conf contain anything with reference to testusr? As it
> seems to be trying Ident authe
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 p
--- 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
"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 yo
--- 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:~# /usr/lib/postgr
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
_
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 bro
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 fr
--- 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
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
http://antispam.yahoo.
--- 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 t
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 Addres
--- 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).
--- 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 y
--- 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 db
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 not
--- 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 (
--- 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 ne
--- 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
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 S
--- 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 crea
--- 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
--- 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, tha
--- 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 fie
--- Stephan Szabo <[EMAIL PROTECTED]> wrote:
>
> I assume you're also not modifying the pktable rows (since that would
> access the fk table based solely on the fk).
I do modify the fk table: inserts and updates (but pk is never updated). Also
do not delete records.
> Does the multi-field index
--- 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 menti
--- 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 th
--- 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
___
--- 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
--- 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)---
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
" but got ": not in compressed format" error.
Thanks
__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
h
--- 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
> " but got ": not in compressed format" error.
>
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
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
loc
--- 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 /va
--- 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 woul
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
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/
-
> IDE software RAID helps with reliability, but it's murder on performance.
Maybe you provide some conclusive performance data to support this claim.
__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
---(end
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 affe
43 matches
Mail list logo
