> 1) create one user with password and all Grant on Database. it is a admin
> user
The below steps would help:
$ su - postgres
$ createuser your_user
Shall the new user be allowed to create databases? (y/n) y
Shall the new user be allowed to create more new users? (y/n) y
CREATE USER
Use GRANT
>
> Postgres 7.3.X is missing of a lot implicit cast present before
> so I suggest you to define your cast integer => varchar before
> to import the DB.
>
do you mean I redefine this function
varchar(integer)-into> varchar(varchar) ?
because this function varcha
On Fri, Jun 13, 2003 at 00:17:38 +0200,
Mendola Gaetano <[EMAIL PROTECTED]> wrote:
> "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. Im
can statistics help the postgresql
performance? if yes how?
On Tue, 10 Jun 2003, Karien wrote:
> Hi there.
>
> First things first. I just want to say I've moved from Mysql to Postgres
> for alot of reasons. :-)
>
> My questions:
> =
>
> * What is the limit my PostgresDB can grow to? 4gigs, 8gigs?
Waaayy bigger. While the theoretica
Title:
We have a set of records in a table that needs to be ranked. We thought of
adding a ranking field, but the problem is that the ranking could change
often and there could be additions and deletions from the list. Updating
this ranking field is quickly going
This list does not make it easy to unsubscribe. I have asked to be
removed and I got an email telling me to e-mail a mailing address to be
removed. I was told that I would get a e-mail to reply to to confirm,
and I did not get any such mail. I have already asked to be removed 3
times. I see oth
On Thu, 12 Jun 2003, Daniel Seichter wrote:
> 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 followin
"scott.marlowe" <[EMAIL PROTECTED]> writes:
> Yes, you can do it. All you have to do is create four seperate accounts
> for it to run under (pgsql1, pgsql2, pgsql3, pgsql4) and then in each of
> those accounts, set up a different PGDATA value and initdb as that user.
> Then edit each account's
Jodi Kanter wrote:
We have a set of records in a table that needs to be ranked. We thought
of adding a ranking field, but the problem is that the ranking could
change often and there could be additions and deletions from the list.
Updating this ranking field is quickly going to get messy.
Is an
10 matches
Mail list logo
