into an application server environment is
necessarily a bad thing.
Best Wishes,
Chris Travers
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
possible to do a heck of
a lot in this area in SQL and PLPGSQL. Focus on writing unified,
maintainable queries and semantically meaningful interfaces (argument
names, function names, etc).
Best Wishes,
Chris Travers
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes
and
then shutting down the database.
If you su postgres, can you run pg_ctl and get the database up by itself?
Best Wishes,
Chris Travers
Metatron Technology Consulting
begin:vcard
fn:Chris Travers
n:Travers;Chris
email;internet:[EMAIL PROTECTED]
tel;work:509-888-0220
tel;cell:509-630-7794
x
Wishes,
Chris Travers
Metatron Technology Consulting
lmyho wrote:
Perhaps I wasn't clear.
.
With identd authentication a username is still specified. But you have
to own the process to login with that username. So generally speaking
(absent sudo and the like) you can generally login
Tom Lane wrote:
Chris Travers [EMAIL PROTECTED] writes:
Things to check when PostgreSQL doesn't seem to start:
...
In your case, if PostgreSQL is hanging, I would suspect that the problem
is likely to be with something else. Hopefully there would be info in
the serverlog that would help
lmyho wrote:
Chris Travers [EMAIL PROTECTED] writes:
Things to check when PostgreSQL doesn't seem to start:
...
In your case, if PostgreSQL is hanging, I would suspect that the problem
is likely to be with something else. Hopefully there would be info in
the serverlog that would help
/stops PostgreSQL. At
least the ones that come with the PostgreSQL source are pretty easy to
understand.
I may post back the info of the init file, I know there is postgresql in the
init.d directory. And hope to get your further help from that.
That would be the file.
Best Wishes,
Chris
was
able to
login.:)
Right. But passwords are ineffective with trust authentication. If you
need them you will need to use password, md5, or the like instead.
Best Wishes,
Chris Travers
Metatron Technology Consulting
---(end of broadcast)---
TIP 3
started, you might
find the following article helpful:
http://www.metatrontech.com/sql-ledger-wiki/index.php?UnderstandingPostgreSQLAuthentication
Best Wishes,
Chris Travers
Metatron Technology Consulting
---(end of broadcast)---
TIP 5: don't
projects that people are using are:
Slony-I (Async, master/slave)
PgPool (sync, load balancing possibilities)
Best Wishes,
Chris Travers
Metatron Technology COnsulting
begin:vcard
fn:Chris Travers
n:Travers;Chris
email;internet:[EMAIL PROTECTED]
x-mozilla-html:FALSE
version:2.1
end:vcard
framework, etc. to create a replication solution.
Does that make sense?
Best Wishes,
Chris Travers
Metatron Technology Consulting
---(end of broadcast)---
TIP 6: explain analyze is your friend
,
Chris Travers
Metatron Technology Consulting
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
one node is safe.
Best Wishes,
Chris Travers
Metatron Technology Consulting
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
the storage requirement of the database
server cluster?
Maybe you can provide us with more information on your environment,
application, expected load, etc. so we can help you explore other
possibilities.
Best Wishes,
Chris Travers
begin:vcard
fn:Chris Travers
n:Travers;Chris
email;internet:[EMAIL
Jan Waiz wrote:
Hi Folks,
is it possible to make a Replication between several
PostgresSQL-Databases ?
Short answer: Yes (for most cases). Long answer will depend on what
your requirements are.
What do you have in mind?
Best Wishes,
Chris Travers
Metatron Technology Consulting
.
Best Wishes,
Chris Travers
Metatron Technology Consulting
begin:vcard
fn:Chris Travers
n:Travers;Chris
email;internet:[EMAIL PROTECTED]
x-mozilla-html:FALSE
version:2.1
end:vcard
---(end of broadcast)---
TIP 6: explain analyze is your friend
the database
when a backup of the database is desired, have Postgresql create the
database re-creation script, let the NAS take it's snap, and then
bring the database back up.
Any suggestions, experiences, or observations?
Best Wishes,
Chris Travers
Metatron Technology Consulting
begin:vcard
fn:Chris
Have you tried restarting the Postmaster?
Best Wishes,
Chris Travers
Metatron Technology Consulting
Brock Williams wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I'm getting this message when I try to access one of the databases in
my cluster:
FATAL: cache lookup failed for access
would normally expect.
Also I wonder what the impact of several Postmasters trying to access
data over NFS would be.
Best Wishes,
Chris Travers
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http
, if a lack of RAM is your problem,
putting more stuff in RAM doesn't seem very sound to me.
Best Wishes,
Chris Travers
Metatron Technology Consulting
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire
for the record, I can think of at least one way of hacking this on,
but it seems like it should be an absolutely last resort rather than a
first impulse.
PostgreSQL can do this, but you probably don't want it to.
Best Wishes,
Chris Travers
begin:vcard
fn:Chris Travers
n:Travers;Chris
email;internet
: One should not needlessly multiply entities.
(the most common translation I have seen regarding what William of Occam
actually said.) This statement is a fabulous engineering principle.
Best Wishes,
Chris Travers
Metatron Technology Consulting
---(end of broadcast
handling on the affected systems...
Best Wishes,
Chris Travers
Metatron Technology Consulting
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
to the database.
You MUST have both permission in the pg_hba.conf AND a valid user
account to log in.
Does that make sense?
Best Wishes,
Chris Travers
Metatron Technology Consulting
lori
---(end of broadcast)---
TIP 2: you can get off all lists at once
Hi Ian;
I think it is important to figure out why this is happening. I would
not want to run any production databases on systems that were failing
like this.
I am trying to figure out what are the likely causes of the errors...
1) Any other computers suffer random application crashes, power
).
Best Wishes,
Chris Travers
- Original Message -
From: Gary Stainburn [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, January 26, 2004 5:50 PM
Subject: Re: [ADMIN] [SQL] Database diagram
On Friday 23 January 2004 6:16 pm, Rajesh Kumar Mallah wrote:
Dear Ganesan,
pgautodoc
Hi Robert;
I am using DBD::Pg 1.31. That may be the problem. Any suggestions
regarding repairing this problem at the moment?
Best Wishes,
Chris Travers
- Original Message -
From: Robert Creager [EMAIL PROTECTED]
To: Chris Travers [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday
There is a free Perl script which is called something like pgautodoc which
creates DIA diagrams from databases. Take a look for it on Freshmeat.
- Original Message -
From: Ganesan Kanavathy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 1:38 PM
Try doing an initdb on the other computer OR shutting down postgreSQL
(mandatory) and then copying over your data directory.
Best Wishes,
Chris Travers
- Original Message -
From: CY [EMAIL PROTECTED]
To: pgsql-admin [EMAIL PROTECTED]
Sent: Thursday, January 08, 2004 2:28 PM
Subject
Hi Ashok;
Check the documentation on the system catalogs. You can look up types
there, etc. using joins from the system catalogs.
Something like
SELECT typname FROM pg_types WHERE oid IN (SELECT atttypid FROM pg_attribute
WHERE attname = 'column_name' AND attrelid = (SELECT oid FROM pg_class
At the risk of stating the obvious, also check to make sure Postmaster
is listening on port 5432. To do this log in as root and run /sbin/fuser
-vn tcp 5432. If postmaster is not listed it may only be running with
unix sockets. This measn that you must pass the -i flag to postmaster
when it
31 matches
Mail list logo
