On 07/13/2011 04:32 PM, Tom Lane wrote:
Steve Crawford writes:
I've seen the "could not open relation with OID" error a couple times
recently ...
Not worry
You might be able to dodge the problem by excluding temp relations from
the reporting query, though whether the sum of only non-temp r
Steve Crawford writes:
> I've seen the "could not open relation with OID" error a couple times
> recently and Googling for that error gives responses ranging from *very
> scary* to fuggetaboutit.
> The error today occurred running this query which is part of a database
> status reporting scrip
I've seen the "could not open relation with OID" error a couple times
recently and Googling for that error gives responses ranging from *very
scary* to fuggetaboutit.
The error today occurred running this query which is part of a database
status reporting script:
select
pg_size_pretty(sum
Hello,
As in the topic I can't connect to a PG installed in ubuntu on virtualbox.
The host system is Windows XP, pg is running on ubuntu as I van connect to
it through pgadmin on VB. When I try to connect to it from software running
on the host system I get the error asking whether the server is ru
Elliot Voris wrote:
> I work for a small college, where the library uses Evergreen to
> manage it's collection. The database is PostgreSQL driven. The
> server that Evergreen was running on crashed. The old server was
> running PostgreSQL 8.3. I've installed an updated version of
> Evergreen, incl
It seems postgres is suffering from a file system condition, so your solution
lies there and not with postgres. There are many reasons why a file system can
become read-only. For example, if you are using virtual machines and run in to
a low I/O bandwidth condition, the vm software can put the
I work for a small college, where the library uses Evergreen to manage it's
collection. The database is PostgreSQL driven. The server that Evergreen was
running on crashed. The old server was running PostgreSQL 8.3. I've installed
an updated version of Evergreen, including PostgreSQL 8.4.8. I ha
Raman kumar wrote:
> could not write to log file: Read-only file system
I'm not at all sure what you're trying to tell us or what you want
from us. You have a file system which is mounted as read-only, that
much is clear ... but not much else. That is going to break lots of
things on your co
"Smith, Andy V " writes:
> Can someone please advise what the most secure permissions are allowed for
> /usr/bin/postgres ?
> At the moment we have:
> -bash-3.2# ls -lt /usr/bin/postgres
> -rwxr-xr-x 1 root root 4574696 Jan 28 19:31 /usr/bin/postgres
> This is not considered secure.
"Not consi
The best way I found is to just treat the image as a BLOB. Create a
column with type OID and do a lo_import and an lo_export as demonstrated
in this page.
http://www.postgresql.org/files/documentation/books/aw_pgsql/node96.html
-David.
On 7/1/11 8:30 AM, francescobocca...@libero.it wrote:
Th
FYI & A
FATAL: lock file "postmaster.pid" already exists
HINT: Is another postmaster (PID 18779) running in data directory "/var/lib/pgs
ql/data"?
FATAL: pre-existing shared memory block (key 5432001, ID 3276801) is still in u
se
HINT: If you're sure there are no old server processes still run
On 11/07/11 08:18, Pavel Stehule wrote:
2011/7/10 Uwe Bartels:
Hi Pavel,
is it posible to get this running even with dynamic sql?
I didn't write that. I'm using execute to run this create table
probably yes
postgres=# do $$
declare x text;
begin
execute e'explain(format yaml) select *
Hi
Can someone please advise what the most secure permissions are allowed for
/usr/bin/postgres ?
At the moment we have:
-bash-3.2# ls -lt /usr/bin/postgres
-rwxr-xr-x 1 root root 4574696 Jan 28 19:31 /usr/bin/postgres
This is not considered secure.
Regards,
Andy V Smith
Global Database Engin
Hi
Can someone please advise what the most secure permissions are allowed for
/usr/bin/postgres ?
At the moment we have:
-bash-3.2# ls -lt /usr/bin/postgres
-rwxr-xr-x 1 root root 4574696 Jan 28 19:31 /usr/bin/postgres
This is not considered secure.
Regards,
Andy V Smith
Global Database Engi
You might want to build it yourself (configure/make/make install).
Between this (https://help.ubuntu.com/community/CompilingEasyHowTo) and
pg install instructions, you should have all you need.
-ar
On Thu, 2011-07-07 at 11:04 +0200, francescobocca...@libero.it wrote:
> Dear all,
> i tried to insta
Francesco,
This will only show on databases that have support for Application_name.
I believe this is version 9 onwards.
My 8.4 Databases Don't show it.
My 8.1 databases error with:"FATAL: unrecognized configuration parameter
"application_name",
My 9.0 databases show it.
cheers
-Origina
saravanan writes:
> [postgres@oracle bin]$ pg_config --libdir
> /usr/local/pgsql/lib
> [postgres@oracle bin]$ pg_config --pkglibdir
> /usr/local/pgsql/lib
> I set environment variables in .bash_profile
> LD_LIBRARY_PATH=/usr/local/pgsql/lib
> export LD_LIBRARY_PATH
That would only help if it we
Hi All,
I am using postgres 9.0 with streaming replication(master/standby). I
want to use pacemaker/corosync to create trigger file to indicate the
standby to take over. ho can I execute a script using pacemaker whenever
a failure happens.
Regards,
Sanjay Rao
--
Sent via pgsql-admin maili
Tom Lane-2,
Thanks for your reply.
This is my first error
Initially i got error *plpgsql.so file missing*, then created symbolic link
for /usr/local/pgsql/lib from /usr/lib/postgresql/lib
First error checks for plpgsql.so files in /usr/lib/postgresql/lib. So i
created symblink.
Second error lo
19 matches
Mail list logo
