On Wed, Dec 31, 2003 at 02:07:01PM +0530, omkar prabhu wrote:
Hi,
I am trying to dump large object data( from a database containing table consist of 4
lo fields)
I get following error.
I am using postgres 7.2.1 which is installed from rpm
Command use is
pg_dump -Ft -b test1 db.tar
Joseph Lemm wrote:
IN RELATION TO THIS POST:
On Sun, Jan 26, 2003 at 06:31:50PM +0530, shreedhar wrote:
Hi All,
Before indexing query plan was showing cost as 40.00, after indexing query
plan again showing as 'seq scan' and cost as 3060.55.
The field which i indexed is primary key to this
Chad N. Tindel wrote:
Is there a way to kill all the connections to a DB so that it can safely
be dropped? Given that connections to a DB can come from any number of clients,
the only way I've found to do this is to shutdown postgres, which is clearly
an unacceptable solution because it stops
Nigel Bishop mentioned :
= Has anyone come across a ERD tool for postgres - preferably free
Hi,
I've been enjoying the new dbvisualizer for java.
It's really easy to register new drivers and it draws
very pretty reverse engineered ERD's and the
printing works quite well :
Hi All,
In our company we are planning for a migration from an
MS SQL/NT to PostgreSQL/Linux. The current database contains
mainly SQL standard data types(though a few user defined data types
may be there), is using Triggers and Stored procedures.
I have already seen the migration howtos
Hello dear list!
I am using postgresql 7.3.3 .Last night the errors occured.
Since then I can't start the postgresql !We are recovering from the type
by now ,but what happened?Is that a known bug?What to do next time?
The last change I made was that:
syslog=1
log_min_error_statement
Gaetano, thanks.
My db has only one table (about 29,000 records), so I thought leaving
postgreqsql.conf at its defaults would be OK: the params you mention are
commented out, so they must be at their defaults, tho I can't tell what the
defaults are.
Are there any docs that talk specificially
On Mon, Jan 05, 2004 at 02:14:37PM +0200, Tsirkin Evgeny wrote:
Hello dear list!
I am using postgresql 7.3.3 .Last night the errors occured.
^
by now ,but what happened?Is that a known bug?What to do next time?
Yes, it's a known bug, and is the very reason
Thanks!
Now another two questions:
Is there any official bug report on this that i can show to
my boss?
Should i upgrade to 7.3.4 to fix that bug or it is better to get newly
version?
What i need is to restore my corrupted db from the tape ,upgrade postgresql
(say from rpm) and just start the
On Mon, Jan 05, 2004 at 04:07:34PM +0200, Tsirkin Evgeny wrote:
Thanks!
Now another two questions:
Is there any official bug report on this that i can show to
my boss?
Yes, it's in the release notes. IIRC, there were like 24 or 48 hours
between the releases because of this. Tom Lane
Hi,
Short question how to fetch datas from Postgres into XML files without
using PHP on server, I need to optimize and to find the best way to do
it. Can someone help me. Is it possible
Rg
Andrzej Schulz
---(end of broadcast)---
TIP 3: if
Joseph Lemm wrote:
Gaetano, thanks.
My db has only one table (about 29,000 records), so I thought leaving
postgreqsql.conf at its defaults would be OK: the params you mention are
commented out, so they must be at their defaults, tho I can't tell what the
defaults are.
The values on the line
Also take a look at Annotated postgresql.conf and Global User Configuration
(GUC) Guide
http://www.varlena.com/GeneralBits/Tidbits/annotated_conf_e.html
- Original Message -
From: Gaetano Mendola [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Joseph Lemm [EMAIL PROTECTED]
Sent: Monday,
Probably a dumm question ,but it is better to ask then be sorry.
Nothing is changed in config files ,so i am extractiing
the binary from rpm ,copy it to the place and start the server,right?
And thanks again!
On Mon, 5 Jan 2004 09:09:55 -0500, Andrew Sullivan
[EMAIL PROTECTED] wrote:
On Mon, Jan
On Mon, Jan 05, 2004 at 04:48:00PM +0200, Tsirkin Evgeny wrote:
Probably a dumm question ,but it is better to ask then be sorry.
Nothing is changed in config files ,so i am extractiing
the binary from rpm ,copy it to the place and start the server,right?
And thanks again!
If you're upgrading
On Mon, 5 Jan 2004 11:23:08 -0500, Andrew Sullivan
[EMAIL PROTECTED] wrote:
I want to keep my configs.Of course i can save my postgresql.conf
(and other files that i changed and don't currently remember)
to another location and then put it back in place of what rpm will
put ,but as i said ,i
On Mon, Jan 05, 2004 at 07:35:16PM +0200, Tsirkin Evgeny wrote:
On Mon, 5 Jan 2004 11:23:08 -0500, Andrew Sullivan
[EMAIL PROTECTED] wrote:
I want to keep my configs.Of course i can save my postgresql.conf
(and other files that i changed and don't currently remember)
to another location
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (John Siracusa) wrote:
The docs say:
Clustering is a one-time operation: when the table is subsequently
updated, the changes are not clustered. That is, no attempt is made
to store new or updated rows according to their index
Hello dear list!
I am using postgresql 7.3.3 .Last night the errors occured.
Since then I can't start the postgresql !We are recovering from the type
by now ,but what happened?Is that a known bug?What to do next time?
The last change I made was that:
syslog=1
log_min_error_statement
log_timestamp
Hello!
Could you please let me know what is the data type for an image in
postgresql.
Thank you
Catherine
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
Dears,
I wish to configure files to start-up the database. I read
/contrib/start-scripts/linux, but, I don't undestand the sequence step to
configure.
Thanks in advanced.
Juan Carlos Bronzetti
System Engineer
SIEMENS Mercosur
ICN RCC SWD Mercosur
Calle 122 (Ex Gral. Roca) 4785
Ruta 8 Km 18-
Hi,
could you please let me know how to represent an image when creating a data
table using
postgresql
thanks
ganesh
---(end of broadcast)---
TIP 8: explain analyze is your friend
On 1/4/04 6:24 PM, Christopher Browne wrote:
The cluster operation potentially has to reorder all the tuples, and
the fact that the table is already _partially_ organized only
diminishes the potential. If the new data, generally added at the
end, has values that are fairly uniformly
John, et al,
We too have an interest in reclustering large tables, but in our
case most of the transactions are spread throughout the table
(though in some cases not uniformly).
I have been pondering a program that selects all the rows in
the table in cluster order and then, as a single
On Mon, 2004-01-05 at 05:47, Amitava Roy wrote:
Hi All,
In our company we are planning for a migration from an
MS SQL/NT to PostgreSQL/Linux. The current database contains
mainly SQL standard data types(though a few user defined data types
may be there), is using Triggers and Stored
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 are your concerns
Hi,
PostgreSQL 7.3.4 on i386-portbld-freebsd4.9, compiled by GCC 2.95.4
pg_hba.conf has following entry:
#
local all pgsqlmd5
#
hostname# /usr/local/etc/rc.d/010.pgsql.sh start
Password:
^C
So. If i try to start postgre (or machine boots
27 matches
Mail list logo