Обсуждение: psql 7.0.0 beta
I have tried the postgreSQL 7.0.0 beta, and, so far, the only problem
I encountered that was unknown to me (and the TODO-list) was a core
dump of pgsql when I tried to import the data from a pg_dump'ed SQL
file under the "wrong" user ID (I dumped the data as user "xxx" and
tried to import them as "yyy"):
----------------------------------------------------------------------
yyy@abc yyy]$ /usr/local/pgsql/bin/psql < data.sql
#\connect: FATAL 1: SetUserId: user 'xxx' is not in 'pg_shadow'
Segmentation fault (core dumped)
----------------------------------------------------------------------
After doing a search-replace with sed, everything worked fine ... BTW,
I had the impression that the beta is somewhat faster then the 6.5.3 I
used to work with -- generally, 7.0 looks really good! Many thanks to
the development team!! Now I looking forward to a postgreSQL with
complete support for aggregates, union etc. in views ;-)
Regards,
Ulf
P.S.: Ah, there was another problem, but I wasn able to reproduce it;
after compiling, "make install" did not install "initdb"; after
repeating the install, everything was in place (Redhat 6.1);
another install on RedHat 6.0 worked without problems.
--
======================================================================
Ulf Mehlig <umehlig@zmt.uni-bremen.de>
Center for Tropical Marine Ecology/ZMT, Bremen, Germany
----------------------------------------------------------------------
> > I have tried the postgreSQL 7.0.0 beta, and, so far, the only problem > I encountered that was unknown to me (and the TODO-list) was a core > dump of pgsql when I tried to import the data from a pg_dump'ed SQL > file under the "wrong" user ID (I dumped the data as user "xxx" and > tried to import them as "yyy"): > > ---------------------------------------------------------------------- > yyy@abc yyy]$ /usr/local/pgsql/bin/psql < data.sql > #\connect: FATAL 1: SetUserId: user 'xxx' is not in 'pg_shadow' > Segmentation fault (core dumped) Are we getting core dumps in this case. I can't seem to reproduce it. -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
Ulf Mehlig writes: > yyy@abc yyy]$ /usr/local/pgsql/bin/psql < data.sql > #\connect: FATAL 1: SetUserId: user 'xxx' is not in 'pg_shadow' > Segmentation fault (core dumped) I can't reproduce that. I need a complete test case, and if you would a stack backtrace. (Start 'gdb psql core' and enter 'bt'.) Please also check the authentication you have set up on the database in question. -- Peter Eisentraut Sernanders väg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden
At 11:06 AM 28/02/00, Ulf Mehlig wrote the following message: >P.S.: Ah, there was another problem, but I wasn able to reproduce it; > after compiling, "make install" did not install "initdb"; after > repeating the install, everything was in place (Redhat 6.1); > another install on RedHat 6.0 worked without problems. I couldn't compile it on FreeBSD 3.3-STABLE and FreeBSD 3.2-STABLE. Tried with stock gcc (2.7.2.1a faik) and gcc 2.95.2: /usr/local/bin/gcc295 -I../../include -I../../backend -O2 -m486 -pipe -I.. -c parse_type.c -o parse_type.o /usr/local/bin/gcc295 -I../../include -I../../backend -O2 -m486 -pipe -I.. -c parse_coerce.c -o parse_coer ce.o /usr/local/bin/gcc295 -I../../include -I../../backend -O2 -m486 -pipe -I.. -c parse_target.c -o parse_targ et.o /usr/local/bin/gcc295 -I../../include -I../../backend -O2 -m486 -pipe -I.. -c scan.c -o scan.o /usr/local/bin/gcc295 -I../../include -I../../backend -O2 -m486 -pipe -I.. -c scansup.c -o scansup.o In file included from scansup.c:20: ../../include/miscadmin.h:229: parse error before `pid' gmake[2]: *** [scansup.o] Error 1 gmake[2]: Leaving directory `/usr/work/databases/pgsql/src/backend/parser' gmake[1]: *** [parser.dir] Error 2 gmake[1]: Leaving directory `/usr/work/databases/pgsql/src/backend' gmake: *** [all] Error 2 The file has this: #define PIDFNAME "postmaster.pid" extern void SetPidFname(char *datadir); extern char *GetPidFname(void); extern void UnlinkPidFile(void); extern int SetPidFile(pid_t pid); <-------------- this line is problematic #endif /* MISCADMIN_H */ Tomaz ---- Tomaz Borstnar <tomaz.borstnar@over.net> "Love is the answer to the final question you ask" - Unknown
Your OS should have pid_t defined in an include file. Findit, and add the #include to miscadmin.h. Then, tell us so we can add it here. > At 11:06 AM 28/02/00, Ulf Mehlig wrote the following message: > >P.S.: Ah, there was another problem, but I wasn able to reproduce it; > > after compiling, "make install" did not install "initdb"; after > > repeating the install, everything was in place (Redhat 6.1); > > another install on RedHat 6.0 worked without problems. > I couldn't compile it on FreeBSD 3.3-STABLE and FreeBSD 3.2-STABLE. Tried > with stock gcc (2.7.2.1a faik) and gcc 2.95.2: > > /usr/local/bin/gcc295 -I../../include -I../../backend -O2 -m486 -pipe > -I.. -c parse_type.c -o parse_type.o > /usr/local/bin/gcc295 -I../../include -I../../backend -O2 -m486 -pipe > -I.. -c parse_coerce.c -o parse_coer > ce.o > /usr/local/bin/gcc295 -I../../include -I../../backend -O2 -m486 -pipe > -I.. -c parse_target.c -o parse_targ > et.o > /usr/local/bin/gcc295 -I../../include -I../../backend -O2 -m486 -pipe > -I.. -c scan.c -o scan.o > /usr/local/bin/gcc295 -I../../include -I../../backend -O2 -m486 -pipe > -I.. -c scansup.c -o scansup.o > In file included from scansup.c:20: > ../../include/miscadmin.h:229: parse error before `pid' > gmake[2]: *** [scansup.o] Error 1 > gmake[2]: Leaving directory `/usr/work/databases/pgsql/src/backend/parser' > gmake[1]: *** [parser.dir] Error 2 > gmake[1]: Leaving directory `/usr/work/databases/pgsql/src/backend' > gmake: *** [all] Error 2 > > The file has this: > > #define PIDFNAME "postmaster.pid" > > extern void SetPidFname(char *datadir); > extern char *GetPidFname(void); > extern void UnlinkPidFile(void); > extern int SetPidFile(pid_t pid); <-------------- this line is problematic > > #endif /* MISCADMIN_H */ > > Tomaz > ---- > Tomaz Borstnar <tomaz.borstnar@over.net> > "Love is the answer to the final question you ask" - Unknown > > > ************ > > -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
At 04:17 PM 01/03/00, Bruce Momjian wrote the following message: >Your OS should have pid_t defined in an include file. Findit, and add >the #include to miscadmin.h. Then, tell us so we can add it here. #include <sys/types.h> seemed to help > > At 11:06 AM 28/02/00, Ulf Mehlig wrote the following message: > > >P.S.: Ah, there was another problem, but I wasn able to reproduce it; > > > after compiling, "make install" did not install "initdb"; after > > > repeating the install, everything was in place (Redhat 6.1); > > > another install on RedHat 6.0 worked without problems. > > I couldn't compile it on FreeBSD 3.3-STABLE and FreeBSD 3.2-STABLE. Tried > > with stock gcc (2.7.2.1a faik) and gcc 2.95.2: ---- Tomaz Borstnar <tomaz.borstnar@over.net> "Love is the answer to the final question you ask" - Unknown
> At 04:17 PM 01/03/00, Bruce Momjian wrote the following message: > >Your OS should have pid_t defined in an include file. Findit, and add > >the #include to miscadmin.h. Then, tell us so we can add it here. > > #include <sys/types.h> seemed to help > > > > > At 11:06 AM 28/02/00, Ulf Mehlig wrote the following message: > > > >P.S.: Ah, there was another problem, but I wasn able to reproduce it; > > > > after compiling, "make install" did not install "initdb"; after > > > > repeating the install, everything was in place (Redhat 6.1); > > > > another install on RedHat 6.0 worked without problems. > > > I couldn't compile it on FreeBSD 3.3-STABLE and FreeBSD 3.2-STABLE. Tried > > > with stock gcc (2.7.2.1a faik) and gcc 2.95.2: I looked at 7.0 miscadmin.h, and see sys/types.h, so it is already fixed in the current beta. -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026