i want to merge two databases how it is done plz help me
thanQ
How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos. Get Yahoo!
Photos
Hi Colin,
If its a one-off I usually do this in pgadmin3 by right clicking on the
schema and doing the grant wizard from there.
Regards
Walter
On Mon, 2005-11-07 at 10:54 +1300, Colin Taylor wrote:
> Hi there, Ive google and searched the lists but havent found detailed
> instructions on how t
Tom Lane wrote:
This would be a pretty bad idea IMHO, since it would lead to bloating
the logs with autovacuum progress messages by default --- and whatever
you may think about it, I really doubt that the average DBA will want
those messages there all the time.
I wonder whether it would be pract
"Forensic Labs." <[EMAIL PROTECTED]> writes:
> initializing pg_shadow... [1] Bus error (core dumped)
> Can anyone help me out with this one?
Can you provide a stack trace from that core dump?
(You'll need to run initdb with --noclean option so that it doesn't wipe
the data directory, else you
http://www.postgresql.org/docs/faqs.FAQ_DEV.html
On Mon, Nov 07, 2005 at 06:11:54PM +0900, Qiu Lei wrote:
> Dear webmaster:
>
> I am glad to write to you !
>
> I am a programmer at NEC. Recently, I have interests in PostgreSql and
> want to
>
> be a member of the developing team.
>
>
I like the idea of having a autovacuum_log_min_messages. From my
previous experience the pg_autovacuum.log files have been useful in
diagnosing problems in the field.
- Joe
On 11/9/05, Tom Lane <[EMAIL PROTECTED]> wrote:
Joe Maldonado <[EMAIL PROTECTED]> writes:> I agree...for now while I'm devel
Joe Maldonado <[EMAIL PROTECTED]> writes:
> I agree...for now while I'm developing and debugging my application I can
> have the logging be that verbose...I agree that these should be handled as
> info messages, since they are invaluable in investigating problems.
This would be a pretty bad idea I
Hi List,
I've just tried to initdb on a new installation of 7.3.9 which resulted
in this output:
$ initdb -D /usr/local/pgsql/data
The files belonging to this database system will be owned by user
"postgres".
This user must also own the server process.
The database cluster will be initializ
Dear webmaster:
I am glad to write to you !
I am a programmer at NEC. Recently,
I have interests in PostgreSql and want to
be a member of the developing team.
Can I join in the team ? And how ?
Hope to receive your letters !
> instance of postgres. Is there a way to keep my production db up and
> running in 8.0.3 while I also run 8.1.0 on the same server? Then, I could
Yes. There is a way. You have to specify another location and
port for 8.1.0.
Luf
---(end of broadcast)-
Hi,
Some of the queries I run on my Postgresql database take some time to
complete (1 hour+).
I know you can get the active queries by 'select * from
pg_stat_activity', but I was wondering if there is a way to see some
information on the progress of the query execution while running (for
example
Hi there, Ive google and searched the lists but havent found detailed instructions on how to give a user readly access to a schema. Is there a way to do this with out explictly granting the SELECT privilege on every table?
Thanks and regards,Colin.
The first graph certainly looks like a checkpointing issue.
On Wed, Nov 09, 2005 at 07:49:23PM +0100, Marcin Giedz wrote:
> Jim C. Nasby napisa??(a):
>
> >That link isn't working for me,
> >
>
> Upp sorry... now it should work OK.
>
> >but if you're seeing 'spikey'
> >performance I'd bet t
Joe Maldonado wrote:
I have not seen any information so far on this but is there a way to
get the autovacuum daemon in PostgreSQL 8.1 to log the tables which it
is perfoming vacuum or analyze operation on?
I think the autovacuum daemon does log it's activity however all it's
output is set at
I agree...for now while I'm developing and debugging my application I
can have the logging be that verbose...I agree that these should be
handled as info messages, since they are invaluable in investigating
problems.
- JoeOn 11/9/05, Matthew T. O'Connor <[EMAIL PROTECTED]> wrote:
Joe Maldonado
Marcin Giedz <[EMAIL PROTECTED]> writes:
> I made some test comparing postgresql 8.0.4 based on two servers.
> Here is a link:
> http://85.128.68.44/
This is pretty nearly an ideal example of how NOT to use pg_bench :-(
In the first place, don't use a number of clients (-c) much exceeding
the sc
Jim C. Nasby napisał(a):
That link isn't working for me,
Upp sorry... now it should work OK.
but if you're seeing 'spikey'
performance I'd bet that you need to change the bg_writer settings to
make it more aggressive, especially if you're seeing performance drops
Every 5 minutes (assumi
That link isn't working for me, but if you're seeing 'spikey'
performance I'd bet that you need to change the bg_writer settings to
make it more aggressive, especially if you're seeing performance drops
every 5 minutes (assuming default checkpoint settings).
You might also want to up wal_buffers a
Thanks to all who replied, and all apologies for the multiple posting
(my fault).
The solution (in postgres 8.0.1):
Edit data/pg_hba.conf to contain the line:
local all postgres trust
Then su to unix user postgres and restart postges with:
> bin/pg_ctl restart -D /usr/local/pgsql/data -m fast
Hello.
I made some test comparing postgresql 8.0.4 based on two servers.
Here is a link:
http://85.128.68.44/
From my point of view it seems like:
- with opteron I found that it works very FAST periodicaly, why???
Maybe I
did something wrong or.
- xeon seems to work almo
Hi,
which version of postgres do you have? Put this temporarly into the /var/lib/pgsql/data/pg_hba.conf:
if postgres 8:
local all postgres 127.0.0.1/32 trust
if postgres 7:
local all trust
then connect to template1...:
psql -U postgres -d template1
...and set yo
Just disable password checking in pg_hba.conf.
mad mentioned :
=> I have lost the superuser (user postgres) password, but I still have
=> the unix root password. Is there anything I can do to reset the
=> postgres user's password (short of reinstalling Postgres)?
=>
=> Obviously, I can su to unix
Rafael Martinez Guerrero <[EMAIL PROTECTED]> writes:
> On Tue, 2005-11-08 at 18:23, Moises Alberto Lindo Gutarra wrote:
>> you only need make postgres 8.1.0 run using another port, example 5438
> Or another IP/address (listen_addresses) and the same port 5432. ;)
No, because both postmasters will
Hello,
I have not seen any information so far on this but is there a way to
get the autovacuum daemon in PostgreSQL 8.1 to log the tables which it
is perfoming vacuum or analyze operation on?-- Joe Maldonado
On Tue, 2005-11-08 at 18:23, Moises Alberto Lindo Gutarra wrote:
> you only need make postgres 8.1.0 run using another port, example 5438
>
Or another IP/address (listen_addresses) and the same port 5432. ;)
--
Rafael Martinez, <[EMAIL PROTECTED]>
Center for Information Technology Services
Univ
I have lost the superuser (user postgres) password, but I still have
the unix root password. Is there anything I can do to reset the
postgres user's password (short of reinstalling Postgres)?
Obviously, I can su to unix user postgres, but this does not seem to
advance my cause, as doing "psql -U p
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 9 Nov 2005, Marc A. Donis wrote:
I have lost the superuser (user postgres) password, but I still have
the unix root password. Is there anything I can do to reset the
postgres user's password (short of reinstalling Postgres)?
Edit p
I have lost the superuser (user postgres) password, but I still have the unix
root password. Is there anything I can do to reset the postgres user's
password (short of reinstalling Postgres)?
Obviously, I can su to unix user postgres, but this does not seem to advance my
cause, as doing "psql
28 matches
Mail list logo
