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 up)
On Mon, 5 Jan 2004 12:39:20 -0500, Andrew Sullivan
<[EMAIL PROTECTED]> wrote:
The only things that should make a difference to you should be in the
/etc directory, assuming the RPM follows the filesystem standard (I
believe it does).
It does not ,rpm puts the staff in /var/lib
My suggestion is t
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
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 transact
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 dist
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
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
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 =
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 regardin
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
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 loca
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 do
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 upgradi
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, Ja
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:
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 comme
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 posting/
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 occa
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 serv
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 7.
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 about
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_tim
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 availab
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 :
http://www.minq.se/pro
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 acc
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 table.
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
28 matches
Mail list logo
