Hi
I have postgresql 7.2.2-1 on "BACKEND".
If I use "Shop"(192.168.24.5) I can connect using the command:
psql mydatabase -h BACKEND -U ownerofmydatabase
I am asked for the password and upon giving it all is well.
BUT.
If I use "Office"(192.168.24.4) and I try the same thing:
psql mydatabase
Hi,
On Red Hat 9, when I run the pg_dump command, it uses the
"INSERT " dump format. I thought it only did that if you used the
--inserts option. How do I force it NOT to use that format?
Regards,
David.
---(end of broadcast)---
TIP 9: the p
> Hi
>
> I have postgresql 7.2.2-1 on "BACKEND".
Although its not answer to your problem , but
you shud *really* upgrade your PostgreSQL version
to 7.2.4 version some serious bugs were fixed relating to possible
data loss.
Regards
Mallah.
>
> If I use "Shop"(192.168.24.5) I can connect using the
Try using the IP instead of backend.
Also, try a ping BACKEND from the second machine, see what it will tell you.
Bye
--
Valentin Militaru
Inginer de sistem
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Hi,
Yes that's right
But You can avoid it by adding
'-s, --schema-only' it will copy only structure without data
Regards,
Andrzej Schulz
Galileo-Selidor
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David F. Skoll
Sent: Tuesday, November 04, 2003
Jeff <[EMAIL PROTECTED]> writes:
> I get:
> psql: FATAL 1: No pg_hba.conf entry for host 192.168.24.4, user
> ownerofmydatabase, database mydatabase
> My pg_hba.conf file has two lines
> local all trust
> host all 192.168.24.0 255.255.255.0 password
Hm. Are you sure you are looking at the rig
"David F. Skoll" <[EMAIL PROTECTED]> writes:
> On Red Hat 9, when I run the pg_dump command, it uses the
> "INSERT " dump format. I thought it only did that if you used the
> --inserts option. How do I force it NOT to use that format?
This is extremely hard to believe. I can see no way that
I've got a client who is following my suggestion that they replace a set
of excel spreadsheets with a database solution. They are looking at two
proposals, postgresql solution or an Access solution. The requirements
will include vpn connectivity from one site to another. It appears they
will
I have been working on an in-house software package for over 3 years now.
I started out using an Access database but once we put more users on it
the database began corrupting frequently. We replaced hardware and the
problem would go away for a bit but would soon return. We switched to
SQL Server
Not only will you have performance and corruption issues, you'll also have
problems with the lock file. And security is a pain to manage. We have
replaced all of our multi-user Access databases with PostgreSQL.
Chuck
> -Original Message-
> From: Geoffrey [mailto:[EMAIL PROTECTED]
> Sent:
Thanks Mallah
First I'll check to make sure it won't break my application and then
I'll have to learn how to back up my database and then perhaps I'll
start looking for the way to do an upgrade. Which means I'll be hanging
around for a while ;-)
Jeff
[EMAIL PROTECTED] wrote:
Hi
I have postgr
i install postmaster as service
on windows xp home edition.
some time it fail to start
due to the existing postmaster.pid.
how can i delete the file before start postmaster
that's
start automatically when machine startup.
or the way i think is wrong,
i should do another thing else?
thanks
Hi,
I'm currently subscribed to pgsql-general and wheneven every I hit
reply, I keep forgetting to reply-to-all so that my mail client includes
a cc to the pgsql-general list.
I keep doing this because I keep forgetting the Reply-To field isn't set
to the pgsql- mailing list.
I was wondering
Thanks Valentin
Ping BACKEND worked and -U 192.168.24.8 returned the same result but Tom
gave me a suggestion that solved it, I was editing the wrong pg_hba.conf
file. :-(
Jeff
Valentin Militaru wrote:
Try using the IP instead of backend.
Also, try a ping BACKEND from the second machine, see
Geoffrey wrote:
I've got a client who is following my suggestion that they replace a set
of excel spreadsheets with a database solution. They are looking at two
proposals, postgresql solution or an Access solution. The requirements
will include vpn connectivity from one site to another. It ap
Thanks Tom!
I was editing /usr/local/pgsql/data/pg_hba.conf when I should have been
editing /var/lib/pgsql/data/pg_hba.conf
Now everything works.
Jeff
Tom Lane wrote:
Jeff <[EMAIL PROTECTED]> writes:
I get:
psql: FATAL 1: No pg_hba.conf entry for host 192.168.24.4, user
ownerofmydatabase,
I've got a client who is following my suggestion that they replace a set
of excel spreadsheets with a database solution. They are looking at two
proposals, postgresql solution or an Access solution. The requirements
will include vpn connectivity from one site to another. It appears they
will
On Tue, Nov 04, 2003 at 15:27:23 +,
Rob Fielding <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm currently subscribed to pgsql-general and wheneven every I hit
> reply, I keep forgetting to reply-to-all so that my mail client includes
> a cc to the pgsql-general list.
>
> I keep doing this becau
Hi:
I just upgraded from 7.1->7.3, but did not take a data back up.
Now when i try to start the posrGreSQL server I get the message:
An old version of the database format was found.\nYou need to upgrade
the data format before using PostgreSQL.\nSee (Your System's
documentation directory)/postgre
Gautam Saha <[EMAIL PROTECTED]> writes:
> Any idea what might be the resolution here?
Put back your 7.1 executables and make a pg_dumpall run before you
upgrade. Then upgrade, initdb, reload the dump.
regards, tom lane
---(end of broadcast)---
Will there be a 7.3.5 version released, containing
relevant patches, before the release of the 7.4 version?
Thanks in advance
Regards
Donald Fraser
On Tue, Nov 04, 2003 at 23:16:15 -,
Donald Fraser <[EMAIL PROTECTED]> wrote:
> Will there be a 7.3.5 version released, containing relevant patches, before the
> release of the 7.4 version?
That seems unlikely. It seems likely that there will be such a release, but
most likely it will be aft
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> On Tue, Nov 04, 2003 at 23:16:15 -,
> Donald Fraser <[EMAIL PROTECTED]> wrote:
>> Will there be a 7.3.5 version released, containing relevant patches, before the
>> release of the 7.4 version?
> That seems unlikely. It seems likely that there wi
I have many years experience with several database products: Foxbase,
FoxPro, MS SQL, Access, Postgresql, AS400 DB2. Compared to any of the
above Access is a toy. Case in point; in my office we have a product
which is "multi-user" based upon Access. When the users, there are
only four of them,
On Tue, 2003-11-04 at 12:46, Geoffrey wrote:
> I've got a client who is following my suggestion that they replace a set
> of excel spreadsheets with a database solution. They are looking at two
> proposals, postgresql solution or an Access solution. The requirements
> will include vpn connecti
Michelle Murrain wrote:
On Tue, 2003-11-04 at 12:46, Geoffrey wrote:
I've got a client who is following my suggestion that they replace a set
of excel spreadsheets with a database solution. They are looking at two
proposals, postgresql solution or an Access solution. The requirements
will inc
Kaarel wrote:
I've got a client who is following my suggestion that they replace a
set of excel spreadsheets with a database solution. They are looking
at two proposals, postgresql solution or an Access solution. The
requirements will include vpn connectivity from one site to another.
It app
On Tue, 2003-11-04 at 21:39, Geoffrey wrote:
> Okay, so how do you approach this? Access front end will talk to
> postgresql? Pointers to any docs would be appreciated.
Access front end talks with Postgresql via ODBC. Can be a little flakey
at times, but it works well in my experience, althoug
28 matches
Mail list logo
