Subject: Restore Dataset - msg#00294

Previous Message by Date: click to view message preview

Re: Install or Bust - pgsql on Red Hat 9

Ð ÐÑÐ, 28.01.2004, Ð 06:06, Phil Seretti ÐÐÑÐÑ: > Following Red Hat's PostgreSQL Configuration instructions, here is my > terminal dialog; > > [root@localhost user]# postmaster -i > logfile 2>&1 & > [1] 2884 > [root@localhost user]# createdb -h localhost -E UNICODE mydb > bash: createdb: command not found > [1]+ Exit 127 postmaster -i > >logfile 2>&1 on redhat just do # /etc/init.d/postgresql start then you can do # su - postgres # psql template1 postgres and start adding users and creating databases and stuff. -- Markus Bertheau <twanger@xxxxxxxxxxxxxx> ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly

Next Message by Date: click to view message preview

Database installation query (PostgreSQL 7.4)

Hi, How can I install PostgreSQL 7.4 in a directory other than the --prefix directory without having to recompile the code. Note that, I have to make a tar file of the installable files and have to install it on different machines (which may have different paths). When I tried this on one of the machines, I got following error: bash-2.03$ /export/home/postgres/bin/initdb -D /export/home/postgres/data -L /export/home/postgres/share/postgresql The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with locale C. creating directory /export/home/postgres/data... ok creating directory /export/home/postgres/data/base... ok creating directory /export/home/postgres/data/global... ok creating directory /export/home/postgres/data/pg_xlog... ok creating directory /export/home/postgres/data/pg_clog... ok selecting default max_connections... 100 selecting default shared_buffers... 1000 creating configuration files... ok creating template1 database in /export/home/postgres/data/base/1... ok initializing pg_shadow... ok enabling unlimited row size for system tables... ok initializing pg_depend... ok creating system views... ok loading pg_description... ok creating conversions... ERROR: could not access file "$libdir/ascii_and_mic": No such file or directory initdb: failed initdb: removing data directory "/export/home/postgres/data" Can anyone help me out ? Thanks, Saket. ---------------------------(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

Previous Message by Thread: click to view message preview

COPY command cannot access file...

I have an application that will only ever run locally on a development box. The application writes a text file to the hard drive, and then issues the "COPY" sql command to import records in that text file. The application ran fine on one box, but then when trying to run it on another, I keep getting error messages, something such as... COPY command, running in backend with effective uid 501, could not open file... 501 is the postgres user. I understand why this is happening. The database server, does not seem to be able to access the file and from what I understand changing permissions of the file will not help. What I need to know is how can I give the database server permission to read such files? I have a number of scripts written this way that import millions of records. I read somewhere I should use the 'psql \copy' command instead. But then the manual page for the psql command reccomends the SQL copy command for large numbers of records, and I would hate to have to rewrite so many scripts to change it. With that, how can I grant the database server what it needs to read these files. Thanks in advance. Alan ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx

Next Message by Thread: click to view message preview

Database installation query (PostgreSQL 7.4)

Hi, How can I install PostgreSQL 7.4 in a directory other than the --prefix directory without having to recompile the code. Note that, I have to make a tar file of the installable files and have to install it on different machines (which may have different paths). When I tried this on one of the machines, I got following error: bash-2.03$ /export/home/postgres/bin/initdb -D /export/home/postgres/data -L /export/home/postgres/share/postgresql The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with locale C. creating directory /export/home/postgres/data... ok creating directory /export/home/postgres/data/base... ok creating directory /export/home/postgres/data/global... ok creating directory /export/home/postgres/data/pg_xlog... ok creating directory /export/home/postgres/data/pg_clog... ok selecting default max_connections... 100 selecting default shared_buffers... 1000 creating configuration files... ok creating template1 database in /export/home/postgres/data/base/1... ok initializing pg_shadow... ok enabling unlimited row size for system tables... ok initializing pg_depend... ok creating system views... ok loading pg_description... ok creating conversions... ERROR: could not access file "$libdir/ascii_and_mic": No such file or directory initdb: failed initdb: removing data directory "/export/home/postgres/data" Can anyone help me out ? Thanks, Saket. ---------------------------(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