What pg_dump backup modes do people usually use for a backup of an
entire database cluster? I usually use plaintext and pipe it through
gzip, however, that doesn't allow you to restore single objects from a
complete backup.
Is there a way to back up the entire cluster using the t or c output
mode
Hello all, Is anyone having trouble downloading the Win 32
binary announced on September 18? I am in Australia and
cannot download from any of the Australian or US mirrors.
Would like to receive confirmation whether or not I am the
stupid one!!!
So what error msg do you get? Do you get a
Hi Magnus, thanks for the reply. My inquiry was whether any other person was
experiencing difficulties with a download and was aimed at trying to figure out
for myself what might be happening. It was not a help request or any form of
criticism. However, in answer to your first questions
1 No
Hi Magnus, thanks for the reply. My inquiry was whether any
other person was experiencing difficulties with a download
and was aimed at trying to figure out for myself what might
be happening. It was not a help request or any form of
criticism. However, in answer to your first questions
Hello There...
I am new to PostgreSQL.
I usually check out negative sides of any software or system, before implementing it or using it.
I would like to know the limitations of PostgreSQL.
Also, I would like to know, whether there is any limitations for the number of records or the size of
On Mon, Oct 03, 2005 at 12:01:02PM -, Denis G Dudhia wrote:
I would like to know the limitations of PostgreSQL.
Also, I would like to know, whether there is any limitations for the
number of records or the size of the tables or database in
PostgreSQL?
See PostgreSQL FAQ.
Section 4.4)
Hi,
I recently stumbled uppon the following thing:
If I compare a field of type numeric to a small decimal constant like
3.6, the constant is interpreted as a double precision value and the
comparison fails with the following message:
# SELECT * FROM tr_table_okpx WHERE prating = 3.6;
Unable to
- Original Message -
From: Tino Wildenhain [EMAIL PROTECTED]
To: Ben-Nes Yonatan [EMAIL PROTECTED]
Cc: Martijn van Oosterhout kleptog@svana.org;
pgsql-general@postgresql.org
Sent: Sunday, October 02, 2005 4:26 PM
Subject: Re: [GENERAL] Broken pipe
Am Sonntag, den 02.10.2005, 16:39
- Original Message -
From: Nirmalya Lahiri [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Sent: Sunday, October 02, 2005 7:34 PM
Subject: Re: [GENERAL] Broken pipe
Hi all,
I am not expert in PHP, so my assumption may not correct
Can we solve this problem by increasing the
Firebird is a nice, small, ACID compliant database that embeds well.
firebird.sourceforge.net
Daniel Schregenberger [EMAIL PROTECTED] writes:
If I compare a field of type numeric to a small decimal constant like
3.6, the constant is interpreted as a double precision value and the
comparison fails with the following message:
# SELECT * FROM tr_table_okpx WHERE prating = 3.6;
Unable to
OK..change another thing and try again.
1 Increase Timeout value in the file /etc/httpd/conf/httpd.conf.
2 Restart http server by /sbin/service httpd restart command.
3 Now run your PHP script again.
I think the problem is not in PostgreSQL, the problem is somewhere
in PHP or http server.
On Mon, Oct 03, 2005 at 03:31:42PM +0200, Daniel Schregenberger wrote:
Hi,
I recently stumbled uppon the following thing:
If I compare a field of type numeric to a small decimal constant like
3.6, the constant is interpreted as a double precision value and the
comparison fails with the
Guys,
We have an in-house application that absolutely has to run against MS
Sql Server. We also have an application that doesn't, but that needs
to integrate with that MSSQL database.
I'm considering any options, including using application code as an
integration point. I'd prefer to somehow
Hi guys,
I am searching for a function that enables me to strip the trailing
zeros in the fractional part of a number (numeric type). For example a
number saved in a column of type numeric as such: 23.45000 would be
returned as 23.45
I can't find any function that does this in the documentation,
Using SQL*Server, and OLEDB or ODBC data source can be connected as a
linked server. Then, TSQL queries can go against PostgreSQL tables as
though they were ordinary SQL*Server tables (but they have 4 part names
instead of 3 part names).
-Original Message-
From: [EMAIL PROTECTED]
Did you look at the round function?
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Giovanni M.
Sent: Monday, October 03, 2005 11:45 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] strip zeros from fractional part
Hi guys,
Round and trunc dont provide the functionality I need.
Say for example I have two values in a column of type numeric as follows:
23.455
12.300
What I need to happen is stripping the useless zeros in the
fractional part of numbers so 12.300 would become 12.3 and 23.455
would stay the same
Round
On 10/3/05, Giovanni M. [EMAIL PROTECTED] wrote:
Round and trunc dont provide the functionality I need.
Say for example I have two values in a column of type numeric as follows:
23.455
12.300
What I need to happen is stripping the useless zeros in the
fractional part of numbers so 12.300
Thank you very much Mike. I will do just that.
FernandoOn 9/30/05, Mike Nolan [EMAIL PROTECTED] wrote:
User1 starts order and takes the last two units. User2 starts order 1 minut= e after and checks inventory. He sees 2 units left and adds them to the his order. User1 commits his order. Now
I'm making a query to return an int and a bytea as two columns in my
query, so I set up my PQExecParams call like so:
res = PQexecParams(conn,q,0,0,0,0,0,1)
I can view the binary data just fine, but not the int. How do I do that?
---(end of
Yes! That did it, thanks for the help
On 10/3/05, Tony Wasson [EMAIL PROTECTED] wrote:
On 10/3/05, Giovanni M. [EMAIL PROTECTED] wrote:
Round and trunc dont provide the functionality I need.
Say for example I have two values in a column of type numeric as follows:
23.455
12.300
Can anyone suggest good forums software to use with postgresql? I want to
integrate the forums users into my website's user base with a view.
I know of FudForums but it doesn't work well with views (the upgrade script
in particular chokes very badly on them) and seems kinda buggy in general.
On Wed, 2005-09-28 at 09:07 +0200, hubert depesz lubaczewski wrote:
database has quite huge load of updates, but i thought that vacum will
guard me from database bloat, but from what i observed it means that
vacuuming of b-tree indices is somewhat faulty.
No, thats perfectly normal.
Indices
On Mon, 2005-10-03 at 16:38, Chris St Denis wrote:
Can anyone suggest good forums software to use with postgresql? I want to
integrate the forums users into my website's user base with a view.
I know of FudForums but it doesn't work well with views (the upgrade script
in particular chokes
On Mon, Oct 03, 2005 at 12:37:30PM -0700, Ben wrote:
I'm making a query to return an int and a bytea as two columns in my
query, so I set up my PQExecParams call like so:
res = PQexecParams(conn,q,0,0,0,0,0,1)
I can view the binary data just fine, but not the int. How do I do that?
The
On 10/3/05, Dann Corbit [EMAIL PROTECTED] wrote:
Using SQL*Server, and OLEDB or ODBC data source can be connected as a
linked server. Then, TSQL queries can go against PostgreSQL tables as
though they were ordinary SQL*Server tables (but they have 4 part names
instead of 3 part names).
On 10/3/2005 12:12 AM, Tom Lane wrote:
Samik Raychaudhuri [EMAIL PROTECTED] writes:
... What I wanted is a no-trace (or minimal trace), no-admin required
kind of installation (I won't be able to create a non-admin user in the
comp), which, when I am done, I can just delete the installation
Does postgres support in-memory only tables like the mysql HASH table type?
I want to store some session data which I need quick access of, but don't
care of it's lost on server stop/start
---(end of broadcast)---
TIP 9: In versions below 8.0, the
Perfect, thanks!
On Oct 3, 2005, at 4:29 PM, Michael Fuhr wrote:
On Mon, Oct 03, 2005 at 12:37:30PM -0700, Ben wrote:
I'm making a query to return an int and a bytea as two columns in my
query, so I set up my PQExecParams call like so:
res = PQexecParams(conn,q,0,0,0,0,0,1)
I can view the
On Oct 3, 2005, at 5:38 PM, Chris St Denis wrote:
Can anyone suggest good forums software to use with postgresql? I
want to
integrate the forums users into my website's user base with a view.
Drupal has a forums module and works well with PostgreSQL.
http://drupal.org
John DeSoi, Ph.D.
Chris St Denis [EMAIL PROTECTED] writes:
Does postgres support in-memory only tables like the mysql HASH table type?
No, and it doesn't seem particularly necessary: a table that is being
hit heavily will stay in cache buffers anyhow. You don't need any
special mechanism.
I have installed PostgreSQL 8 and latest
pgODBC and ADO
drivers but still I am not able to connect to it from access or VB 6. Kindly
help me.
Aman Tur
I thought it might be of interest to some to post steps to using
PostgreSQL on
Windows with the Dev-Cpp/MINGW IDE/compiler.This example is C, but the
steps for configuring the IDE/Project to use the PostgreSQL libs/headers
should be the same or very similar for C++/ecpg.
Install PostgreSQL for
am 03.10.2005, um 18:48:03 +0530 mailte Aman Tur folgendes:
I have installed PostgreSQL 8 and latest pgODBC and ADO drivers but still I
am not able to connect to it from access or VB 6. Kindly help me.
Instead HTML-mail with a picture you should better post a detailed
error-message and
On Oct 3, 2005, at 1:05 AM, Jeff Davis wrote:
What pg_dump backup modes do people usually use for a backup of an
entire database cluster? I usually use plaintext and pipe it through
gzip, however, that doesn't allow you to restore single objects from a
complete backup.
Is there a way to back
36 matches
Mail list logo
