[SQL] ./configure problems
HI! I did this to install postgres in a new machine: ./configure --prefix=/usr/local/pgsql --with-tcl --with-perl and I got this: loading cache ./config.cache checking host system type... /usr/src/pgsql/postgresql-7.0.2/src/config.guess: 13497442: No space left on device /usr/src/pggsql/postgresql-4.0.2/sr/config.guess: 135012768: No space left on device configure: error: can not guess host type: you must specify one I have 8GB in the /usr directory Do somebody know whats going on? Thanks Rocael Get free email and a permanent address at http://www.netaddress.com/?N=1
[SQL] shared memory problem
HI all! I did this: /usr/local/pgsql/bin/postmaster -B 1000 -o "-S 2000" -S -D /usr/local/pgsql/data and it says: IpcMemoryCreate: shmget failed (Invalid argument) key=5432001, size=8899584,permission=600 This type of erro is usually caused by an improper shared memory or System V IPC semaphore configuration. Form more information what should I do, I am running a 600Mhz Celeron with 512RAM, I have tried the same command in others machines and works fine, thank you for your help, Rocael. Get free email and a permanent address at http://www.netaddress.com/?N=1
[SQL] shared memory blocks?
Hi, how can I configure my kernel to make it work with shared memory blocks of 8Mb? I'm using RedHat 6.2 Thank you for your help! Rocael. Tom Lane <[EMAIL PROTECTED]> wrote: <[EMAIL PROTECTED]> writes: > /usr/local/pgsql/bin/postmaster -B 1000 -o "-S 2000" -S -D > /usr/local/pgsql/data > and it says: > IpcMemoryCreate: shmget failed (Invalid argument) key=5432001, > size=8899584,permission=600 > This type of erro is usually caused by an improper shared memory or System V > IPC semaphore configuration. Form more information Most likely your kernel isn't set to allow shared memory blocks as large as 8M. regards, tom lane Get free email and a permanent address at http://www.netaddress.com/?N=1
[SQL] special caracters!
Hi! When I store special caracters from spanish language I have problems when I got it back because it do not return what I have stored. Is some available support for that in postgres 7.0.2? thank you, Rocael. Get free email and a permanent address at http://www.netaddress.com/?N=1
[SQL] special caracters??
Hi all! I have problems when I store non-english caracters like ñ, á, é, etc. when I got that caracters stored in the DB with select statement and build a page I have substitutions, instead of the data that I put appear something different, there is a way to handle this?? thank you, Rocael. Get free email and a permanent address at http://www.netaddress.com/?N=1
[SQL] problems with postmaster
Hi all! I couldn't find a way to make my DB server work again. I did this: in postgres user killall -9 postmaster (I wanted to stop the server) then rm /tmp/.s.PGSQL.5432 I tried to restart the server but I got this error: [postgres@aux-209-217-53-170 postgres]$ postmaster -D /usr/local/pgsql/data/ IpcMemoryCreate: shmget failed (Identifier removed) key=5432010, size=144, permi ssion=700 This type of error is usually caused by an improper shared memory or System V IPC semaphore configuration. For more information, see the FAQ and platform-specific FAQ's in the source directory pgsql/doc or on our web site at http://www.postgresql.org. IpcMemoryIdGet: shmget failed (Identifier removed) key=5432010, size=144, permis sion=0 IpcMemoryAttach: shmat failed (Invalid argument) id=-2 FATAL 1: AttachSLockMemory: could not attach segment What I can do?? Help me please! Thank you for your replys, also I want to know how to stop a pg server that is running in the background. Rocael. Get free email and a permanent address at http://www.netaddress.com/?N=1
[SQL] pltcl problem
Hi all! I am using postgresql 7.0.2 and then installed tcl 8.2.3 (from dev.scriptics.com). I followed all the instructions to install tcl. Then I have configured again postgres using this flag, --with-tcl. everythings looks ok, I did a createlang pltcl mydb and it worked! then load some pltcl functions and worked also. But when I try to use that functions I got this error: ERROR: Load of file /usr/local/pgsql/lib/pltcl.so failed: libtcl8.2.so: cannot open shared object file: No such file or directory Im running RH6.2 Thank you for your help. Rocael. Get free email and a permanent address at http://www.netaddress.com/?N=1
[SQL] postmaster restart error
Hi all!
I'm using postgresql7.0.2
I did
ipcclean
and then
pg_ctl stop
then I tried to start again the DB server as usual
nohup postmaster -i > pgserver.log 2>&1 &
I got this error:
FATAL 2: Read("/usr/local/pgsql/data/pg_control") failed:2
Startup failed - abort.
Somebody know what could be wrong? and how to start my DB again...
Thank you,
Rocael
Get free email and a permanent address at http://www.netaddress.com/?N=1
[SQL] restart postmaster error
Hi! I did as postgres user ipcclean then pg_ctl stop but then when I tried to start again the server as usual I couldn't, I just doesn't do anything. Somebody know whats going on? Thank you, Rocael. Get free email and a permanent address at http://www.netaddress.com/?N=1
[SQL] pg_control error!
Hi all!
I'm using postgresql7.0.2
I did
ipcclean
and then
pg_ctl stop
then I tried to start up again the DB server as usual
nohup postmaster -i > pgserver.log 2>&1 &
I got this error:
FATAL 2: Read("/usr/local/pgsql/data/pg_control") failed:2
FATAL 2: Read("/usr/local/pgsql/data/pg_control") failed:2
Startup failed - abort.
Thank you for the help,
bye.
Rocael
Get free email and a permanent address at http://www.netaddress.com/?N=1
[SQL] pg_control error!
Hi all!
I'm using postgresql7.0.2
I did
ipcclean
and then
pg_ctl stop
then I tried to start up again the DB server as usual
nohup postmaster -i > pgserver.log 2>&1 &
I got this error:
FATAL 2: Read("/usr/local/pgsql/data/pg_control") failed:2
FATAL 2: Read("/usr/local/pgsql/data/pg_control") failed:2
Startup failed - abort.
Thank you for the help,
bye.
Rocael
Get free email and a permanent address at http://www.netaddress.com/?N=1
[SQL] count number of weeks??
Hi all! I wonder how in PG7.0.2 I can count the number of weeks from a date field that I have in a table, lets say: table trial has in its fields start_date as sysdate(), and now I want to do a select that will give me the number of weeks from now [sysdate()] to the start_date. Thanks for the help! Rocael. Get free email and a permanent address at http://www.netaddress.com/?N=1 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[SQL] File system level backup
Hi! I have an installation of PG7.0.2 in a disk, for some reasons I didn't use that disk anymore but right now I want to use the dbs that I have there, the point is that I've mount that disk in other file system, so I copied the old /usr/local/pgsql/data to the new /usr/local/pgsql/data and tried to access that DB using also PG7.0.2 but it didn't work. I followed the instructions at http://www.postgresql.org/idocs/index.php?backup-file.html Here's the log of the DB running the new copied /data: DEBUG: Data Base System is starting up at Wed Jul 11 05:24:07 2001 DEBUG: Data Base System was shut down at Tue Jul 10 18:20:05 2001 DEBUG: Data Base System is in production state at Wed Jul 11 05:24:07 2001 FATAL 1: Database "open" does not exist in the system catalog. I got the FATAL 1 when I do a psql open, that DB really exists in data/base by the way, the first PG installation was on RH6.2 the actual PG is on RH7.1, and both are PG7.0.2 installed from source (not rpms) What is the right way to do a dump of the DBs in this way?, I don't want to use pg_dump. Thank you, Rocael. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[SQL] moving DB
Hi all! well, can somebody tell me how to move a DB (e.g. I have a DB named NET in PC1 under pg6.5.3 and I want to put it in PC2 under pg7.0) should I copy just the data/base/NET/ directory and the paste it in the data/base of the PC2... which are the exactly steps... :o) thanx Rocael Get free email and a permanent address at http://www.netaddress.com/?N=1
[SQL] dump from access to pg on linux
Hi all! I have a DB in access, and I wanna pass it to pg7 on my linux box, do somebody know which is the best (and easy) way to do that?? like a dump?? thanx, Rocael. Get free email and a permanent address at http://www.netaddress.com/?N=1
[SQL] capacity of copy command??
Hi All! I just wanna now how much is the capacity of the copy command... I did a psql mydb < data.sql inside data.sql I had a COPY "table" FROM stdin; and around 200,000 registers and it gave me error message... pg_atoi... :( but it worked inserting by parts of the file... thanx, Rocael. Get free email and a permanent address at http://www.netaddress.com/?N=1
