How can I change the owner of tables in a database?
Chris Bruce
[EMAIL PROTECTED]
Lucent Technologies
2300 Camino Ramon
San Ramon, Ca
925-815-8336
Likely there is none. Do an "su" to root then do "su - postgres".
This will make you the postgres user without having to know the
password if it exists.
Oscar Monroy Brise~no wrote:
...anybody know the password for the user postgres ???
--
Chris Albertson
[EMAIL PROTECTED]
Hi,
I have postgresql on linux 6 the installation was made by default with the
system, so anybody know the password for the user postgres ???
thanks in advance for any help !
|||
o o
==uuu==o==uuu===
Hi everyone,
I have a postgresql 6.5.3 installed on a redhat machine (base 6.0 but the
rpms are from 6.1). Until now everything works fine with it (even www+php
access). Last night I encountered this problem. I want to be able to
connect to the database server using "password" as the authentifica
Hello!
I've been running some heavy joins on my postgres database, and I had it
configured with '-S65536' to use 64Mb of RAM for each backend sort memory,
since the FAQ says:
"You can also use the backend -S option to increase the maximum amount of
memory used by each backend process for tempora
--- Bruce Momjian <[EMAIL PROTECTED]> wrote:
> > What's the advantage of using pg_dumpall over
> tar/gzip for backup?
>
> pg_dumpall grabs a constent snapshot of the data.
> tar/gzip is just
> backing up the files, so you can get some data in
> some table that is
> committed, but miss data in an
unsubscribe
-- Brian Baquiran <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm using Postgres 6.5.2 in a high-volume
> application that has on the order of a
> hundred inserts and selects (but mostly inserts) a
> minute. My loadaverage hovers
> around 1.0, and can go much, much higher (50-80)
> during vacuum and que
