CONCURRENTLY' as 9.2.2
Why don't you try to reindex the indexes in your database and see it
this helps?
regards,
- --
Rafael Martinez Guerrero
Center for Information Technology
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafae
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
- Original Message
Subject: Re: [ADMIN] psql error on postgresql-9.0 : psql: symbol lookup
error: psql: undefined symbol: PQconnectdbParams
Date: Wed, 28 Dec 2011 16:03:31 +0530
From: Suresh Hosur
To: Rafael Martinez
Hello
ql) and which libpq your executables are trying to use
(ldd /path_to_executable/psql).
You can either delete the libpq installed in your system and use the one
you have installed under /usr/pgsql-9.0/, or upgrade the libpq in your
system to a version compatible with what you have installed under
-06-15 23:36 pgstat.stat
> -rw-r--r-- 1 novell novell 0 2011-06-15 23:36 a
>
Hei
Are you running postgres with the user 'novell' or 'postgres'?
The user running postgres must own the directories with the data.
regards,
- --
Rafael Martinez Guerrero
Center for Inform
ously considered unsupported; and testing of the case found some
bugs that are now fixed."
I don't know what "some bugs that are now fixed" means, but I think I
read somewhere that killing a session with the command kill was not a
god idea.
regards
--
Rafael Martinez,
ot do this yet :(
It's an open item in the TODO list:
http://wiki.postgresql.org/wiki/Todo
And yes, it will be a good thing to have.
--
Rafael Martinez,
Center for Information Technology Services
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
--
Sent via
e until
it finish. I can count with one hand the times we had to run vacuum full
in our systems in the last 6 years.
Use a normal vacuum analyze if 'autovacuum' is not enough for you.
--
Rafael Martinez, <[EMAIL PROTECTED]>
Center for Information Technology Services
University
LV, we are talking about a few seconds downtime.
Just an idea :)
More information about LVM:
http://www.tldp.org/HOWTO/LVM-HOWTO/
http://www.tldp.org/HOWTO/LVM-HOWTO/snapshotintro.html
http://www.tldp.org/HOWTO/LVM-HOWTO/snapshots_backup.html
with regards
--
Rafael Martinez, <[EMAIL PRO
On Tue, 2006-03-28 at 17:17 -0600, Jim C. Nasby wrote:
> On Wed, Mar 29, 2006 at 01:05:59AM +0200, Rafael Martinez wrote:
> > I work with postgresql every day and I am very happy with it, but this
> > does not mean I can not see the issues that could be improve to have a
> &
t be in the new version (and this can be
a lot of data in a busy/large system)
--
Rafael Martinez, <[EMAIL PROTECTED]>
Center for Information Technology Services
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
---(end of broadcast)
On Tue, 2006-03-28 at 15:15 -0600, Scott Marlowe wrote:
> On Tue, 2006-03-28 at 13:51, Rafael Martinez wrote:
> > On Tue, 2006-03-28 at 12:09 -0600, Jim C. Nasby wrote:
> >
> > >
> > > Fortunately, you can use Slony to migrate between versions, greatly
> >
investment only
for the upgrade.
I am sure we can find another way of doing this that is easier and
faster.
--
Rafael Martinez, <[EMAIL PROTECTED]>
Center for Information Technology Services
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
---
a big minus I hear everywhere I explain/discuss
about postgres for 24/7 and big databases.
It would be wonderful to see a solution to these two 'problems' in the
future so postgres becomes an even better product than it is now.
--
Rafael Martinez, <[EMAIL PROTECTED]>
Center for
On Tue, 2005-11-08 at 18:23, Moises Alberto Lindo Gutarra wrote:
> you only need make postgres 8.1.0 run using another port, example 5438
>
Or another IP/address (listen_addresses) and the same port 5432. ;)
--
Rafael Martinez, <[EMAIL PROTECTED]>
Center for Information Technol
body knows when this functionality will be available with
prod-quality?
--
With regards
Rafael Martinez
USIT, University of Oslo
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
15 matches
Mail list logo
