Hello-
I have a large Postgres database on Ubuntu 12 (+100GB). I have an old,
SATA-based, spinning drive and a new SSD drive. I mainly do data analysis
on Postgres (big, ugly select statements). I see a few options:
1. SSD for data and OS. Spinning for temp space.
2. SSD for data. Spinning
Hi,
I have the same problem as Andreas Haumer did in this thread:
http://archives.postgresql.org/pgsql-admin/2008-01/msg00128.php -- I want to
be able to easily (i.e. programmatically) copy a database from one place to
another, changing the owners of all contained objects in the process.
While I
: ERROR:
relation "sites" does not exist in
Any idea what might cause the problem?
The server configuration:
PHP Version 5.0.4
PostgreSQL 8.1.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2
20030222 (Red Hat Linux 3.2.2-5)
Thanks
We are using this bad piece of the software that does not close
connections to the postgres server. Is there some setting for closing
dead connections? And not TCP/IP keep alive does not work.
---(end of broadcast)---
TIP 6: explain analyze is yo
Did you even look for the information on postgresql.org?
http://www.postgresql.org/docs/8.2/interactive/sql-createuser.html
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
I'm having a problem with some row locks where one user does the lock
and another user try to do the same, but of course, the second one will
be waiting the first user unlock it.
I would like to know if there is a way to discover if that row is locked
before I try to do the lock.
I have been
I hate to sound like a --- but did you read the README on starting the
server? You start the server by using the postmaster command:
/path/to/postmaster -D /path/to/data
look at the postgresql manual - it's all there.
J
---(end of broa
run this in the command line
locate postmaster.pid
or
find / -name "postmaster.pid" -print
that should locate any postmaster files and then remove whatever looks
like the postmaster.pif file
---(end of broadcast)---
TIP 2: Don't 'kill -9' the po
As anyone used pgmemcache? I would like to look more into a but I'm
having problems installing the sql. I'm on OS X 10.4 and the sql there
are lines causing errors:
(e.g. AS '$libdir/pgmemcache', 'memcache_server_add' LANGUAGE 'C' STRICT;)
thanks for any input and also will version 1.2 come
I had my database set to SQL_ASCII and switched to UTF8, but now I
notice that I must add a slash for periods/dots ( \. vs . ) to insert
into varchar. Is this normal?
Thanks,
J
---(end of broadcast)---
TIP 5: don't forget to increase your free spa
> In that case, maybe you edited the wrong copy of postgresql.conf?
> Try checking "SHOW max_connections" to verify what the postmaster
> thinks the value is.
Hmm, it said it still had 100. Even though the postgresql.conf stayed
unchanged, after yet another restart it works. Funny.
> I don't thin
> It sounds like you forgot to restart the postmaster after changing
> postgresql.conf. This is one of the parameters that is frozen at
server
> start ...
No, I did restart the postmaster. Actually more than once. I do not have
to restart the server after changing kernel parameters with sysctl, d
Hi,
I experience some trouble with my PG server. I get the error message
"too
many clients". Ok, so I checked the manual and adjusted the
max_connections and shared_buffers, but still the server denies access,
if
there are about 100 connections. I just recently increased the shared
buffers from 10
Thank to all
I was in the WRONG database. Sorry, and thanks!
-Original Message-
From: Tom Lane <[EMAIL PROTECTED]>
To: Jeff <[EMAIL PROTECTED]>
Cc: "PostgreSQL" <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Date: Fri, 31 Oct 2003 16:27:31 -0500
Subject: Re: [ADMIN
I have instaled Postgres 7.3.4 on RH 9,
if I excecute:
select count(*) from cj_tranh;
count
---
0
(1 row)
Why the result us CERO? the table have 1.400.000 rows!
What is wrong? Anybody help please.
---(end of broadcast)---
TIP 2: you can
Hi,
I've done some work with databases, but nothing extreme.
I just got assigned the setting up of what I'd call a
"high-reliability" site, as opposed to "high-availability" --
which I'd like too, of course :-)
I've got some ideas on how to acheive my goal, but I fear I'm
not quite up-to-date on
I am able to compile and install 7.3(b1 and b2) on osx 10.2.1 without problem.
However, I can not get 7.2.x to compile.
Is there a fix?
Ted
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-n
On Fri, 5 Apr 2002, jaya wrote:
> Hi, The documentation on MAX_CONNECTIONS mentions default of 32
> connections and a compiled in hard upper limit of 1024 connections. It
> also mentions that it can be altered when compiling the server.
>
> Does this mean that the upper limit can be increased to
(at least for int8) this changes
the behaviour wrt index usage -- most probably due to automatic
typecasting in the postgresql SQL parser.
Hope this helps...
Tycho
--
Tycho Fruru [EMAIL PROTECTED]
Users' impressions of different operating systems, expressed as em
Russ,
are you using the 8.4a version. I got this from ADC news.
---
Apple is pleased to announce a native port of TK version 8.4a4 for Mac
OS X10.1. TK is a rapid application GUI toolkit used by Tcl, Perl, and
Python. The TK release allows script developers to run existing GUI
applic
Could someone create a post that shows who(user) should own
what. I have always let postgres own the pgsql directory and I see
that it is recomended that root own it.
Thanks,
Ted
-Original Message-
From: Peter Eisentraut <[EMAIL PROTECTED]>
To: Stefan Huber <[EMAIL PROTECTED]>
Date
What happens when you update from your data dump (pg_dumpall)
that you do to backup your data? You did do a pg_dumpall before
you did the update? I don't think it is required to upgrade from 7.1.2
to 7.1.3.
What happens when you run version 7.1.2 and access the data?
/home2/pgsql /home2/pgsql
Or one can use webmin to manage. But I haven't figured out how. The
problem is when I enter PostgreSQL server, it rejects me and says
"Webmin needs to know your PostgreSQL administration login and password
in order to manage your database."
Does anyone know how to se
hello!!
If you already have created the triggers functions, the correct
description of this is in the file:
/postgres/postgresql-6.4.2/contrib/spi/REAME
Depending on the type of trigger or integrity to applY , you must
create functions only on the administrator account
Here is what I had to do to get this to compile on my Sun running
Red Hat 4.1 Sparc-Linux:
in the file src/backend/storage/file/fd.c:
#ifndef HAVE_SYSCONF
no_files = (long) NOFILE;
#else
/* no_files = sysconf(_SC_OPEN_MAX); */
no_
gcc -I../../../include -I../../../backend -O2 -Wall
-Wmissing-prototypes -I../.. -c single.c -o single.o
ld -r -o SUBSYS.o lmgr.o lock.o multi.o proc.o single.o
make[3]: Leaving directory
`/u/u7/p/postgres/postgresql-6.4.2/src/backend/storage/lmgr'
make[3]: Entering directory
`/u/u7/p/post
Hello!
I've got a problem with converting my old database from version 6.3.1 to
6.4. I tried pg_dumpall, but in the 6.4 psql cannot import it. It crashes
with error. Maybe someone knows any other conversion utility? I've got a
big database (pg_dumpall result is about 50MB), I am running linux 2.0.
Where is the list archived? I did not see a ling to an archive on
the postgreSQL home page.
I would like to have a look there before bothering y'all with my
questions.
TIA
Sincerely,
Jimmie F
28 matches
Mail list logo
