Scott cox [EMAIL PROTECTED] writes:
I am running PostgreSQL 8.0 on WinXP
When I try to connect
psql.exe -h localhost -p 5432 template1 postgres
I have to wait
30 seconds before the Password: Prompt arrives
30 seconds after the password is entered.
Once I am connected access is fast. I
# [EMAIL PROTECTED] / 2005-07-14 00:57:57 -0400:
On Thu, Jul 14, 2005 at 02:46:01PM +1000, Neil Conway wrote:
Vivek Khera wrote:
The first sentence rules out MySQL, so the second sentence should read
So that leaves Postgres. Your problem is solved ;-)
(If you are accustomed to
Neil == Neil Conway [EMAIL PROTECTED] writes:
Neil Does MySQL with InnoDB not qualify as an ACID-compliant database?
Not when you can store a value that is larger than allowed, and it
is silently truncated to be within range. no *I* integrity there.
That's regardless of InnoDB or not.
MySQL
Am Donnerstag, den 14.07.2005, 00:57 -0400 schrieb Alvaro Herrera:
On Thu, Jul 14, 2005 at 02:46:01PM +1000, Neil Conway wrote:
Vivek Khera wrote:
The first sentence rules out MySQL, so the second sentence should read
So that leaves Postgres. Your problem is solved ;-)
(If you are
David Mitchell wrote:
What is the best way to quickly and reliably stop postgres? We've found
that pg_ctl doesn't work for us very well, frequently failing to
actually stop the postmaster (it times out and reports that it has
failed to stop). This is the same even if we use -m immediate.
The first sentence rules out MySQL, so the second sentence should
read So that leaves Postgres. Your problem is solved ;-)
(If you are accustomed to Oracle, you are probably
expecting an ACID
database, which rules out MySQL too).
Does MySQL with InnoDB not qualify as an
David Mitchell [EMAIL PROTECTED] writes:
What is the best way to quickly and reliably stop postgres? We've found
that pg_ctl doesn't work for us very well, frequently failing to
actually stop the postmaster (it times out and reports that it has
failed to stop). This is the same even if we
On Wed, 2005-07-13 at 23:57, Alvaro Herrera wrote:
On Thu, Jul 14, 2005 at 02:46:01PM +1000, Neil Conway wrote:
Vivek Khera wrote:
The first sentence rules out MySQL, so the second sentence should read
So that leaves Postgres. Your problem is solved ;-)
(If you are accustomed to
To everyone,
Thanks very much for your replies, and if these responses are any indication
of Postgres quality then I'd be in good hands.
Ted
_
Dont just search. Find. Check out the new MSN Search!
On Jul 13, 2005, at 9:57 PM, Alvaro Herrera wrote:On Thu, Jul 14, 2005 at 02:46:01PM +1000, Neil Conway wrote: Vivek Khera wrote: The first sentence rules out MySQL, so the second sentence should read "So that leaves Postgres". Your problem is solved ;-)(If you are accustomed to Oracle, you are
I'm using PG 8.0.1 on Gentoo Linux (kernel 2.6.10 SMP) on Pentium 4 w/ HT.
I run the following as root:
su postgres -c pg_ctl stop -D /var/lib/postgresql/data -m fast
Or with -m immediate. Some of the backends stop but others never
shutdown. Even if I do a killall postmaster (just with
David Mitchell [EMAIL PROTECTED] writes:
I run the following as root:
su postgres -c pg_ctl stop -D /var/lib/postgresql/data -m fast
Or with -m immediate. Some of the backends stop but others never
shutdown. Even if I do a killall postmaster (just with sigterm, not -9),
these backends hang
Hello Everyone,
I considering moving a product to Solaris/Linux and trying to find a good
DB. Oracle is out due to cost so as far as i know the only reasonable
alternatives are Postgres or Codebase or MySQL. Does anyone here have any
experience using Codebase or MySql? If I stick with a
Am Dienstag, den 12.07.2005, 17:16 + schrieb Ted Slate:
Hello Everyone,
I considering moving a product to Solaris/Linux and trying to find a good
DB. Oracle is out due to cost so as far as i know the only reasonable
alternatives are Postgres or Codebase or MySQL. Does anyone here
There are a number of good, objective, and informative comparisons
available on the Internet, such as http://www.databasejournal.com/sqletc/article.php/3486596.
You can Google something like "Postgresql mysql firebird comparison" to access
these. I am migrating an application from Paradox
@postgresql.org
Subject: [GENERAL] To Postgres or not
Hello Everyone,
I considering moving a product to Solaris/Linux and trying to find a good
DB. Oracle is out due to cost so as far as i know the only reasonable
alternatives are Postgres or Codebase or MySQL. Does anyone here have any
experience
On Jul 12, 2005, at 1:16 PM, Ted Slate wrote:
If I stick with a true RDBMS then Codebase is out. So that leaves
Postgres and MySQL.
The first sentence rules out MySQL, so the second sentence should
read So that leaves Postgres. Your problem is solved ;-)
(If you are accustomed to
On Tue, Jul 12, 2005 at 05:16:44PM +, Ted Slate wrote:
Hello Everyone,
I considering moving a product to Solaris/Linux and trying to find a
good DB. Oracle is out due to cost so as far as i know the only
reasonable alternatives are Postgres or Codebase or MySQL. Does
anyone here have
Even though PostgreSQL is more like an Oracle which is a good thing.
It's like Oracle in function not in cost and adminstration. PostgreSQL
not only fits into the enterprice really well it also fits in the mom
and pop shops(dentist office,corner store, you name it that may not
have any IT folks.
On Wed, Jul 13, 2005 at 04:24:53PM -0400, Vivek Khera wrote:
On Jul 12, 2005, at 1:16 PM, Ted Slate wrote:
If I stick with a true RDBMS then Codebase is out. So that leaves
Postgres and MySQL.
The first sentence rules out MySQL, so the second sentence should
read So that leaves
What is the best way to quickly and reliably stop postgres? We've found
that pg_ctl doesn't work for us very well, frequently failing to
actually stop the postmaster (it times out and reports that it has
failed to stop). This is the same even if we use -m immediate.
We don't want to kill -9,
Vivek Khera wrote:
The first sentence rules out MySQL, so the second sentence should read
So that leaves Postgres. Your problem is solved ;-)
(If you are accustomed to Oracle, you are probably expecting an ACID
database, which rules out MySQL too).
Does MySQL with InnoDB not qualify as
On Thu, Jul 14, 2005 at 02:46:01PM +1000, Neil Conway wrote:
Vivek Khera wrote:
The first sentence rules out MySQL, so the second sentence should read
So that leaves Postgres. Your problem is solved ;-)
(If you are accustomed to Oracle, you are probably expecting an ACID
database,
Message -
From: Tom Lane [EMAIL PROTECTED]
To: Prasad Duggineni [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org; Devrim GUNDUZ [EMAIL PROTECTED]
Sent: Tuesday, June 21, 2005 10:23 AM
Subject: Re: [GENERAL] 8.03 postgres install error
Prasad Duggineni [EMAIL PROTECTED] writes:
Please advice
Hi,
On Wed, 22 Jun 2005, Prasad Duggineni wrote:
I have updated the software still it is occurring whenever I reboot my
computer. I don't have any references to old config file.Please advice me to
fix this problem.
Hrrm... Did you use rpm -Uvh while upgrading? I hope you did not...
--
11:06 AM
Subject: Re: [GENERAL] 8.03 postgres install error
Hi,
On Wed, 22 Jun 2005, Prasad Duggineni wrote:
I have updated the software still it is occurring whenever I reboot my
computer. I don't have any references to old config file.Please advice me
to fix this problem.
Hrrm... Did you
:41 EDT
ERROR:
unrecognized configuration parameter ksqo
Thanks
Prasad
- Original Message -
From: Devrim GUNDUZ [EMAIL PROTECTED]
To: Prasad Duggineni [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Wednesday, June 15, 2005 11:11 AM
Subject: Re: [GENERAL] 8.03 postgres install
Prasad Duggineni [EMAIL PROTECTED] writes:
Please advice me to fix this problem.
Jun 20 18:38:41 lab5md9181 postgres[2552]: [2-1] 2005-06-20 18:38:41 EDT
ERROR:
unrecognized configuration parameter ksqo
KSQO has been obsolete for nigh five years now. Update whatever
software you are using
On Tue, Jun 21, 2005 at 10:01:00AM -0400, Prasad Duggineni wrote:
I did install successully postgres 8.03 but I am getting the following
error message in the syslog eventhough /var/pgsql/data is pointing to new
configuration file which is postgres 8.03.
ksqo is configuration parameter for
I am getting the following error when i try to
install the postgres 8.03 . It seems to be problem with the installing postgres
libs. Plesae advice me to fix this problem.
warning: postgresql-libs-8.0.3-1PGDG.i686.rpm: V3
DSA signature: NOKEY, key ID 748f7d0eerror: Failed
dependencies:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 15 Jun 2005, Prasad Duggineni wrote:
I am getting the following error when i try to install the postgres 8.03 . It
seems to be problem with the installing postgres libs. Plesae advice me to fix
this problem.
warning:
Hi!In MS
Access/PostgreSQL combination I have login form. After user writes all
neccessary inputs and push the button, a startup procedure creates DSN-less
connection string, receates all linked tables and change connection string
in all pass-through queries. It works nice...But, how to
Shaun Clements wrote:
Problem there is the pg_dump requires a password.
Ah - you'll be wanting the .pgpass password file - there's a section
in the manuals under Client Interfaces/libpq
Not the place you'd first look, I'll admit.
Oh - might be worth googling for .pgpass and windows in case
Title: RE: [GENERAL] Automate Postgres Backup In windows - resolved
Thanks Richard.
For anyone interested
The link Richard was referring to can be found below.
http://www.postgresql.org/docs/8.0/interactive/libpq-pgpass.Html
Kind Regards,
Shaun Clements
-Original Message
Apologies if this post is a repeat.
I am trying to automate a postgres database data and schema
dump through windows.
Does anyone have any suggestions on best way to do
so.
Thanks
Kind Regards,Shaun
Clements
Shaun Clements wrote:
Apologies if this post is a repeat.
I am trying to automate a postgres database data and schema dump through
windows.
Does anyone have any suggestions on best way to do so.
Thanks
Call pg_dump via a batch-file and run it from the Windows scheduler? Or
am I missing
I am trying to automate a postgres database data and schema
dump through windows.
Does anyone have any suggestions on best way to do
so.
Thanks
Kind Regards,Shaun
Clements
Bonjour,
je me tourne vers vous car je n'arrive pas à solutionner mon probleme
qui est le suivant :
Je dois créer une Bd Postgres avec une table qui doit utiliser un
champ auto incrémental d'un pas de 6.
J'ai trouvé le type auto incrémental qui est SERIAL , mais je n'arrive
pas à voir
: [GENERAL] aide postgres
Bonjour,
je me tourne vers vous car je n'arrive pas à solutionner mon probleme
qui est le suivant :
Je dois créer une Bd Postgres avec une table qui doit utiliser un
champ auto incrémental d'un pas de 6.
J'ai trouvé le type auto incrémental qui est SERIAL
What is the easiest way to reset the postgres user password?
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
On Apr 6, 2005, at 8:22 AM, D A GERM wrote:
What is the easiest way to reset the postgres user password?
Using the ALTER USER command. If you don't know the password,
temporarily modify the pg_hba.conf file to allow local connections
without a password ('trust'). You can then login without the
Our company is
moving toward developing web applications in the DNN 3 (Dot Net Nuke)
framework. We currently have several applications supported by
Postgres/PostGIS due to the spatial requirements. To ideally bridge these
two technologies together would be to develop a DNN DataProvider
There is a .NET data provider that I know of but its not specific to DNN in any way. It can be used in any .NET project
http://gborg.postgresql.org/project/npgsql/projdisplay.php
Best Regards,
Joe AudetteRandy How [EMAIL PROTECTED] wrote:
Our company is moving toward developing web
Dear All,
I facing problem in my log rotation for postgres, it
is not rotation properly. I am using syslog-ng package
for loging.
My logs for postgres looks like this,
-rw-r--r--1 root root 10M Feb 28
23:24 postgres.log.20
-rw-r--r--1 root root0 Feb 28
[EMAIL PROTECTED] wrote:
Hi!
I'm considering the possibility of using postgres in embededded
environment with VxWorks (RTOS) Hitachi SH4 processor.
Can anyone tell me if porting postgres to such a platform is possible?
If yes, which version of postgres supports this?
You
Hi!
Im considering the possibility of using postgres in embededded
environment with VxWorks (RTOS) Hitachi SH4 processor.
Can
anyone tell me if porting postgres to such a platform is possible? If yes,
which version of postgres supports this?
You may
provide me some reference links
Hi,
Any body has successfully installing postgres 8 using Remote Desktop
Connection for windows 2003 server web edition?
I am keep getting rdp session instead of console. Even using command : mstsc
/v:servername /console.
with this command I can see several others rdp sessions. which means I
Dear Sir /Madam,
Weare working on Linux suse
9.0 and we have installed Postgres 7.3 through yast with the privileges of
"root" user. But we are not able to start / configure the
postgres database, Kindly help us in configuring and starting the same database
and how can we create database
On Dec 10, 2004, at 4:26 AM, Vikas Kumawat wrote:
x-tad-biggerDear Sir /Madam,/x-tad-bigger
x-tad-biggerWe are working on Linux suse 9.0 and we have installed Postgres 7.3 through yast with the privileges of /x-tad-biggerx-tad-biggerroot/x-tad-biggerx-tad-bigger user. But we are not able to
I am posting this to the General and JDBC groups so that it's in the
archive -- I know many people have had problems with Latin1 characters, and
I'd like to share what has worked for us. If anyone can add this
information to a more permanent FAQ, I'd be much obliged.
---
Using Postgres with
Hi All,
I would appreciate any input on this dilemma:
I have DataBase-A which is Oracle on Server A with FunctionA
(PLSQL)
I have DataBase-B which is Postgress on Server B with FunctionB
(PgSQL)
I need to call FunctionA from FunctionB
I dont mind rewriting PgSQL
Shah, Sameer [EMAIL PROTECTED] writes:
1. I have DataBase-A which is Oracle on Server A with FunctionA
(PLSQL)
2. I have DataBase-B which is Postgress on Server B with FunctionB
(PgSQL)
3. I need to call FunctionA from FunctionB
As far as I know, the on'y way to do
Doug McNaught [EMAIL PROTECTED] writes:
Shah, Sameer [EMAIL PROTECTED] writes:
1. I have DataBase-A which is Oracle on Server A with FunctionA
(PLSQL)
2. I have DataBase-B which is Postgress on Server B with FunctionB
(PgSQL)
3. I need to call FunctionA
Has anyone successfully done this? I've got cygwin and the
very first step crashes -
bash-2.05$ pwd
pwd
/cygdrive/e
bash-2.05$ cd postgresql-7.4.5
cd postgresql-7.4.5
bash-2.05$ ./configure
./configure
bash: ./configure: bad interpreter: No such file or directory
bash-2.05$
--
% Randy Yates
Have you tested it with regular pg_connects instead of pg_pconnect? while
many people expect pconnects to be faster, often, when they result in the
database having lots of open idle connections, they actually make the
system slower than just using plain connects.
You might want to look into
Has anyone had success loading the Postgres JDBC drivers
into WSAD ?
Whenever I attempt a connection I receive the following error:
Jeffrey
Stonebrook
attachment: image001.jpg
Hello,
I am not personally a java fiend but it looks like you are trying to use
the PostgreSQL JDBC driver with SSL. I am unsure if that is possible
with the community version. At least it didn't used to be.
Sincerely,
Joshua D. Drake
Stonebrook, Jeff wrote:
--
Has anyone had success loading
On Mon, 3 May 2004, Stonebrook, Jeff wrote:
Has anyone had success loading the Postgres JDBC drivers into WSAD ?
Whenever I attempt a connection I receive the following error:
[Reason: Problems encountered while loading the jdbc driver.
Reason: javax.net.ssl.SSLSocket
]
Please do not
How is it possible for Postgresql to freak out and take out the
machine?
How easy/likely is it for a program run as a normal user to
blue screen an MS server?
How easy/likely is it for a program run as a normal user to
do the equiv to
a FreeBSD/Linux server?
With *decent drivers*
At 06:13 PM 4/23/2004 +0200, Magnus Hagander wrote:
MS built-in task manager doesn't let you kill all processes.
It will let you kill any processes at your own level of permissions,
just as Unix will. The difference is that a local admin on the machine
is not equal to root, and can still not
: [GENERAL] FW: Postgres alongside MS SQL Server
Hello,
Well it of course depends on what you are doing. Traditionally I would
say, Are you nuts? but it really depends
on what you are doing. It is all about risk... if PostgreSQL freaks out
and takes out the machine, what will happen
to the MS SQL
Hello,
Well it of course depends on what you are doing. Traditionally I would
say, Are you nuts? but it really depends
on what you are doing. It is all about risk... if PostgreSQL freaks out
and takes out the machine, what will happen
to the MS SQL server? What about cost associated with
On Tue, 20 Apr 2004, Bruno Wolff III wrote:
On Tue, Apr 20, 2004 at 14:36:57 +0100,
csysi [EMAIL PROTECTED] wrote:
Hello, i upgrade postgres version 7.1 to version 7.4.2 and it tell me that
the databases are incompatible.
Can i convert the databases ?
You need to do a dump and
Hello, i upgrade postgres version 7.1 to version 7.4.2 and it tell me that
the databases are incompatible.
Can i convert the databases ?
Thank´s for the help
Jorge
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to
Quoting csysi [EMAIL PROTECTED]:
Hello, i upgrade postgres version 7.1 to version 7.4.2 and it tell me that
the databases are incompatible.
Can i convert the databases ?
Thank´s for the help
Jorge
---(end of broadcast)---
TIP
On Tue, Apr 20, 2004 at 14:36:57 +0100,
csysi [EMAIL PROTECTED] wrote:
Hello, i upgrade postgres version 7.1 to version 7.4.2 and it tell me that
the databases are incompatible.
Can i convert the databases ?
You need to do a dump and reload to go between major releases (e.g.
from 7.1.x to
Hi,
Ive been working with Postgres for about a year, so Im little
better than a newbie with Postgres internal architecture or its means of
getting tricksy things done. Ive experience in Linux working with PostgreSQL
7.3, stored procedures in PL/pgSQL, and writing specialized shared
I am currently working on a Java web application. We are making use of
the JDBC driver for Postgres 7.4.1. Part of our application allows the
administrators to manage a large number of small images, most of them
not exceeding 5KB. There is about a gigabyte of these small files.
We're
On Thursday 04 March 2004 01:03, Matthew Hixson wrote:
[snip]
I recently discovered the Hibernate project and was pleasantly
surprised how simple it was to store an image in Postgres as a bytea
using Hibernate's BLOB support. I'm wondering if Postgres would have
any problem handling all of
Hi everybody,
currenty we use Suse Linux 9 and the rpms with 7.4.0 downloaded from
ftp://ftp.gmd.de/mirrors2/suse/ftp.suse.com/people/max/postgresql-7.4/ .
I don't know how to contact the person who build this rpms ,
and i cannot find other resources on the web, so does anyone
know a place to
I am currently working on a Java web application in which we are making
use of the JDBC driver for Postgres 7.4.1. Part of our application
allows the administrators to manage a large number of small images,
most of them not exceeding 5KB. There is about a gigabyte of these
small files.
Hi to all,
those helped or enjoyedmy english. I waited over the day to give a summary.
your pgsql backend must be able to accommodate the max persistent
connections * the max number of apache daemons.
the php pgsql.max_persistent setting is per apache daemon.
All of your answers where
Cheer,
If you want to make a cold backup, be carreful if you have distributed
your database on different disks with symbolic links or by using the initloaction
command as a tar or cpio won't save the symbolic tree . Otherwise you can
save all your $PGDATA directory and copy it on your new
(B
(B
(BHi
(BI've built up 30 gig database on a performance test
(Bmachine which
(Bnow needs to be transferred over onto the
(Bproduction hardware
(Bwhich will be going live.
(BThe documentation suggests using pg_dump or a file
(Bsystem level backup
(B- does anyone have any
-BEGIN PGP SIGNED MESSAGE-
(BHash: SHA1
(B
(B
(BIf the test and productive machine are the same type (i.e. intel) and the
(Bpostgresql version is the same then I would try to do a filesystem copy.
(BJust make sure both machines have the postmaster shut down and then copy over
hello,
Iam trying to install postgres-7.4.1 on my tru64 (O.S version 5.1A) box
without the shared library support.
Here's my list of commands:
./configure --with-includes=/opt/gcc-33/include --prefix=/tools/postgres-741
--disable-shared
gmake
gmake install
The gmake successfully compiles the
After I installed the driver I found three DLL
files from windows(2000) ODBC manager :
psqlodbc.dll
psqlodbc25.dll
psqlodbc30w.dll
What's the difference ?
Thanks .
---(end of broadcast)---
TIP 2: you can get off all lists at once with the
Tom,
Actually, I've never had a corrupted firebird database. There were
two bugs in an older version of InterBase that produced income for me.
The first was a failure to realize that a file had just gone over 4Gb
and therefore the word holding the offset had rolled over and the system
had
Eric wrote:
Hi,
I would like to know if a daemon exist to intercept Oracle queries and
translate to postgresql query...
I have a windows app (AccPac) that connect to an Oracle server via
ODBC. I would like to replace the Oracle server with a postgresql.
Accpac support only Oracle, DB2,
LitelWang wrote:
After I installed the driver I found three DLL
files from windows(2000) ODBC manager :
psqlodbc.dll
psqlodbc25.dll
psqlodbc30w.dll
What's the difference ?
The different versions of the ODBC protocol they support.
Thanks .
---(end of
Can you give the details ?
Or some Web links .Thanks.
===
LitelWang wrote:
After I installed the driver I found three DLL
files from windows(2000) ODBC manager :
psqlodbc.dll
psqlodbc25.dll
psqlodbc30w.dll
What's the difference ?
The different versions of
I just installed RH9 on a new machine and installed postgres in the
installation process. I got the following error when trying to
start the postmaster so... I tried removing the postgres software
then reinstalling. rpm first said the software was not installed
then when I tried to reinstall
On Tue, 23 Dec 2003 [EMAIL PROTECTED] wrote:
I just installed RH9 on a new machine and installed postgres in the
installation process. I got the following error when trying to
start the postmaster so... I tried removing the postgres software
then reinstalling. rpm first said the software
Hello list,
What's the right way to uninstall postgres 7.4 in Linux (RH 8)?.
Thanks in advance
--
Josué Maldonado
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes
Hello Scott,
I forgot to mention that, it was installed from source. Thanks for
anwsering.
scott.marlowe wrote:
On Fri, 12 Dec 2003, Josué Maldonado wrote:
Hello list,
What's the right way to uninstall postgres 7.4 in Linux (RH 8)?.
That really depends on how it was installed. If
On Fri, 12 Dec 2003, Josué Maldonado wrote:
Hello list,
What's the right way to uninstall postgres 7.4 in Linux (RH 8)?.
That really depends on how it was installed. If installed via RPM, then
you do 'rpm -e postgrespackagenameshere'. If it was installed from
source, 'make uninstall'. or
If anyone has any advice on building Postgres 7.4 for a freeBSD box it sure would be
welcome.
TIA,
Greg Williamson
DBA
GlobeXplorer LLC
--
well, it takes gmake to build Postgres..
having trouble installing 'gmake' on the BSD box; it started to do its BSD autoinstall
--On Friday, December 05, 2003 12:43:24 -0800 Gregory S. Williamson
[EMAIL PROTECTED] wrote:
If anyone has any advice on building Postgres 7.4 for a freeBSD box it
sure would be welcome.
cvsup your ports tree, cd /usr/ports/databases/postgresql7; make; make
install
TIA,
Greg Williamson
DBA
--On Friday, December 05, 2003 17:29:06 -0500 Vivek Khera
[EMAIL PROTECTED] wrote:
LR == Larry Rosenman [EMAIL PROTECTED] writes:
LR --On Friday, December 05, 2003 12:43:24 -0800 Gregory S. Williamson
LR [EMAIL PROTECTED] wrote:
If anyone has any advice on building Postgres 7.4 for a freeBSD
LR == Larry Rosenman [EMAIL PROTECTED] writes:
LR --On Friday, December 05, 2003 12:43:24 -0800 Gregory S. Williamson
LR [EMAIL PROTECTED] wrote:
If anyone has any advice on building Postgres 7.4 for a freeBSD box it
sure would be welcome.
LR cvsup your ports tree, cd
LR == Larry Rosenman [EMAIL PROTECTED] writes:
LR PORTNAME?= postgresql
LR PORTVERSION?= 7.4
LR PORTREVISION?= 0
LR I did :-0)
I stand outdated ;-)
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index
Hi all-
I'm migrating to postgres from the MS SQL Server land, as I can see
a great potential with postgres, I was wondering if anyone has
experimented or started a project with XML inside user defined
functions?
I've seen the contrib/xml shipped with the distro, as I see it's
usefulness, it's
* Disk speed
4 drives... 7200 RPM... as big as you can get. Get 8 Meg cache drives so
you have a 3 year warranty.
* Hardware RAID
3Ware IDE controller (or SATA) running RAID 10
* Memory
2 gig
* Processor speed
1800+
* Processor type
Athlon MP
* Multiple processors
2
We are able to run
LitelWang wrote:
It is useful for me to use Chinese tone sort order .
Any version on Cygwin?
Thanks for any advice .
I never try GB18030 in Cygwin, but in Linux or other Unix system,
you may use gb18030 as client side encoding and use UNICODE as
backend encoding, and it's pretty good.
We're about to buy a new server for dedicated Postgres serving. It'll be
serving 4 - 10 databases (average dump size 20Gb) for various web
applications. What is the list's advice on optimum configuration of hardware
and software, given a smallish fixed budget (around $US 2000)? In
particular,
We're about to buy a new server for dedicated Postgres serving. It'll be
serving 4 - 10 databases (average dump size 20Gb) for various web
applications. What is the list's advice on optimum configuration of hardware
and software, given a smallish fixed budget (around $US 2000)? In
particular,
On Thu, 24 Jul 2003, tom dyson wrote:
We're about to buy a new server for dedicated Postgres serving. It'll be
serving 4 - 10 databases (average dump size 20Gb) for various web
applications. What is the list's advice on optimum configuration of hardware
and software, given a smallish fixed
Brian Maguire [EMAIL PROTECTED] writes:
I have a couple questions about Postgres and Views.
I am curious about what Postgres actually does in regards to views and
the internal steps that it takes.
Are these the steps that it takes for each query that includes a view?
1. Dynamically
- Original Message -
From: Brian Maguire [EMAIL PROTECTED]
To: Postgresql General Mail List [EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 6:44 PM
Subject: [GENERAL] Couple Postgres View Questions
I have a couple questions about Postgres and Views.
I am curious about what Postgres
Hi, there is a small problem here I have, I would appreciate any
suggestion.
We were using Postgres 7.2.x and later 7.3.x under Red Hat 8, and
everything worked fine. Clients are working under windows and are
communicating to Postgres via ODBC. This weekend we tried to upgrade to
Red Hat
901 - 1000 of 1052 matches
Mail list logo