Is there anyway to modify the statement_timeout value set
in postgresql.conf we creating a connection?
I would like to have the value set to something like 60 seconds on a
regular basis but my vacuumdb statements run longer and timeout without
completing the vacuum
--
Warren Little
Senior Vice P
Philippe,
First off, welcome to the club. We're primarily an Oracle shop, but due to
Oracle's pricing we are using PostGreSql for web based applications.
Why PostGreSql. Well first off it provides a much smaller learning curve for
our developers than MySql does. MySql, until
You likely need this line in postgresql.conf:
tcpip_socket = true
On Thu, 15 Jan 2004, Norbert Beckers wrote:
> I'm a novice when it comes to PostgreSQL and PostgreSql Admin. I having
> truoble connecting to PostgreSQl Server running on the localhost. Every
> time I try to connect I get the fo
On 16 Jan 2004, Ashok Chauhan wrote:
>
> hello
>
> i am selecting ten fields form a table and i want to replace the null
> values with any other value.
Look up coalesce(), it should do exactly what you need.
---(end of broadcast)---
TIP 1: subsc
With "createuser bruce" you have created a user in the PostgreSQL environment while
using the bash command "su - bruce" you are switching user in the SO (i.e. Linux)
environment.
You can solve your problem either using bash the command "adduser bruce" to create the
same user also in the OS or
kandiah ratnavale <[EMAIL PROTECTED]> writes:
> could you please tell me what is wrong here?
> how would i change to user bruce?
You are confusing unix users with postgres users. They are different
so the su command does not work. You can use the -U switch to psql to
connect as another user
psql
On Mon, 12 Jan 2004, kandiah ratnavale wrote:
> -bash-2.05b$ whoami
> postgres
> -bash-2.05b$ su - bruce
> su: user bruce does not exist
> -bash-2.05b$ createuser bruce
> Shall the new user be allowed to create databases? (y/n)
> Shall the new user be allowed to create more new users? (y/n) y
> ER
Hi,
We've got a rather odd problem with our PG 7.3.2 production installation.
Everything is working fine on the surface, and has been for quite some time.
Only recently, we have noticed the abscence of any schemas.
We're at a complete loss as to how this happened, or even when.
The databases we ru
(BHello all
(BI have a problem trying to config a postgresql-7.4.1 on Solaris9
(Bwhen I do this ./configure, it gave me a error, saying
(B
(B "could not execute a simple test program"
(B this may be a problem related to locating
(B shared libraries."
(B
(BI've been lookin
Hello pgsql-admin,
I created dump file of my db under 7.3.1
And then i' trying to restore it under 7.3.4.
pg_restore -d clearview -Ft -u cf_04.01.13.tar
bu i've got the error:
"pg_restore: [archiver (db)] could not execute query: ERROR: COPY command, running
in backend
with effecti
I'm a novice when it comes to PostgreSQL and PostgreSql Admin. I having
truoble connecting to PostgreSQl Server running on the localhost. Every
time I try to connect I get the following response:
¨Error connecting to the server: could not connect to server:
Connection refused
is server runnin
We recently purchased DBVisualizer. It's really quite good for this kind of diagram
(some quirks).
http://www.dbvis.com
It's not open source though and you do have a small charge to pay.
Cheers,
Hal.
-Original Message-
From: Rajesh Kumar Mallah [mailto:[EMAIL PROTECTED]
Sent: 14 January
--On Monday, January 12, 2004 13:45:45 -0800 Shankar K <[EMAIL PROTECTED]>
wrote:
Hi There,
We are considering to use NetApp filer for a highly
busy 24*7 postgres database and the reason we chose
netapp, mostly being the "snapshot" functionality for
backing up database online. The filer would
Sai Hertz And Control Systems wrote:
> What I need is since password be stored in the bash variable for
> once I may pass on the variable with password to
> psql
> pg_dump
> pg_restore
> and my database migration would go smothly
That would be a security hole because then other users can read the
Hi All ,
Have a look at DbVisualizer-4.0.2
Java based ER tool that works very well.
Regards.
Leslie.
On Wed, 2004-01-14 at 18:15, Enrico Ortmann wrote:
> Guten Tag Juan Miguel,
>
> Hi Juan,
>
> JM> Hi, I use MS Visio Professional, and it works (not very good), but it works.
> JM> I ever won
Bruno LEVEQUE wrote:
Hi,
Can you give us the command line with all options of your configure ?
i just used ./configure without any option.
i finally fixed it by comparing it with the 7.2's configure:
change line 1620:
from
cc_string="GCC `${CC} --version`"
to
cc_string="GCC `${CC} --version
I am using postgresql 7.4.0 on Debian 3.0r2 (Woody) on an x86 box. I'm
using the binary package from http://people.debian.org/~elphick/debian/
If I run the initscript from the command line:
invoke-rc.d postgresql start
it starts up just fine. But when I reboot the system, it fails to
start a
Hello all,
My company mainly use Oracle as database but we would like to make some
tries with some open source database.
I think PostGreSQL might be candidate for our project.
I read several documents on it, but I wasn't able to find any infos on what
are exactly the needs, in term of administrati
Hi,
I've got problem with one specific query. I've
got the table
with many of rekords like these:
name
| quantity | date
---
aaa
2
2003-04-01
bbb
4
2003-04-12
ccc
5
Sai Hertz And Control Systems wrote:
Dear Jan Wieck ,
Yes I agree with you Jan , most of the time we round the amount and
this is done by truncating greater than 3 decimal digits and
rounding the 3 digit to 2 in other words :
select trunc(1000.236897,3);
then
selecr round(1000.236,2);
This
Sai Hertz And Control Systems wrote:
Dear Jan Wieck ,
Floating point math itself is not precise, but rather an approximation,
usually of 8 or 14 digits. You can't approximate money. This isn't a
PostgreSQL issue but rather a general programming issue.
Thanks, Bruce. I assume the arbitrary pre
Hi There,
We are considering to use NetApp filer for a highly
busy 24*7 postgres database and the reason we chose
netapp, mostly being the "snapshot" functionality for
backing up database online. The filer would be mounted
on a rh linux server (7.3), 4g RAM, dual cpu with a
dedicated card for file
VERY, VERY URGENT!!
Below is a transcript of an attempt to create a user, which I trust
will be self explanatory.
Who do you think I should go to discuss this problem?
Is there a users' group in which I can post this problem for discussion?
Please help me?
-bash-2.05b$ createuser bruce
Shall
Michael Glaesemann wrote:
On Jan 4, 2004, at 6:51 PM, Bruce Momjian wrote:
Michael Glaesemann wrote:
On Dec 29, 2003, at 11:28 AM, Sai Hertz And Control Systems wrote:
I would like to share my concerns about the IEEE 754 specification
and
floating point handling by PostgreSQL .
What specifically
Chris Gamache <[EMAIL PROTECTED]> writes:
> It might not matter one bit that the actual data files are safe and
> sound if the transaction log is corrupted.
There's always pg_resetxlog.
However, if you value data integrity over performance, it'd probably be
better to have data+log on one redundan
Enrico Ortmann <[EMAIL PROTECTED]> writes:
> But when I connect using the IP-adress instead of the alias
> $conn = @pg_pconnect("host=192.168.0.200 port=5432 user=postgres dbname=template1");
> the handle is valid as well, but then if I want to create the database I got the
> error
> ERROR: CREAT
On Wed, 14 Jan 2004 02:00:45 +0530
Sai Hertz And Control Systems <[EMAIL PROTECTED]> wrote:
>
> > and all the PostgreSQL files. My question is if I restore this
> > snapshot will PostgreSQL work? I know if doing a typical file
> > system backup of PostgreSQL I must first stop the postmaster or
hello
i am selecting ten fields form a table and i want to replace the null
values with any other value.
plz. help me
Ashok
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/F
I have one RAID 1+0 array available. My primary concern is data integrity.
The general instruction is to put pg_xlog on another filesystem, seperated
physically from the database files, for maximum performance. That is what I had
planned on doing. However, it dawned on me that there could be a ser
Hello admins,
I got a strange problem while creating a database FROM PHP:
I connect from SuSE shell via php to a PG-server [7.3.2] using command
$conn = @pg_pconnect("host=db port=5432 user=postgres dbname=template1");
[db is an Alias in /etc/hosts an points to 192.168.0.200]
Then I create a data
30 matches
Mail list logo
