Is there a default timeout setting for connections to
the database?
TIA.
__
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com
---(end of broadcast)---
TIP 2:
You can assign the password as part of createuser, and it is stored
encrypted in the database.
---
TooManySecrets wrote:
[ PGP not available, raw data follows ]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday
Andreas Schmitz [EMAIL PROTECTED] writes:
I have a problem with the vacuum full. every time I run the vacuum command I
loose data from the parent tables. maybe also from the subtables (haven't
checked yet). I tried it a few times up to now an I can reproduce the
phenomena.
That sounds ugly
On Sat, 15 Feb 2003 [EMAIL PROTECTED] wrote:
Hi ,
i get following error when attempting to drop a table.
tradein_clients=# DROP TABLE branding_master;
ERROR: DropTrigger: relation branding_nob_bak has reltriggers = 0
tradein_clients=#
Did you make any direct changes to the pg_class row
yep there is a mismatch .
shud i delete the entries from pg_trigger to match reltriggers
i am sure i dont' need those triggers.
regds
mallah.
tradein_clients=# SELECT relfilenode,relkind,reltriggers from pg_class where
relname='branding_master'; relfilenode | relkind | reltriggers
Can anybody tell me how to set up pgsql (v7.1) authentication using NIS password
database?
I set my pg_hba.conf as following:
hostall10.0.1.0255.255.255.0identsameuser
But I'm still getting user does not exist error. Any suggestion will be very much
appreciated.
Thanks in
On Sat, 15 Feb 2003 [EMAIL PROTECTED] wrote:
yep there is a mismatch .
shud i delete the entries from pg_trigger to match reltriggers
i am sure i dont' need those triggers.
Hmm, I was going to just say yes, but then realized that if any
of those are foreign key triggers, you'll need to drop
yes maybe.
thanks for the help.
regds
mallah.
On Sat, 15 Feb 2003 [EMAIL PROTECTED] wrote:
yep there is a mismatch .
shud i delete the entries from pg_trigger to match reltriggers
i am sure i dont' need those triggers.
Hmm, I was going to just say yes, but then realized that if any
of
Hi,
I have created a database view by :
CREATE VIEW V_EDUCATION_LEVEL ( id, description ) AS
SELECT 1, 'College or above'
UNION ALL
SELECT 2, 'Secondary';
Then I pg_dump(ed) the database by specifying a tar format and tried to
pg_restore to a destination database. However, I encountered the
I tried installing postgre 7.3... Since the Gentoo distro I'm using is
largely automated, there are config scripts to take care of copying the
files to the right place and so on, the config is all default values. I
should also mention it compiles all the software on the spot. So I installed
Is a dump/restore required from 7.2 to 7.2.3? What if we were to go
from 7.2 to 7.2.4, or even from 7.2 to the latest, 7.3.2? How can we
tell when a dump/restore is required?
In answer to my own question, I found that the HISTORY file within the
source archive
Tom == Tom Lane [EMAIL PROTECTED] writes:
Tom Laura Conrad [EMAIL PROTECTED] writes:
pg_dumpall -p 8050 /tmp/db.sql
I then tried to restore (again as the postgres user), as documented in
the pg_dumpall man page:
psql -f /tmp/db.sql template1
It does a few things, and
Hi guys,
I am trying to figure out if I can get Postgres to bind to
only the loop-back interface (127.0.0.1) as apposed to binding to all the available
interfaces (0.0.0.0) available on the system.
1. The first question is whether this is feasible at all?
2. If yes, what is the
Tom == Tom Lane [EMAIL PROTECTED] writes:
Tom Raj Mathur [EMAIL PROTECTED] writes:
... However, the complementary process, determining all the
users in group administrators, isn't so clean.
Tom Doesn't select grolist from pg_group where groname =
Tom 'administrators' do
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 13 February 2003 20:34, Bruce Momjian wrote:
pg_password is gone. Few were using it, and now we encrypt the
passwords stored in pg_shadow. Were you sharing your /etc/password file
with PostgreSQL, or did you have another reason for
find your postgresql.conf file, look in there to make sure tcpip_socket= true.the directory that file is in should be the same as the $PGDATA thatyour getting asked for, so you'll be able to do pg_ctl -D /path/to/database statusRobert Treat
Hello All,
Thanks to Robert. I have set the above
Dear
Milist,
1.
I Used 2b using
"alter system kill session
'n1,n2'";
on oracle, to kill specified session.
Than how do i done this on postgres
or there's another solution.
And How do i know the user is
connected.
2.
Sometimes the process is feel so
slowly without knowing what's
I tried installing postgre 7.3... Since the Gentoo distro I'm using is
largely automated, there are config scripts to take care of copying the
files to the right place and so on, the config is all default values. I
should also mention it compiles all the software on the spot. So I
installed
On Fri, 2003-02-14 at 08:51, jose antonio leo wrote:
How can I make selects not sensitive uppercase and lowercase characters?
This is possible modifying something of psql configuration?
I take it you mean that
SELECT x FROM t WHERE x = 'abc';
should also return rows where x = 'ABC' and x =
Hello *,
I have a problem with the vacuum full. every time I run the vacuum command I
loose data from the parent tables. maybe also from the subtables (haven't
checked yet). I tried it a few times up to now an I can reproduce the
phenomena.
I am running postgresql 7.3.2 on solaris 8 (E450 4x
Hi ,
i get following error when attempting to drop a table.
tradein_clients=# DROP TABLE branding_master;
ERROR: DropTrigger: relation branding_nob_bak has reltriggers = 0
tradein_clients=#
can anyone suggest what might be the problem?
regds
mallah.
On Fri, 2003-02-14 at 03:08, vivek K. wrote:
Hello All,
Thanks to Robert. I have set the above things but SQL-ledger is giving
different error this time like :
FATAL 1: No pg_hba.conf entry for host 192.168.168.56, user sql-ledger,
database template1
If your using the standard Red Hat rpm, I
On Thu, 2003-02-13 at 14:48, Hal Lynch wrote:
How do I find the date when a table was created or last modified?
AFAIK there is no way to do this. Most folks that need an audit trail
tend to role their own using triggers.
Robert Treat
---(end of
what does the output of /usr/bin/postmaster tell you?
Robert Treat
On Fri, 2003-02-14 at 03:25, Martin Matusiak wrote:
I tried installing postgre 7.3... Since the Gentoo distro I'm using is
largely automated, there are config scripts to take care of copying the
files to the right place and
On Thu, 2003-02-13 at 18:48, Laurette Cisneros wrote:
Using 7.3.2 now.
I noticed a slew of messages in my pgsql log like this:
WARNING: COMMIT: no transaction in progress
I'm wodering if this is related to the fact that there is now an option in
the postgresql.conf file:
How can i port data from SQL-Server 2000 to Postgre. If I use SQL-Server
DTS, I got ODBC call failure error. Which version of ODBC is appropriate for
this.
Regards,
Sreedhar
Faith, faith, faith in ourselves, faith, faith in God, this is the secret
of greatness.
If you have faith in all the three
Hi All,
Is there any UNIT TESTING tool for postgre like PLSQLUNIT for ORACLE
Regards
Sreedhar
Faith, faith, faith in ourselves, faith, faith in God, this is the secret
of greatness.
If you have faith in all the three hundred and thirty millions of your
mythological gods,
and in all the gods
27 matches
Mail list logo