On Tue, May 16, 2006 at 09:53:54AM -0700, Mark Holm wrote:
I have a client that is running an older version of Lyris List
Manager against PostGres 7.1.2, that has crashed their database
beyond my ability to recover it. The error that I am getting when we
try and restart the database is:
Very
On Thu, 18 May 2006, Tom Lane wrote:
Jeff Frost [EMAIL PROTECTED] writes:
I seem to get alot of these:
May 17 21:34:04 discord postgres[20573]: [5-1] WARNING: could not rename file
pg_xlog/archive_status/00010001.ready to
May 17 21:34:04 discord postgres[20573]: [5-2]
On Wed, 17 May 2006, Jeff Frost wrote:
And in the window where I started postgres via pg_ctl, I had this:
cat: pg_xlog/0001000E: No such file or directory
cat: pg_xlog/0001000E: No such file or directory
Hrmmm...my pgbench died with an integer out of range
On Wed, 2006-05-17 at 22:45 -0700, Jeff Frost wrote:
On Thu, 18 May 2006, Tom Lane wrote:
Jeff Frost [EMAIL PROTECTED] writes:
I seem to get alot of these:
May 17 21:34:04 discord postgres[20573]: [5-1] WARNING: could not rename
file
louis gonzales wrote:
Software error:
install_driver(Pg) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.8.7/sun4-solaris/auto/DBD/Pg/Pg.so' for
module DBD::Pg: ld.so.1: perl: fatal: libgcc_s.so.1: open failed: No such
file or directory at
Jeff Frost [EMAIL PROTECTED] writes:
Hrmmm...my pgbench died with an integer out of range error:
That's normal, if you run it long enough without re-creating the tables.
It keeps adding small values to the balances, and eventually they
overflow. (Possibly someone should fix it so that the
On Thu, 18 May 2006, Simon Riggs wrote:
Seems so.
Can you post the full test, plus full execution log.
[You don't need to cat you could just do ls instead FWIW]
Are you doing *anything* with pg_xlog directory or below? I understand
your saying No to that question and pg_xlog has not been
Hello,
my team is in the process of migrating some data from a mysql (5.0) database to our core postgres (8.1.3) database.
We are running into some performance issues with the postgres versions of the queries.
MySQL takes about 150ms to run the query where postgres is taking 2500ms.
The
It looks like you
forgot to attach the query sample. Have you collected statistics on your
tables/indexes to help the planner select a better plan?
--
Husam
http://firstdba.googlepages.com
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Warren
LittleSent: Thursday, May
Hello,
I have a problem with the driver JDBC3,
MyTable(col1(SERIAL), col2(VARCHAR), Col3(VARCHAR))
When i do
rs.moveToInsertRow();
rs.updateString(col2,col2);
rs.updateString(col3,col3);
rs.insertRow();
con.commit();
rs.next();
rs.refreshRow();
The ResulSet is not refreshed for the first
Sorry,
here are the attachments.
Not sure about the statistics question, I have done a vacuum analyze on every table in the database.
On Thu, 2006-05-18 at 09:12 -0700, Tomeh, Husam wrote:
It looks like you forgot to attach the query sample. Have you collected statistics on your
Is that possible? I've checked the docs for 8.1, and am not finding
anything, nor anything in contrib ...
the best I've been able to think of so far is to modify pg_hba.conf to not
allow new connections for the duration of the operations I need to perform
(drop and create a database) ...
Hi List,
I want to find out all the users under a specific user.
postgres is a superuser of postgresql,
under in postres user i made one user ABC and
under this ABC user i made XYZ,MNO,IJK users.
Now i want to find out all the users, which r exist
under in ABC user so what is the query for it?
Marc G. Fournier [EMAIL PROTECTED] writes:
Is that possible? I've checked the docs for 8.1, and am not finding
anything, nor anything in contrib ...
the best I've been able to think of so far is to modify pg_hba.conf to not
allow new connections for the duration of the operations I need to
14 matches
Mail list logo