[ADMIN] One machine connects, the other doesn't???

2003-11-04 Thread Jeff
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 -h BACKEND -U ownerofmydatabase

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
Any ideas???

Jeff Roberts

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
  http://www.postgresql.org/docs/faqs/FAQ.html


[ADMIN] Forcing pg_dump NOT to use "INSERT..."

2003-11-04 Thread David F. Skoll
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 planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


Re: [ADMIN] One machine connects, the other doesn't???

2003-11-04 Thread mallah
> 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 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 -h BACKEND -U ownerofmydatabase
>
> 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
>
> Any ideas???
>
> Jeff Roberts
>
>
> ---(end of broadcast)--- TIP 5: Have 
> you
> checked our extensive FAQ?
>
>   http://www.postgresql.org/docs/faqs/FAQ.html



-
Over 1,00,000 exporters are waiting for your order! Click below to get
in touch with leading Indian exporters listed in the premier
trade directory Exporters Yellow Pages.
http://www.trade-india.com/dyn/gdh/eyp/



---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html


Re: [ADMIN] One machine connects, the other doesn't???

2003-11-04 Thread Valentin Militaru
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


Re: [ADMIN] Forcing pg_dump NOT to use "INSERT..."

2003-11-04 Thread Jaskier

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 3:42 PM
To: [EMAIL PROTECTED]
Subject: [ADMIN] Forcing pg_dump NOT to use "INSERT..."

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 planner will ignore your desire to choose an index scan if
your
  joining column's datatypes do not match



---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [ADMIN] One machine connects, the other doesn't???

2003-11-04 Thread Tom Lane
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 right pg_hba.conf file?
Did you SIGHUP the postmaster after your latest change to pg_hba.conf?
Try looking in the postmaster log to see if it emits any complaints
about syntax problems in pg_hba.conf when you SIGHUP it and/or connect.

regards, tom lane

---(end of broadcast)---
TIP 8: explain analyze is your friend


Re: [ADMIN] Forcing pg_dump NOT to use "INSERT..."

2003-11-04 Thread Tom Lane
"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 pg_dump will
do that unless you explicitly ask for it (-d or -D switch, or one of the
long variants of same).

regards, tom lane

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


[ADMIN] Microsoft access verses postgresql

2003-11-04 Thread Geoffrey
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 be going with the Access solution.  I've got concerns regarding 
this based on research I've done that seems to indicate that Access, 
when used in a multi-user solution is easily corrupted.  Does anyone 
have any knowledge/experience with such issues?

--
Until later, Geoffrey   [EMAIL PROTECTED]
Building secure systems inspite of Microsoft

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [ADMIN] Microsoft access verses postgresql

2003-11-04 Thread David Green
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 (using the eval) but we decided to try switching to PostgreSQL
before the 120 eval was up. We're still working on the MSSQL -> PostgreSQL
switch but once we got off of Access everything went good - no more 
corruptions :)

David Green
Sage Automation, Inc.


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Geoffrey
Sent: Tuesday, November 04, 2003 11:46 AM
To: [EMAIL PROTECTED]
Subject: [ADMIN] Microsoft access verses postgresql


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 be going with the Access solution.  I've got concerns regarding 
this based on research I've done that seems to indicate that Access, 
when used in a multi-user solution is easily corrupted.  Does anyone 
have any knowledge/experience with such issues?

-- 
Until later, Geoffrey   [EMAIL PROTECTED]

Building secure systems inspite of Microsoft


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


---(end of broadcast)---
TIP 8: explain analyze is your friend


Re: [ADMIN] Microsoft access verses postgresql

2003-11-04 Thread Haron, Charles
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: Tuesday, November 04, 2003 10:46 AM
> To: [EMAIL PROTECTED]
> Subject: [ADMIN] Microsoft access verses postgresql
> 
> 
> 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 be going with the Access solution.  I've got concerns regarding 
> this based on research I've done that seems to indicate that Access, 
> when used in a multi-user solution is easily corrupted.  Does anyone 
> have any knowledge/experience with such issues?
> 
> -- 
> Until later, Geoffrey [EMAIL PROTECTED]
> 
> Building secure systems inspite of Microsoft
> 
> 
> ---(end of 
> broadcast)---
> TIP 1: subscribe and unsubscribe commands go to 
> [EMAIL PROTECTED]
> 

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])


Re: [ADMIN] One machine connects, the other doesn't???

2003-11-04 Thread Jeff
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 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 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 -h BACKEND -U ownerofmydatabase

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
Any ideas???

Jeff Roberts

---(end of broadcast)--- TIP 5: 
Have you
checked our extensive FAQ?
 http://www.postgresql.org/docs/faqs/FAQ.html




-
Over 1,00,000 exporters are waiting for your order! Click below to get
in touch with leading Indian exporters listed in the premier
trade directory Exporters Yellow Pages.
http://www.trade-india.com/dyn/gdh/eyp/


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
   http://www.postgresql.org/docs/faqs/FAQ.html



