Hi All
i am new on Postgresql7.3. so please
help.
i have create one(ICPS) Database with
Postgre user and password is NULL.
now i want to
1) create one user with password and
all Grant on Database. it is a admin user
2) i want to add password to postgres
user.
Please Help
Ramesh Patel
"Henry House" <[EMAIL PROTECTED]> wrote:
> Yes. Easy answer: use a column of type 'timestamp default now()'.
With that default value you store the time
stamp of transaction where the row was inserted. Immagine to insert
inside the same transaction a lot of rows and this operation will take long
1
Hello,
is there a way to recover data from a damaged database if
a.) we have some but not all datafiles
b.) we have all datafiles but system tables are currupted
The situation is extremely critical so we're interested in all possible solutions even
if it's time consuming or if we need to pay fo
unsubscribe
__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql
Hello,
I only know the traditional way of using postgreSQL:
In serverprocess with an "unlimited" number of databases.
But:
Is is possible to have 4 processes, for each database one, running on one
linux server?
The reason is the following:
I only have one server on which a productive database is w
Jeff Boes <[EMAIL PROTECTED]> writes:
> On Thu, 2003-06-12 at 13:16, Tom Lane wrote:
>> That sounds a tad excessive; are the statistics really changing that
>> fast?
> Well, I have some convincing evidence on this.
Ah. Well, you might consider analyzing just that table (maybe even just
its times
On Thu, 2003-06-12 at 13:16, Tom Lane wrote:
> > We're also ANALYZE-ing the largest 12-18 tables on a cycle: every twenty
> > minutes, a daemon wakes up and ANALYZEs until they're all done or two
> > minutes has elapsed, whichever comes first.
>
> That sounds a tad excessive; are the statistics r
Jeff Boes <[EMAIL PROTECTED]> writes:
> On Thu, 2003-06-12 at 12:42, Tom Lane wrote:
>> How often do you VACUUM?
> We've gone from daily, to twice daily, to several times during the "peak
> updates" period, and back to twice daily.
I suspect that the real problem here is the old open transactions
Jeff Boes <[EMAIL PROTECTED]> writes:
> Given a fairly large (7 MRows or so) table with more than one index
> (say, two): would it be theoretically faster to do
> REINDEX TABLE "foo";
> or
> REINDEX INDEX "ix_foo_one";
> REINDEX INDEX "ix_foo_two";
I doubt you could possibly detect any diffe
Jeff Boes <[EMAIL PROTECTED]> writes:
> Could I glean some info from the postmaster log? For example, I think I
> know that
> ReceiveSharedInvalidMessages: cache state reset
> has something to do with this "idle in transaction" state. Could the
> incidence of these be used as a measurement?
Yeah,
On Thu, 2003-06-12 at 12:42, Tom Lane wrote:
> Jeff Boes <[EMAIL PROTECTED]> writes:
> > For large (>1 million rows) tables
> > which have a pretty high turn-over (average life span of a row is 3
> > days), should there be any query performance differences whether you
> > VACUUM FULL or not?
>
> H
Jeff Boes <[EMAIL PROTECTED]> writes:
> For large (>1 million rows) tables
> which have a pretty high turn-over (average life span of a row is 3
> days), should there be any query performance differences whether you
> VACUUM FULL or not?
How often do you VACUUM? Do you have enough FSM space to su
On Wed, Jun 11, 2003 at 02:42:42PM +0530, Anagha Joshi wrote:
> Hi,
> Is there any way to know data & time when the row is inserted into a
> table?
Yes. Easy answer: use a column of type 'timestamp default now()'. Whenever
row is inserted with the value for that columns unspecified, it will take o
[Apologies if you have seen this before. I just discovered that posting
to the group via NNTP, at Teranews.com, apparently isn't working since
my posts aren't showing up in the mailing list archives.]
Given a fairly large (7 MRows or so) table with more than one index
(say, two): would it be theor
[Apologies if you have seen this before. I just discovered that posting
to the group via NNTP, at Teranews.com, apparently isn't working since
my posts aren't showing up in the mailing list archives.]
Our system consists of a number of daemon processes running Perl code,
and using the DBI layer.
[Apologies if you have seen this before. I just discovered that posting
to the group via NNTP, at Teranews.com, apparently isn't working since
my posts aren't showing up in the mailing list archives.]
We are trying to run down some performance differences between our
production system (where we r
I'm writing here because I can not reach directly Lamar Owen
and he is waiting an url for Postgres 7.3.2 for RH7.2.
Gaetano
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [E
Stef <[EMAIL PROTECTED]> writes:
> If one has upgraded postgres from 7.1.2 to 7.3.1,
> how does one convert all the triggers that represent
> 7.1.2 foreign keys to actual foreign keys.
The contrib/adddepend module is supposed to help with this
(I've not used it myself though).
"Nathalie Boulos" <[EMAIL PROTECTED]> writes:
> When i insert a value into a field in the table directly, all the other
> fields take their default values normaly, but the problem is if i insert
> into the rule and not into the table, all the fields who has default values
> do not take them. tho
If one has upgraded postgres from 7.1.2 to 7.3.1,
how does one convert all the triggers that represent
7.1.2 foreign keys to actual foreign keys.
What I really want to have, is that when I dump the new
upgraded database, that the tables will be dumped with the
original "foreign key" syntax as they
Hi,
i have a problem with the default value:
When i insert a value into a field in the table directly, all the other
fields take their default values normaly, but the problem is if i insert
into the rule and not into the table, all the fields who has default values
do not take them. those fiel
Hello!
we run on our PostgreSQL instanze a vaccum full and a reindex every night to
keep the db fast, our PostgreSQL version is 7.2.
It works fine but last night, the indexes were beeing destroyed. A query
returned the message:
Index is not a btree
After dropping all indexes and creat
22 matches
Mail list logo
