I have a psql database (8.01) running on a Suse 9.3 linux server, and I
have the same database (8.03) running on winxp laptop. I do updates,
that is, add parts to a table on the linux server quite frequently using
MS Access, all well and good. I also have pgadmin 3 on my machine for
editing the
Thanks for the info. I was trying the old .conf files from a database
trasfered from 7.54. The tcpip enable is different between it and 8.03.
Got it working now with pgadminIII.
Art
Richard Huxton wrote:
Art Fore wrote:
I am trying to start postgresql via webmin, but not having success. I
I am trying to start postgresql via webmin, but not having success. I
get a message in the syslog "su:(to postgres) root on none"
This is suse 9.3. Could someone tell what that message means?
I was working until I added the -i to the postmaster.opts file so I
could access it via pgadmin.
Art
phppgadmin, but now, access via
ODBC (with MSAccess)does not work. All I get is #DELETED for every
oolumn and every row.
could someone explain that to me?
What should the pg_hba.conf file look like?
Art
Art Fore wrote:
I had this working once before, but restarted the database and things
went to hell
Using PGadminIII, I backup my database on linux machine, and try to
restore it on the windows machine. Alway comes up with duplicate key on
the first item. I drop all views and the only table in the database and
try again. Still same thing. I do a refrresh, none of the views or table
were drop
I had this working once before, but restarted the database and things
went to hell. This user authentication for postgresql I will have to say
is the most complex I have seen. Need a block diagram of how it works to
understand it.
Have .pgpass in postgres home directory, data directory is
/hom
Thanks for the answers. I recreated the views. Did not realize when you
renamed a column, it also changed the views.
Art
Robby Russell wrote:
On Tue, 2005-02-08 at 16:37 -0800, Art Fore wrote:
Using phppgadmin, I tried tropping a column in a table. I comes back to
try DROP .. CASCADE. Went into
Using phppgadmin, I tried tropping a column in a table. I comes back to
try DROP .. CASCADE. Went into psql and typed the following,
ALTER TABLE "MPC" DROP COLUMNG do_not_use CASCADE
It appeared to work but did not drop the column. What is the dprocedure
for dropping a column? an anyone point m
I have a postgresql 7.5.1 database with one table on a SuSE 9.2 server.
I also have the same database on my windowsxp laptop. I done a
backup-restore operation to get the original database on the windows
machine, but seem I cannot update using that. It comes up with duplicate
primary key errors
Magnus Hagander wrote:
http://pginstaller.projects.postgresql.org could be what you are looking
for.
//Magnus
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Art Fore
Sent: Friday, February 04, 2005 3:09 PM
To: pgsql-general@postgresql.org
Subject: Re
Sorry about the last email, I sent before adding comment.
Will try this. thanks.
Art
Magnus Hagander wrote:
http://pginstaller.projects.postgresql.org could be what you are looking
for.
//Magnus
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Art Fore
thing:
http://pgfoundry.org/projects/pginstaller
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Art Fore
Sent: Thursday, February 03, 2005 9:20 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Postgresql 8.0 beta 5 setup in windowsxp
Have a winXP machine
Have a winXP machine with the above program installed, however, the
service will not start, even when logged in as administrator.
Need a step by step setup procedure for WINDOWS. Is sthere one available
or is there anything available on setup after install? All I have found
is for lilnux-unix-b
13 matches
Mail list logo