---(end of broadcast)---
TIP 8: explain analyze is your friend


[ADMIN] delete postmaster.pid on windows xp home edition before startup postmaster

2003-11-04 Thread somphong settawipattanachai
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



__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


[ADMIN] PGSQL Mailing List Reply-To field

2003-11-04 Thread Rob Fielding
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 if anyone else thought it might be a good idea (or not) 
to use this ?

Cheers,

Rob

---(end of broadcast)---
TIP 6: Have you searched our list archives?
  http://archives.postgresql.org


Re: [ADMIN] One machine connects, the other doesn't???

2003-11-04 Thread Jeff
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 what it will tell you.

Bye


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [ADMIN] Microsoft access verses postgresql

2003-11-04 Thread William Yu
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 appears they 
will be going with the Access solution.  I've got concerns regarding 
this based on research I've done that seems to indicate that Access, 
when used in a multi-user solution is easily corrupted.  Does anyone 
have any knowledge/experience with such issues?

My experience: Access, like any desktop-based database, is subject to 
data corruption in multi-user environments. Pretty easy to picture when 
every machine keeps chunks of data in their local memory, has to write 
back to the network and then somehow push the updates to the other 
clients. You *can* avoid data corruption using very strict locks -- but 
you can't use Access' built-in table/row locking as those functions also 
suffer from the same multi-user synchronization problem. What you can do 
is to write your own locking functions based on file handle access. Make 
a temp dir on a network and everytime you want to update/insert, attempt 
to create a file based on the table/record (e.g. CUSTOMERS-0 for 
inserts, CUSTOMERS-1000 for specific records) -- a valid file handle 
would then mean you have a lock. For the most part, you can avoid data 
corruption if you bypass the built-in locking functions but you will 
still have to periodically take down the system during production hours 
for reindexing when even these measures fail.

---(end of broadcast)---
TIP 8: explain analyze is your friend


Re: [ADMIN] One machine connects, the other doesn't???

2003-11-04 Thread Jeff
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, 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 right pg_hba.conf file?
Did you SIGHUP the postmaster after your latest change to pg_hba.conf?
Try looking in the postmaster log to see if it emits any complaints
about syntax problems in pg_hba.conf when you SIGHUP it and/or connect.
			regards, tom lane

---(end of broadcast)---
TIP 8: explain analyze is your friend


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
 subscribe-nomail command to [EMAIL PROTECTED] so that your
 message can get through to the mailing list cleanly


Re: [ADMIN] Microsoft access verses postgresql

2003-11-04 Thread Kaarel
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 be going with the Access solution.  I've got concerns regarding 
this based on research I've done that seems to indicate that Access, 
when used in a multi-user solution is easily corrupted.  Does anyone 
have any knowledge/experience with such issues?
As far as I am concerned, Access is a bad joice if the data needs to be 
accessed from more than one application at the same time. But if Excel 
worked well enough and only one person is working with the data, then 
Access might do just well.

Kaarel

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [ADMIN] PGSQL Mailing List Reply-To field

2003-11-04 Thread Bruno Wolff III
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 because I keep forgetting the Reply-To field isn't set 
> to the pgsql- mailing list.
> 
> I was wondering if anyone else thought it might be a good idea (or not) 
> to use this ?

Its not. You should probably just get used to doing reply to all.
If you want to reply just to the sender you can use reply to sender
on these lists but will have to go through some contortions on your
broken lists. I usually filter out reply-to headers on lists that
mung them so as not to break reply to sender on my client.

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


[ADMIN] data format problem for upgrede from 7.1->7.3

2003-11-04 Thread Gautam Saha
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)/postgresql-7.3/README.rpm-dist for more 
information.

There is not much info on format change in the Docs.

Any idea what might be the resolution here?

Thanks,

Gautam

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
  http://www.postgresql.org/docs/faqs/FAQ.html


Re: [ADMIN] data format problem for upgrede from 7.1->7.3

2003-11-04 Thread Tom Lane
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)---
TIP 7: don't forget to increase your free space map settings


[ADMIN] 7.3.5

2003-11-04 Thread Donald Fraser



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


Re: [ADMIN] 7.3.5

2003-11-04 Thread Bruno Wolff III
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 after the 7.4 release.

You can get a copy of 7.3 from CVS. I don't remember the appropiate tag
name, but it was posted on one of the lists in the last couple of days.

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])


Re: [ADMIN] 7.3.5

2003-11-04 Thread Tom Lane
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 will be such a release, but
> most likely it will be after the 7.4 release.

