Ben Kim <[EMAIL PROTECTED]> writes:
> I'm starting it with something like the following, as root in /etc/init.d
> script.
> su pgsql -c "/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data
> -p /usr/local/pgsql/bin/postmaster start"
> And pgsql has PGDATA3 defined in .cshrc.
su is
unregister
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Many thanks for the advice.
I'm starting it with something like the following, as root in /etc/init.d
script.
su pgsql -c "/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data
-p /usr/local/pgsql/bin/postmaster start"
And pgsql has PGDATA3 defined in .cshrc.
The PGDATA3 is not be
Dear all
Recently I try to run pgreplicator in Redhat linux
9.0. I have made it in installation and Managing
Replicated databases. Now I'm entering the third
phase, Synchronizing Replicated Databases. I try to
run pgrd under user replicator but the result is this:
[EMAIL PROTECTED] bin]$ ./pgrd
co
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, 2004-10-25 at 05:02, Rigmor Ukuhe wrote:
> Hi,
>
> I have table with size ~35 MB, it has several indexes and couple of them are
> well over 500 MB in size (they are indexes with 3-4 columns involved, with
> datatypes like varchar, int4 , timestamp, boolean).
> Database is VACUUMed nightly,
Ben Kim <[EMAIL PROTECTED]> writes:
> pgsql=# drop database mydb;
> ERROR: Postmaster environment variable 'PGDATA3' not set
> The database owner is pgsql, and if I echo $PGDATA3 as the owner, it
> returns a valid directory. Also, the datpath is correct.
You have $PGDATA3 set in your interactive
Dear list,
I'm using Postgresql 7.2 on Solaris.
I have this error message when I try to drop a database. I couldn't find a
mention anywhere on this error. Could someone advise how to circumvent
this error?
pgsql=# drop database mydb;
ERROR: Postmaster environment variable 'PGDATA3' not set
Th
Rigmor Ukuhe wrote:
> Hi,
>
> I have table with size ~35 MB, it has several indexes and couple of them are
> well over 500 MB in size (they are indexes with 3-4 columns involved, with
> datatypes like varchar, int4 , timestamp, boolean).
> Database is VACUUMed nightly, version is 7.2.4 (cant upgrad
On Mon, Oct 25, 2004 at 01:20:01PM -0400, Goulet, Dick wrote:
> Now does Pgsql support a script like Oracle's login.sql.
You can put startup commands in $HOME/.psqlrc. For more info about
psql's capabilities, see the documentation:
http://www.postgresql.org/docs/7.4/static/app-psql.html
--
M
Thanks, that worked. Now does Pgsql support a script like Oracle's
login.sql.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
From: Michael Fuhr [mailto:[EMAIL PROTECTED]
Sent: Monday, October 25, 2004 1:14 PM
To: Goulet, Dick
Cc: [EMAIL PROTECTED]
Subject: Re:
On Mon, Oct 25, 2004 at 12:15:32PM -0400, Goulet, Dick wrote:
> Anyone know how to turn off the --MORE-- option when a query returns?
\pset pager
This should toggle whether paging is used or not. You could also
temporarily set the PAGER environment variable to "cat" or some
other program that do
Anyone know how to turn off the --MORE-- option when a query returns?
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmail
Hi,
I have table with size ~35 MB, it has several indexes and couple of them are
well over 500 MB in size (they are indexes with 3-4 columns involved, with
datatypes like varchar, int4 , timestamp, boolean).
Database is VACUUMed nightly, version is 7.2.4 (cant upgrade to newest
version at the mome
Jodi Kanter <[EMAIL PROTECTED]> writes:
> I thought there was an option to rename a database?
No, but you could always do an UPDATE on pg_database. It might be a
good idea to ensure there are no backends running in the target database
when you do the update. (I think that recent releases wouldn'
probably you had a deadlock and the postgresql solved it
by itself if that is true - you will have another one soon.
On Mon, 25 Oct 2004, Rajesh Kumar Mallah wrote:
> Hi,
>
>
> Somehow those pids automatically got terminated
> and my problem was solved. I did not issue any kill as i
> do not h
syntax is:
update pg_database set datname= where datname=;
checkpoint;
HTH,
Chris
--( Forwarded letter 1 follows )-
Date: Mon, 25 Oct 2004 08:59:03 -0400
To: [EMAIL PROTECTED]
From: [EMAIL PROTECTED]
Sender: [EMAIL PROTECTED]
Subject: [ADMIN] db rename
I tho
Dear Jodi,
psql>\h CREATE DATABASE
Command: CREATE DATABASE
Description: create a new database
Syntax:
CREATE DATABASE name
[ [ WITH ] [ OWNER [=] dbowner ]
[ LOCATION [=] 'dbpath' ]
[ TEMPLATE [=] template ]
[ ENCODING [=] encoding ] ]
tradein_clien
I thought there was an option to rename a database? I cannot seem to
find the syntax in any of my books or on the web site. Am I incorrect?
We are running 7.3.4. We have to bring our sytem down to upgrade the
release this afternoon. There are a number of db changes taking place
so I was thinkin
Hi,
Somehow those pids automatically got terminated
and my problem was solved. I did not issue any kill as i
do not have access to the server.
curious how it happened any idea??
Regds
mallah.
Tsirkin Evgeny wrote:
On Mon, 25 Oct 2004, Rajesh Kumar Mallah wrote:
Hi,
We run our webserver using m
> However:
> <>http://www.postgresql.org/docs/7.4/static/release-7-4-2.html
> does say that dump/initdb/reload is an option to fix 2 errors.
> These two errors can also be fixed manually without dump / reload
> which is described in same URL.
>
Opps !! I was wrong and was in the impression
hi friends
i have postgresql running on a linux box
we are around 25 developers in the local network using
it
for development
i wanted to know whether this is a way by which all
the users in my domain would get access to postgres
instead of entering all the ip addreses in the conf
file
some thi
unregister
On Mon, 25 Oct 2004, Rajesh Kumar Mallah wrote:
>
> Hi,
>
> We run our webserver using mod_perl and perl/DBI/DBD-Pg .
> I have observed that most of the pg backends that block other queries
> are in ' in transaction' state. Usually sending a -INT or -TERM
> to such blocking backends solve the p
unsubscribe
--
___
Find what you are looking for with the Lycos Yellow Pages
http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.asp?SRC=lycos10
---(end of broadcast)---
TIP 4: Don't
Vishal Kashyap @ [Sai Hertz And Control Systems] wrote:
Dear Rajesh ,
The release notes of upgrades usually indicate whether initdb
is required or not. Generally when the last digit of a version
change it does not require a dump and reload. In this case
the release notes say:
26 matches
Mail list logo
