Edward Coyle wrote:
I want to move a windows server 2003 based postgres database from one
server to another server, can I just copy and paste the base folder or
do I have to do a backup and restore? If so what options work best for
creating a file to move?
I think if you shut down postgresql
On May 31, 2006, at 9:18 PM, Chris wrote:
Edward Coyle wrote:
I want to move a windows server 2003 based postgres database from
one server to another server, can I just copy and paste the base
folder or do I have to do a backup and restore? If so what options
work best for creating a file
On Wed, May 31, 2006 at 15:34:46 -0500,
Edward Coyle [EMAIL PROTECTED] wrote:
I want to move a windows server 2003 based postgres database from one server
to another server, can I just copy and paste the base folder or do I have to
do a backup and restore? If so what options work best for
Jim Nasby wrote:
On May 31, 2006, at 9:18 PM, Chris wrote:
Edward Coyle wrote:
I want to move a windows server 2003 based postgres database from one
server to another server, can I just copy and paste the base folder
or do I have to do a backup and restore? If so what options work best
for
Chris [EMAIL PROTECTED] writes:
Jim Nasby wrote:
Actually, as long as you're not changing major versions (ie: 8.0.x to
8.1.x) you'll be fine.
I wasn't sure if changes like 8.1.x to 8.1.4 would cause a problem here:
We have a project policy that we *never* force initdb in a minor
release.
On Tue, May 09, 2006 at 08:57:57AM -0700, John Purser wrote:
I am running postgres 7.4.7 on debian sarge.
First:
psql -U PGSQL USER -o OUPUT FILE NAME --pset format=unaligned
--pset fieldsep=',' -c 'SQL COMMAND HERE' -d DATABASE NAME HERE
I think that will give you the output you were
On Fri, May 12, 2006 at 08:25:26AM +0930, Luke Vanderfluit wrote:
Does this mean libpq is part of the perl install?
Since libpq is under /usr/local/pgsql/lib/ doesn't that mean that it's
part of the postgresql install? Isn't then the postgres install 32 bit
and should be 64 bit?
libpq is
On Thu, May 11, 2006 at 02:55:04PM +0930, Luke Vanderfluit wrote:
Hi.
I've been able to compile postgresql on solaris 10.
Now I want to install the perl DBD::Pg module but I get a complaint, namely:
[EMAIL PROTECTED] # make
rm -f blib/arch/auto/DBD/Pg/Pg.so
Hi Martijn.
Martijn van Oosterhout wrote:
On Thu, May 11, 2006 at 02:55:04PM +0930, Luke Vanderfluit wrote:
Hi.
I've been able to compile postgresql on solaris 10.
Now I want to install the perl DBD::Pg module but I get a complaint, namely:
[EMAIL
[EMAIL PROTECTED] wrote:
A word of advice: if there is any chance that a column (e.g. text) contains
an embedded newline, you will be much better off outputting the data in
simple xml, instead of CSV. This works very well with Excel for import. I
just did a simple program for this recently.
Hi.
I've been able to compile postgresql on solaris 10.
Now I want to install the perl DBD::Pg module but I get a complaint, namely:
/~~~
[EMAIL PROTECTED] # make
rm -f blib/arch/auto/DBD/Pg/Pg.so
LD_RUN_PATH=/usr/local/pgsql/lib /opt/SUNWspro/bin/cc -G
-xarch=generic64
Greetings,
I am running postgres 7.4.7 on debian sarge.
I need to run an SQL query and store the results in a file. The format
needs to be comma separated values (CSV), so I can import this later in
Excel.
Any ideas on how to accomplish this?
much appreciated,
Ryan
On Tue, 09 May 2006 10:58:07 -0400
Ryan Suarez [EMAIL PROTECTED] wrote:
Greetings,
I am running postgres 7.4.7 on debian sarge.
I need to run an SQL query and store the results in a file. The
format needs to be comma separated values (CSV), so I can import this
later in Excel.
Any
: [GENERAL]
Exporting postgres query to CSV
It is possible to install postgres on usb driver to run it anywhere???
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
On Tue, 9 May 2006 16:54:37 -0400
Rodrigo Cortés [EMAIL PROTECTED] wrote:
It is possible to install postgres on usb driver to run it anywhere???
---(end of
broadcast)--- TIP 4: Have you searched our
list archives?
On 5/9/06, John Purser [EMAIL PROTECTED] wrote:
On Tue, 9 May 2006 16:54:37 -0400
Rodrigo Cortés [EMAIL PROTECTED] wrote:
It is possible to install postgres on usb driver to run it anywhere???
---(end of
broadcast)--- TIP 4: Have you searched
A) Possible is a BIG word. So is anywhere. If you could narrow
these two down a bit it might help answer your question.
possible mean how to do it
anywhere mean a pc with a windows os
---(end of broadcast)---
TIP 6: explain analyze is your
On Tue, 9 May 2006 17:06:53 -0400
Rodrigo Cortés [EMAIL PROTECTED] wrote:
On 5/9/06, John Purser [EMAIL PROTECTED] wrote:
On Tue, 9 May 2006 16:54:37 -0400
Rodrigo Cortés [EMAIL PROTECTED] wrote:
It is possible to install postgres on usb driver to run it
anywhere???
Im trying to
On Tue, 9 May 2006 17:10:21 -0400
Rodrigo Cortés [EMAIL PROTECTED] wrote:
A) Possible is a BIG word. So is anywhere. If you could narrow
these two down a bit it might help answer your question.
possible mean how to do it
anywhere mean a pc with a windows os
There's always VNC: http://www.realvnc.com/ That way Windows won't know
you're not sitting in front of it, and if you've got to access it from
across the country on a linux or BSD or MAC box, it still works.
VNC requires additional port to be opened.
I have no free opened ports in W2K
mstsc /console
It should work fine with this switch. I've used it many times.
I ran mstsc /console from my XP Proffessional and tried to install
Postgres 8.1.3 in two different
servers:
Windows 2003
Windows 2000
Both cause the following message:
---
Internal error
mstsc /console
It should work fine with this switch. I've used it many times.
I ran mstsc /console from my XP Proffessional and tried to
install Postgres 8.1.3 in two different
servers:
Windows 2003
Windows 2000
Both cause the following message:
---
Second, make sure that you have the correct version of mstsc. mstsc /?
will tell you if your current client supports the /console parameter.
(If it doesn't, it'll silently eat it and ignore it)
I think I use mstsc from XP SP2
mstsc /? returns
---
Usage
On Tue, 2006-04-04 at 16:07, Andrus wrote:
Remote install of Postgres 8.1.3 using Windows installer binary package is
not working (says that console mode is required) even when RDP client is
started with
mstsc /console
switch.
However, using installer package, creating cluster and
Remote install of Postgres 8.1.3 using Windows installer binary package is
not working (says that console mode is required) even when RDP client is
started with
mstsc /console
switch.
However, using installer package, creating cluster and server process
manually works OK from RDP client!
Any
Remote install of Postgres 8.1.3 using Windows installer
binary package is not working (says that console mode is
required) even when RDP client is started with
mstsc /console
switch.
It should work fine with this switch. I've used it many times.
However, using installer package,
Carl Conard wrote:
Connections are through localhost. We've also connected via a client
machine through a router to insure it is not something on the server.
No, I meant what client library: odbc, jdbc .net libpq?
By drop connections, I mean Task Manager is showing additional
postgres.exe
Carl Conard wrote:
I've successfully installed Postgres 8.1.2 on WS 2003 R2 on a Lenovo
(IBM) ThinkPad. I used the default installation options and everything
seems peachy keen for a single user (using localhost).
However, when we started performance testing Postgres (vs. MySQL) using
a
User; Magnus Hagander; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Installing Postgres 8.1 on Windows Server 2003 R2
Carl Conard wrote:
I've successfully installed Postgres 8.1.2 on WS 2003 R2 on a Lenovo
(IBM) ThinkPad. I used the default installation options and
everything
seems
I figure this would be a good place to ask. I want to build / buy a
new linux postgres box. I was wondering if anyone on this list had
some experience with this they'd like to share. I'm thinking
somewhere in the $7k - 15k range. The post important things are
write speed to the disk and
: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Rick Gigger
Sent: Monday, January 23, 2006 2:13 PM
To: pgsql general
Subject: [GENERAL] Linux - postgres RAID
I figure this would be a good place to ask. I want to build / buy a
new linux postgres box. I was wondering if anyone on this list
On Jan 23, 2006, at 11:13 AM, Rick Gigger wrote:
I figure this would be a good place to ask. I want to build / buy a
new linux postgres box. I was wondering if anyone on this list had
some experience with this they'd like to share. I'm thinking
somewhere in the $7k - 15k range. The
Rick Gigger wrote:
I figure this would be a good place to ask. I want to build / buy a
new linux postgres box. I was wondering if anyone on this list had
some experience with this they'd like to share. I'm thinking
somewhere in the $7k - 15k range. The post important things are
write
Thanks! That's just the sort of info I am looking for.
I am definitely going with the fastest scsi drives I can get.
Probably a 6 or 8 disk system. Is there a huge jump between using 4
and 6 drives, or 6 and 8 drives?
On Jan 23, 2006, at 12:42 PM, Steve Atkins wrote:
On Jan 23, 2006,
I've successfully installed Postgres 8.1.2 on WS 2003 R2 on
a Lenovo (IBM) ThinkPad. I used the default installation options and
everything seems peachy keen for a single user (using localhost).
However, when we started performance testing
Postgres(vs. MySQL) using a 3rd party tool (I
Has anyone tried to install Postgres on Windows Sever 2003
version R2? R2 is actually shipping as a 'new' Microsoft
product- it's basically an interim update to Windows Server (
http://www.microsoft.com/windowsserver2003/r2/whatsnewinr2.msp
x
That's what I was afraid of... it's a new install of Win Server 2003 R2, so I can rule out any third party firewall. Windows Firewall isNOT installed. And I've installedPostgres on a Windows XP boxbehind the same router, so it's not a router-firewall issue.
It's probably a new R2
Hi,
Has anyone tried to install Postgres on Windows Sever 2003 version R2? R2 is actually shipping as a 'new' Microsoft product- it's basically an interim update to Windows Server (
http://www.microsoft.com/windowsserver2003/r2/whatsnewinr2.mspx).
I've installed Postgres on other versions of
hi all,
i am trying to fix this bug within my program. its a java, postgres and
jasper based program which generates charts. now i am generating a
chart which does not show any 0 data points if they exist, only
non-zero ones. obviously i am trying to do everything in just one sql
query, but i am
[EMAIL PROTECTED] wrote:
hi all,
i am trying to fix this bug within my program. its a java, postgres and
jasper based program which generates charts. now i am generating a
chart which does not show any 0 data points if they exist, only
non-zero ones. obviously i am trying to do everything in
hi,
i have some system where i show pages results on a web-page - the query
that returns the paged result looks like this:
(table has a few hundred thousand rows, result-set is ~3)
a) select asset.asset_id, asset.found_time from asset.asset WHERE
found_time 1130926914 AND pool_id in
Thies C Arntzen wrote:
i would be interested in getting this uncorrected count after sort
but before first row in query (a). so in a fresh DB with no
updates/deletes this would be the correct count, and i could avoid the
very expensive (b).
You don't say what applicaton language you are
Am 16.11.2005 um 14:07 schrieb Richard Huxton:You don't say what applicaton language you are using, but most offer a pg_num_rows() interface which tells you how many results are in the recordset you have fetched. my query uses LIMIT and OFFSET - so pg_num_rows will return what i specify in LIMIT
Thies C. Arntzen wrote:
Am 16.11.2005 um 14:07 schrieb Richard Huxton:
You don't say what applicaton language you are using, but most offer
a pg_num_rows() interface which tells you how many results are in the
recordset you have fetched.
my query uses LIMIT and OFFSET - so pg_num_rows
On Wed, Nov 16, 2005 at 01:23:08PM +0100, Thies C Arntzen wrote:
hi,
i have some system where i show pages results on a web-page - the query
that returns the paged result looks like this:
(table has a few hundred thousand rows, result-set is ~3)
a) select asset.asset_id,
Am 16.11.2005 um 14:49 schrieb Martijn van Oosterhout: i understand that postgres has to read every row from the heap to make sure that they are all still valid and count. but from my understanding query (a) would have something like an uncorrected count (somewhere internally) for the whole
On Wed, Nov 16, 2005 at 03:33:10PM +0100, Thies C. Arntzen wrote:
my question is more in the line of
http://archives.postgresql.org/pgsql-hackers/2005-01/msg00247.php
whereby my special case is all about beeing able to provide an
[possible inaccuate] count for a query if possible: my
On Wed, Oct 05, 2005 at 06:19:39PM -0700, Uwe C. Schroeder wrote:
If any of my customers would ask me if they should buy a system where they
can't access THEIR data in any other way than using the software that comes
with the deal I'd tell them to back off. Most customers on the planet are
On Thu, Oct 06, 2005 at 11:57:32AM +0200, Martijn van Oosterhout wrote:
This is the bit that's been bugging me this whole thread. Who owns the
data? I've had to help people out with programs where they could type
data in but couldn't get the reports they wanted out. Furtunatly,
Access's access
I would like to secure Postgres completly.
Some issues that I don't know you to fix:
1. User postgres can use psql (...) to do anything.
2. User root can su to postgres and thus do anything.
3. Disable all tools like pg_dump
How do I secure a database if I don't trust the administrators.
The
L van der Walt wrote:
I would like to secure Postgres completly.
Some issues that I don't know you to fix:
1. User postgres can use psql (...) to do anything.
Prevent anyone from logging in as user postgres.
Remove psql.
2. User root can su to postgres and thus do anything.
That's the
L van der Walt wrote:
I would like to secure Postgres completly.
Some issues that I don't know you to fix:
1. User postgres can use psql (...) to do anything.
2. User root can su to postgres and thus do anything.
3. Disable all tools like pg_dump
How do I secure a database if I don't trust
Example: On a MS Windows Server with MS SQL Server. The administrator
with the administrator username and password can not access the SQL
server data. He also needs the SA username and password for the SQL
server to do so. He can stop and start the server and so on but not
access the data.
Berend Tober wrote:
L van der Walt wrote:
I would like to secure Postgres completly.
Some issues that I don't know you to fix:
1. User postgres can use psql (...) to do anything.
2. User root can su to postgres and thus do anything.
3. Disable all tools like pg_dump
How do I secure a
Don't forget to CC: the list!
L van der Walt wrote:
Example: On a MS Windows Server with MS SQL Server. The administrator
with the administrator username and password can not access the SQL
server data. He also needs the SA username and password for the SQL
server to do so. He can stop
The big problem is that the administrators works for the client and not
for me. I don't want the client to reverse engineer my database.
There might be other applications on the server so the administrators do
require root access.
About the raw database files, I can use encryption to
L van der Walt wrote:
The big problem is that the administrators works for the client and not
for me. I don't want the client to reverse engineer my database.
There might be other applications on the server so the administrators do
require root access.
About the raw database files, I can
You could look at what SELinux extensions now available in at least the Red
Hat (and Fedora) distro offer. I have never done anything with SELinux,
and a quick review of the archives indicates it is not a slam dunk to use.
It is designed to create the kind of restrictive environment you describe.
L van der Walt writes:
The big problem is that the administrators works for the client and not
for me. I don't want the client to reverse engineer my database.
i think you're trying to get native OS security to perform the function
of a well crafted legal document.
richard
If you don't trust the administrators you should find someone else to admin
your machine.
Main question: what do you need the administrators to do for you? If you
only need them to do a few things, then it is much easier to limit their
access.
Because, on most popular systems (e.g. C2-level
L van der Walt wrote:
Then, I might as well just leave the whole PostgreSQL DB and write my
own mini DB with encrypted XML files. I am sure someone must have an
answer for me.
i think the answer is that windows is giving you a false sense of
security.
in an environment where you cannot
At 04:48 PM 10/5/2005 +0200, L van der Walt wrote:
The big problem is that the administrators works for the client and not
for me. I don't want the client to reverse engineer my database.
There might be other applications on the server so the administrators do
require root access.
If it's
Also sprach L van der Walt ([EMAIL PROTECTED])
The big problem is that the administrators works for the client and not
for me. I don't want the client to reverse engineer my database.
[...]
About the raw database files, I can use encryption to protect the data.
How shall the DBMS acces
L van der Walt [EMAIL PROTECTED] writes:
The big problem is that the administrators works for the client and not
for me. I don't want the client to reverse engineer my database.
There might be other applications on the server so the administrators do
require root access.
About the raw
Richard Huxton wrote:
L van der Walt wrote:
The big problem is that the administrators works for the client and
not for me. I don't want the client to reverse engineer my database.
There might be other applications on the server so the administrators
do require root access.
About the raw
Uh. Unless you've done something more than what you say, a windows
administrator can definitely access the data. Maybe most windows
administrators don't know how to do it, but it is possible.
I've viewed and changed data on a database on Windows without the database
administrator username and
On Wed, Oct 05, 2005 at 04:37:38PM +0200, L van der Walt wrote:
Then, I might as well just leave the whole PostgreSQL DB and write my
own mini DB with encrypted XML files. I am sure someone must have an
answer for me.
I think you are missing the point. Root is all powerful, end of story.
On Wed, 2005-10-05 at 10:27, L van der Walt wrote:
Richard Huxton wrote:
L van der Walt wrote:
The big problem is that the administrators works for the client and
not for me. I don't want the client to reverse engineer my database.
There might be other applications on the server so
Sent by: cc:
Subject: Re: [GENERAL]
Securing Postgres
[EMAIL PROTECTED] wrote:
You could look at what SELinux extensions now available in at least the Red
Hat (and Fedora) distro offer. I have never done anything with SELinux,
and a quick review of the archives indicates it is not a slam dunk to use.
It is designed to create the kind of restrictive
No I can not trust the clients administrators.
I have played now with MySQL and with MySQL you can change the password
for root in MySQL (same as postgres in PostgreSQL). If you use the
command line tools like dump you require the password. Just because
your root doesn't mean your root in
On Wed, 2005-10-05 at 09:37, L van der Walt wrote:
Berend Tober wrote:
L van der Walt wrote:
I would like to secure Postgres completly.
Some issues that I don't know you to fix:
1. User postgres can use psql (...) to do anything.
2. User root can su to postgres and thus do
L van der Walt wrote:
Richard Huxton wrote:
L van der Walt wrote:
The big problem is that the administrators works for the client and
not for me. I don't want the client to reverse engineer my database.
There might be other applications on the server so the administrators
do require root
On Wed, Oct 05, 2005 at 05:27:22PM +0200, L van der Walt wrote:
I have played now with MySQL and with MySQL you can change the password
for root in MySQL (same as postgres in PostgreSQL). If you use the
command line tools like dump you require the password. Just because
your root doesn't
Also sprach Stefan 'Kaishakunin' Schumacher ([EMAIL PROTECTED])
Also sprach L van der Walt ([EMAIL PROTECTED])
The big problem is that the administrators works for the client and not
for me. I don't want the client to reverse engineer my database.
[...]
About the raw database files,
On Wed, Oct 05, 2005 at 04:48:33PM +0200, L van der Walt wrote:
The big problem is that the administrators works for the client and not
for me. I don't want the client to reverse engineer my database.
You don't need a technical solution; you need a legal one. Anyone with
physical access to a
On Wednesday 05 October 2005 07:37, L van der Walt wrote:
Berend Tober wrote:
L van der Walt wrote:
I would like to secure Postgres completly.
Some issues that I don't know you to fix:
1. User postgres can use psql (...) to do anything.
2. User root can su to postgres and thus do
Hi,
first off - what annoyes me in the PostgreSQL mailing lists is that
posters regularly break threads. Why can't you create a new mail for
a new topic without replying to another mail with a totally different
topic?
On Monday 12 September 2005 23:51, Christian Goetze wrote:
| I'm trying to
I'm trying to build postgres on Suze with --with-pam, and it tells me:
/usr/lib/gcc-lib/i586-suse-linux/3.3.5/../../../../i586-suse-linux/bin/ld:
cannot find -lpam
I know it is actually installed, and disecting the configure script and
hand-compiling the test program works if I say
@postgresql.org
Oggetto: Re: [GENERAL] Linux Postgres authentication against
active directory
Actually I try to authenticate my Linux Postgres installation
against Active Directory, I find 3 solution to use:
1) LDAP
2) Pam and Kerberos
3) Kerberos alone
(3) is the one I've
Actually I try to authenticate my Linux Postgres installation
against Active Directory, I find 3 solution to use:
1) LDAP
2) Pam and Kerberos
3) Kerberos alone
(3) is the one I've been using, and it works very well. I've been
working on a HOWTO, but it' snot done yet.
Hi to all,
Actually I try to authenticate my Linux Postgres installation against Active
Directory, I find 3 solution to use:
1) LDAP
2) Pam and Kerberos
3) Kerberos alone
The first require the modification of the active directory schema, and I
prefer to avoid such responsibility.
For the 2
Hi to all,
Actually I try to authenticate my Linux Postgres installation
against Active Directory, I find 3 solution to use:
1) LDAP
2) Pam and Kerberos
3) Kerberos alone
(3) is the one I've been using, and it works very well. I've been
working on a HOWTO, but it' snot done yet.
Note
Hi, thanks for the answer.
Below my comment
-Messaggio originale-
Da: Magnus Hagander [mailto:[EMAIL PROTECTED]
Inviato: venerdì 12 agosto 2005 12.56
A: Ronzani Dario; pgsql-general@postgresql.org
Oggetto: RE: [GENERAL] Linux Postgres authentication against
active directory
Hi everybody, is there anybody developing apps with powerbuilder and
postgres as the db server ? my problem is that I have a function in
postgres to import data from a csv file that resides in the server, in
pb a declare that function as a store procedure and then I call it with
the PowerBuilder
sorry, forgot to mention that the server is 8.0.3 and is running on a fedora core 3 serverOn 10/08/05, Hugo [EMAIL PROTECTED]
wrote:Hi everybody, is there anybody developing apps with powerbuilder and
postgres as the db server ? my problem is that I have a function in
postgres to import data from
On Wed, 2005-08-10 at 11:36 -0400, Hugo wrote:
anybody developing apps with powerbuilder and postgres
Take a look at http://pbpgsql.spiderbark.com/index.php
---(end of broadcast)---
TIP 6: explain analyze is your friend
Hello,
I have an old binary RPM distribution of Postgres (7.1.2), and I am
trying to switch from the proprietary interface to the ODBC interface so
that I can upgrade my servers to a more up-to-date version. In trying
to get the ODBC installed on my test system, I've run into the problem
On Mon, Aug 01, 2005 at 05:18:58PM -0500, Laura Vance wrote:
In trying to get the ODBC installed on my test system, I've run
into the problem that I need to know if my binary distribution of
PostgreSQL was configured with the --enable-odbc option, and I can't
seem to find out how to do that.
Michael Fuhr wrote:
On Mon, Aug 01, 2005 at 05:18:58PM -0500, Laura Vance wrote:
In trying to get the ODBC installed on my test system, I've run
into the problem that I need to know if my binary distribution of
PostgreSQL was configured with the --enable-odbc option, and I can't
seem to
El Lun 01 Ago 2005 20:13, Laura Vance escribió:
I've tried other configuration test programs, but none of them seem to
connect properly.
Is there some incompatibility with this version of iodbc and postgresql
7.1.2?
Sorry, I happen to recall that you wanted this to upgrade the PG
Martín Marqués wrote:
El Lun 01 Ago 2005 20:13, Laura Vance escribió:
I've tried other configuration test programs, but none of them seem to
connect properly.
Is there some incompatibility with this version of iodbc and postgresql
7.1.2?
Sorry, I happen to recall that you wanted
Laura Vance [EMAIL PROTECTED] writes:
Now I have to upgrade to Fedora Core 4, which uses a much higher version
of PostgreSQL. Unfortunately the Pg.pm support is gone (it's wrapped by
DBI/DBD, which wasn't that hard to convert my apps, and they work except
for some inconsistent errors that
On Mon, Aug 01, 2005 at 08:32:17PM -0400, Tom Lane wrote:
Laura Vance [EMAIL PROTECTED] writes:
Now I have to upgrade to Fedora Core 4, which uses a much higher version
of PostgreSQL. Unfortunately the Pg.pm support is gone (it's wrapped by
DBI/DBD, which wasn't that hard to convert my
Dinesh Pandey wrote:
From where can I download?
Postgres 8.x + required packages and installation instruction of
Postgres for Fedora Core 2 OS.
Umm - did you try the website: http://www.postgresql.org/
Click Downloads, click FTP Browser, look in v8.03, linux, rpms,
fedora,
Use 127.0.0.1 instead of localhost
In this case DNS is not used.
Andrus.
Scott cox [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
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
and working so I am sure it is Postmaster related.
Any suggestions on different configurations that I can try, pgSql is
unusable to me
if I cannot solve this issue and I need it pretty quick now.
TIA
Scott
From: Andrus [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL
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 figured the problem is Authentication.
a.)
On UNIX this generally suggests a DNS configuration problem (can't
lookup 127.0.0.1 in DNS).
That's all I can help you with here...
Hope this helps,
On Fri, Jul 15, 2005 at 03:08:24PM +, Scott cox wrote:
I am running PostgreSQL 8.0 on WinXP
When I try to connect
psql.exe -h localhost
801 - 900 of 1052 matches
Mail list logo