Yes.  I'd expect we'd wait till a little while after 7.4, since often
interesting bugs are first reported just after a release --- there may
be things we learn that ought to be back-patched into 7.3.5.  There is
not currently anything in the 7.3 branch that looks like an immediate
release forcer to me.  (I posted a summary of recent 7.3 commit messages
to pgsql-hackers a couple days ago, if you're interested.)

> You can get a copy of 7.3 from CVS. I don't remember the appropiate tag
> name, but it was posted on one of the lists in the last couple of days.

The tip of the REL7_3_STABLE branch is the closest present approximation
to what 7.3.5 might look like.

regards, tom lane

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


Re: [ADMIN] Microsoft access verses postgresql

2003-11-04 Thread kbd
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, start pumping data into the database all at once,
the product fails.  We then contact the vendor then replies with a
TechNet article from M$ which explains that Access should not be used
as a multi-user database.

Also, take note many many projects start as just a simple little job
and then take on a life of their own.

Oh what about security and user management.  And what about backups. 
Who is going to hang around until all the users are finished to backup
the database?

Considering Postgresql is free and actually works.  There is no
decision.

good luck 

kd


[EMAIL PROTECTED] ("Haron, Charles") wrote in message news:<[EMAIL PROTECTED]>...
> 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: Tuesday, November 04, 2003 10:46 AM
> > To: [EMAIL PROTECTED]
> > Subject: [ADMIN] Microsoft access verses postgresql
> > 
> > 
> > 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 be going with the Access solution.  I've got concerns regarding 
> > this based on research I've done that seems to indicate that Access, 
> > when used in a multi-user solution is easily corrupted.  Does anyone 
> > have any knowledge/experience with such issues?
> > 
> > -- 
> > Until later, Geoffrey   [EMAIL PROTECTED]
> > 
> > Building secure systems inspite of Microsoft
> > 
> > 
> > ---(end of 
> > broadcast)---
> > TIP 1: subscribe and unsubscribe commands go to 
> > [EMAIL PROTECTED]
> > 
> 
> ---(end of broadcast)---
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


Re: [ADMIN] Microsoft access verses postgresql

2003-11-04 Thread Michelle Murrain
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 connectivity from one site to another.  It appears they 
> will be going with the Access solution.  I've got concerns regarding 
> this based on research I've done that seems to indicate that Access, 
> when used in a multi-user solution is easily corrupted.  Does anyone 
> have any knowledge/experience with such issues?

Um, use both??

We've been having some success using Access front ends with postgresql
back ends. Takes away the data corruption/scalability issues, but keeps
the strength of the Access reporting and data entry interfaces.
-- 
.Michelle
---
Michelle Murrain
[EMAIL PROTECTED]
Database Designs Associates, Inc.
Boston   617.889.0929
Amherst  413.253.2874
Cell 413.222.6350
www.dbdes.com

AIM:pearlbear0 ICQ:129250575

"Our capacity to make peace with another person and with the world
depends very much on our capacity to make peace with ourselves." -- Thich Nhat Hanh


---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


Re: [ADMIN] Microsoft access verses postgresql

2003-11-04 Thread Geoffrey
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 include vpn connectivity from one site to another.  It appears they 
will be going with the Access solution.  I've got concerns regarding 
this based on research I've done that seems to indicate that Access, 
when used in a multi-user solution is easily corrupted.  Does anyone 
have any knowledge/experience with such issues?


Um, use both??

We've been having some success using Access front ends with postgresql
back ends. Takes away the data corruption/scalability issues, but keeps
the strength of the Access reporting and data entry interfaces.
Okay, so how do you approach this?  Access front end will talk to 
postgresql?  Pointers to any docs would be appreciated.

--
Until later, Geoffrey   [EMAIL PROTECTED]
Building secure systems inspite of Microsoft

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])


Re: [ADMIN] Microsoft access verses postgresql

2003-11-04 Thread Geoffrey
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 appears they will be going with the Access solution.  I've got 
concerns regarding this based on research I've done that seems to 
indicate that Access, when used in a multi-user solution is easily 
corrupted.  Does anyone have any knowledge/experience with such issues?


As far as I am concerned, Access is a bad joice if the data needs to be 
accessed from more than one application at the same time. But if Excel 
worked well enough and only one person is working with the data, then 
Access might do just well.
Multiple people were attempting to access the excel spreadsheets.  Their 
solution was for any person who modifies the spreadsheet was to copy it 
to the other 4 computers.  Yes, that's correct.  I suggested a db 
solution from the beginning, but they didn't want to spend the $$$, so I 
suggested placing the excel spreadsheets on a single file server, thus 
only one person could access a spreadsheet at one time and no more 
copying files across their network.

--
Until later, Geoffrey   [EMAIL PROTECTED]
Building secure systems inspite of Microsoft

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])


Re: [ADMIN] Microsoft access verses postgresql

2003-11-04 Thread Michelle Murrain
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, although it does depend
some on the complexity you need.

There are a couple of different docs at: http://techdocs.postgresql.org/
- one good one on the step by step under "Technical Guides".

-- 
.Michelle
---
Michelle Murrain
[EMAIL PROTECTED]
Database Designs Associates, Inc.
Boston   617.889.0929
Amherst  413.253.2874
Cell 413.222.6350
www.dbdes.com

AIM:pearlbear0 ICQ:129250575

"Our capacity to make peace with another person and with the world
depends very much on our capacity to make peace with ourselves." -- Thich Nhat Hanh


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html