On 0, mwi <[EMAIL PROTECTED]> wrote:
> PostgreSQL is installed on a RedHat 7.1 with Kernel 2.4.2-2. The
> hardware is a PIII-500 with 256MB RAM and 10GB HD (IDE).
Does running
=# VACUUM ANALYZE
help?
Stefan
--
Q: Could you please describe a bovril sandwich?
Douglas Adams: Not on a family show
>1) Is it better to install from source or from SRPM ?
Compile manually. reason: up to date.
>2) Where have I to put the binaries and data ?
>I know the default are: /usr/local/pgsql/bin/ and /usr/local/pgsql/data/
>but SUSE use /usr/bin/ and /var/lib/pgsql/data.
just leave the defaults of
Hi!
> > I always do a chown -R postgres:daemon /usr/local/pgsql (or
> > postgres:postgres) after installation.
>
>Which is a bad idea.
>
>The installation instructions were developed with some thought behind
>them.
Well, this might be true, if you are on a system, where more than one
humans are
Hi!
>Greetings. I am using Postgresql in Red hat linux 71. When i was trying
>to take the backup it is giving the error "Permission Denied"
> 1. Login as root
> 2. su -l postgres
> 3. pg_dump databasename >filename
Who gives you the "Permission denied"? The shell? The postmaster
Hi!
I have two questions:
1) What about the performance of PostgreSQL under WinNT (or Win2k, XP if
somebody already has that). There is a project coming up, and the
programmers want to stick to MS Windows. So are there any quirks with the
Windows version? I checked the FAQ but the two known is
Hi!
I have two questions:
1) What about the performance of PostgreSQL under WinNT (or Win2k, XP if
somebody already has that). There is a project coming up, and the
programmers want to stick to MS Windows. So are there any quirks with the
Windows version? I checked the FAQ but the two known is
Hi!
>Why would destroydb not have been installed?
Maybe because it is calles dropdb? :)
Stefan
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PR
> I'd like to interface ms-access 2000 with postgresql 7.1.1. What my
>objective is is to create a database in access, then upload it on to a web
>server, and via an interactive form and postgresql have various data
>returned, or to enter new data from the web site. Is this possible?
>Thanks.
>Huh? nextval() should always produce unique values (unless the sequence
>wraps around, of course).
What about explicitly overruling a sequence by INSERTing a specific value,
when it is not a primary key or defined as serial, but a manual sequence?
Stefan
--
I don't find it hard to meet exp
At 11:55 2001-06-01 +0700, Andy Samuel wrote:
>Has anybody *really* tried this solution ?
>Is it safe ?
Not with LVM, but with Postgres.7.0 I think, we had some extraordinary
large files and used symlinks to other partitions. Went fine.
Using a non-beta LVM should be as fine as using a singl
Hello all!
>hai,
This is the German word for "shark" :)
>We could not find libpgtcl.so in our system after installation of
>pg-access. We are using Red Hat Linux 6.5.2, Postgresql 6.1 and
>jdk1.2.1. From where we have to get libpgtcl.so. Whether it will be
>available with pgaccess or any other
>echo 'createuser becky -d -a' | su postgres
maybe you'd like it the otherway round? ;)
$ su - postgres -c "createuser becky -d -a"
Stefan
--
"On the Internet, there is no 'they'. There's only a very,
very large 'us'." --- Douglas Adams
---(end of broadcast)---
Hi!
At 15:45 2001-05-18 +0200, Muhammed Yazici wrote:
> > createdb -D /other/path dbname
> > ERROR: The database path '/other/path' is invalid. This may be due to a
>character that is not allowed or because the chosen
> > path isn't permitted for databases.
Have you done an
$ initlocation /othe
>Now I wonder how I have to configure the postmaster to get this
>working...
Try starting it with the -i option to tell the postmaster to listen to TCP
Sockets, too.
If it isn't that, you might have a different port, the postmaster is
listening to, or a "misconfigured" firewall/packetfilter.
At 11:21 2001-04-26 -0500, Omar Sanchez - Informatica wrote:
>I installed linux redhat 6.2 for sun sparc 5. I am using postgresql,
>wish to know how do i connect 2 different data base over 2 different
>server.
Do you want to "merge" the two databases virtually, or do you simply want
to connect
Hi Bill!
>After shutting down the entries were still there.
Hmm, is this normal on your system? Because this would indicate a serious problem with
your configuration (it's certainly not Postgres' fault).
Try shutting down the postmaster again, and if the smhs are still there, then maybe
you
At 13:26 2001-03-29 -0500, DHSC Webmaster wrote:
>Thank you Tom. Here are the results.
>[root@atl01371 linux]# ipcs
>These values don't seem to change from one moment to the next although
>there are of course varying numbers of backends running at any given
>moment.
Did you issue ipcs when runni
>I am putting together a large database and want the
>table to reside on a partition separate from the
>default under 'base'. How can I do this?
You could create symlinks for the larger tables pointing to another location:
ln -s /path/to/table/bigtable /usr/local/pgsql/data/base/whatever/bigtab
>7.1 uses a slightly different approach that hopefully avoids this
>particular failure scenario...
Is there any information availible _how_ this is avoided? I'd be interested, and if
nothing/noone else helps, I'll study the source :)
But I'd be nice to point me to a document explaining the nove
At 16:47 2001-03-12 +, Simon wrote:
>Hi having problems with postmaster Having su up to the postgres
>superuser
>
>postmaster -i -D /usr/local/pgsql/data
>
>Responds with
>
>Write to pid file failed
>Please check the permission and try again
maybe files installed as root and no writepermi
Servus Christian!
At 22:07 2001-03-12 +0100, Christian Marschalek wrote:
>I get the followig error although TK is installed
Are you sure, yout TK-includes, libs are available to the compiler? Ever tried to
compile a simple Tk program yourself? (I've never written Tk, so I cannot give you a
"He
> Hi. I need to know if I configure my psql with perl library I also need
>the DBI::Pg class for quering my database in psql?. The following example
>will work?
if you vconfigure postgresql with --with-perl, the "native" Pg Module is built. This
one differs a bit from DBI::Pg.
For me, I do not
Hi!
>Dear Postgresql-experts,
Uh, that's what I'm not :)
>uranus% /home/lange/pgsql/local/bin/createdb testdb
>ld.so.1: /home/lange/pgsql/local/bin/psql: fatal: libpq.so: open failed: No such
>file or directory
Either you issue (if you're using bash)
$ export LD_LIBRARY_PATH=/home/lange/p
>"/opt/postgresql/bin/pg_dump: error in loading shared libraries:
>libpq.so.2.1: cannot open shared object file: No such file or directory"
ah, that explains much.
>"You can just put the postgresql lib directory in /etc/ld.so.conf and run
>ldconfig."
Yes, that's it
>But I have a question
>But I get nothing if I run it using cron.
>I think, may be oracle pg_dump can't find database
>"dbname" when it runs by crontab ?
Ist your crontab a systemwide one? (ie: /etc/crontab ?) this one's normally
run as root, but you may specify a special user. does your script run as
root,
At 10:15 2001-02-08 -0500, DHSC Webmaster wrote:
>I have successfully setup the driver on a win98 machine, but when
>performing the same process on a win2000 machine, I get the following
>error:
>ODBC--call failed, Password authentication failed for user
>'ADMINISTRATION' (#210)[Microsoft][ODBC Dr
>Is it possible to tell postgres where to create the temporary files
>(especially during clustering and re-indexing) ? Since I have very large
>tables, there is not enough space on the same partition to do clsutering.
What we did, was outsourcing the largest files to other partitions, and then
Hello again, Mario!
>started: host= user=postgres database=postgres
>InitPostgres
>FATAL 1: Database "postgres" does not exist in the system catalog.
Are you sure, you have a database calles postgres? Normally the initial Database is
called "template1"...but as I see, you don't even call for a
Hi Mario!
>FATAL 1: postgres: could not locate executable, bailing out...
seems to me, that the user, you are starting postgres as, cannot find some executable.
Make sure, all Postgres binaries are reachable via PATH. (issue echo $PATH on the
commandline to see the current paths, if you're us
At 13:09 2000-12-06 +, you wrote:
>I lost my socket connection to the database. The postmaster did not shut
>down. Made no configuration or database changes.
Sounds stupid, maybe, but: are you still starting the postmaster with the -i option?
Is networking up on your machine? Maybe that's th
At 12:48 2000-10-20 -0400, Greg Kelley wrote:
>I recently upgraded from v6 to v7. I have to get to data in three databases by using
>three different MS Access databases and the ODBC driver. Since the upgrade, two of
>the three databases will no longer let me add/edit records saying the database
31 matches
Mail list logo
