Andrew Biagioni wrote:
On three different machines running the same PostgreSQL version (7.3.5)
on Linux and almost identical databases, I have been plagued by
occasional, unexplainable (to me) reboots of the computer.
1) Do you have a software watchdog that is configured to reboot the machine whe
Andrew Biagioni <[EMAIL PROTECTED]> writes:
> On three different machines running the same PostgreSQL version (7.3.5)
> on Linux and almost identical databases, I have been plagued by
> occasional, unexplainable (to me) reboots of the computer.
Postgres can *not* cause a system reboot; it's only
Help!
I'm having a severe problem with my production PostgreSQL servers, and
I'm running out of ideas as to what could be the problem.
On three different machines running the same PostgreSQL version (7.3.5)
on Linux and almost identical databases, I have been plagued by
occasional, unexplainab
"Richard Harris" <[EMAIL PROTECTED]> writes:
> Does PosgreSQL has a capability to check t=
> he internal consistency of tables and and indexes, i.e., a tool like the DB=
> CC capability in MS SQL Server? If so, where is it documented?
(Please don't use HTML in postings to the PG lists.)
We do not
Terry Hampton <[EMAIL PROTECTED]> writes:
> I can't determine what SQL to which system catalog will associate
> "1043" to "varchar" and "25" to "text"
pg_type where oid = 1043, ie:
SELECT * FROM pg_type WHERE oid = 1043;
Regards,
Manuel.
---(end of broadcast)---
Title: Database consistency checker
Hi,
Does PosgreSQL has a capability to check the internal consistency of tables and and indexes, i.e., a tool like the DBCC capability in MS SQL Server? If so, where is it documented?
Thanks,
Rich Harris
On Saturday 27 March 2004 08:32 pm, [EMAIL PROTECTED] wrote:
> 1. Where should the postgresql.conf file be to be recognized by the
> service on startup? currently, it is inside my $PGDATA directory but
> all of its contents are commented out.
It is a template. This is where the file should be l
ok. if i don't misunderstand you (english is not my mother tongue, so i can
be wrong). your point is that speed is not necesarily performance, that's
right.
so, the real question is what is the best filesystem for optimal speed in
postgresql?
___
All,
select attname, atttypmod, atttypid from pg_attribute where
attrelid=3701787 and attnum > 0;
returns:
attname | atttypmod | atttypid
-+---+--
acct_name | 132 | 1043
grp |54 | 1043
name | 260 | 10
Hello Jaime,
I think you're on the right track but have gotten some
concepts possibly confused.
As I remember, the original email asked if Postgres
could be run in a "raw" mode. Another submitter
told us that it can not. ( Did I read t
Hello Jaime,
I think you're on the right track but have gotten some
concepts possibly confused.
As I remember, the original email asked if Postgres
could be run in a "raw" mode. Another submitter
told us that it can not. ( Did I read that
Can you tell me (or at least guide me to a palce where i can find the
answer) what are the benefits of filesystems over raw devices?
And what filesystem is the best for postgresql performance?
_
The new MSN 8: advanced junk mail pro
On Mon, 2004-03-29 at 02:10, Peter Galbavy wrote:
> Tom Lane wrote:
> > Neither of those readings is correct. The correct interpretation is
> > that the copyright holders (us and UCB, in the case of Postgres)
> > aren't charging any fee. This does not prohibit others from charging
> > for their o
Dear All:
I'm (was) running the Postgresql 7.3.2 on Linux 8,
I had try to create a new instance of psql server with postmaster... and also
try to experiement environment variable PGDATA.
But now I have change the environment data to its
original location but unable to run '/psql mydb' comma
14 matches
Mail list logo
