On Thu, Jan 19, 2012 at 7:04 PM, Alexander Fortin
wrote:
> thank you very much for your suggestion. In the meanwhile we went for a
> check on pg_stat_replication, but we'll add one as you suggest soon on the
> replicas.
You are welcome.
> By the way, maybe you know where I could find documentati
Glad to hear that you can spin up the database and get to your data.
Sorry to hear that you did end up losing data on that server.
-David Hornsby
On 1/19/2012 5:46 PM, Samuel Hwang wrote:
correct typo.
We pretty much lost the data for the last two days, but since our
postgresql wereN'T runnin
Am trying to come up with a forms based front end (windows 7 localhost) to
enter and update a lot of data in several related tables within 9.1.
I have tried to install Postgres Forms (PFM), but the app won'tconnect to my DP
instance, it gives me a message that it: " couldn't execute psql.exe;
Hi,
I am running postgres on my local machine with pgadmin3.
It was working fine till yesterday.
Today when I tried to connect to server it asked for password which I
usually won't and gave the message
"Could not connect to server : connection refused. Is the server running
on local host and
The implementation is a database firewall where postgres gets used between our
corporate and production network environments on a Linux (RHEL 4.8) platform.
Were transitioning from 8.3.7 to 9.x. and were also implementing a link to
postgres from SQL server 2005 using the PGNP OLE DB driver from p
I have been using M$ Access for about 12 years now to create forms to update
postgresql data.
I use the postgresql odbc driver to establish a connection
There were a few issues to be worked out, for example getting Access and
postgresql to agree on how to handle boolean fields, how to fetch the k
paddy carroll writes:
> 3) For 8.3.7 the locks persist a database shutdown and startup cycle - I have
> had to trash and rebuild the database in question.
> 4) For 8.3.7 I have demonstrated that I can remedy the problem by stopping
> the database, deleting the contents of pg_twophase and pg_subt
LALIT KUMAR wrote:
> I am running postgres on my local machine with pgadmin3.
>
> It was working fine till yesterday.
>
> Today when I tried to connect to server it asked for password
> which I usually won't and gave the message
>
> "Could not connect to server : connection refused. Is the
In an academic setting, we have a couple of larger than typical
Postgres databases.
One for moodle is now 15GB and another for a research project is
currently 24 GB.
I notice while upgrading Postgresql in Debian from 8.3 to 8.4, the downtime
on the 24 GB research database is extensive while using
> -Original Message-
> From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-
> ow...@postgresql.org] On Behalf Of francis picabia
> Sent: Friday, January 20, 2012 1:12 PM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] Best practise for upgrade of 24GB+ database
>
> How do other
In the documentation, it states we need to drop and recreate the
information schema.
A simple drop did not work (it required drop/cascade).
Executed the information_schema.sql. I see an entry (when using pgAdmin)
for the information_schema under the Catalogs, but I do not see any
catalog objects.
On Fri, Jan 20, 2012 at 2:45 PM, Nicholson, Brad (Toronto, ON, CA)
wrote:
>
>> -Original Message-
>> From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-
>> ow...@postgresql.org] On Behalf Of francis picabia
>> Sent: Friday, January 20, 2012 1:12 PM
>> To: pgsql-admin@postgresql.org
I am running PostgreSQL 8.4.7 (64 bit) on a Ubuntu 10.10 64 bit system.
I am trying to generate a report listing all our tables, their column
attributes (type, constraints etc.) and comments (if any) for each of
them. I'm having a hard time finding this in the catalog areas. I can
find some o
jkells wrote:
> I am running PostgreSQL 8.4.7 (64 bit) on a Ubuntu 10.10 64 bit
> system. I am trying to generate a report listing all our tables,
> their column attributes (type, constraints etc.) and comments (if
> any) for each of them. I'm having a hard time finding this in the
> catalog a
francis picabia wrote:
> That's great information. 9.0 is introducing streaming
> replication, so that is another option I'll look into.
We upgrade multi-TB databases in just a couple minutes using
pg_upgrade using the hard-link option. That doesn't count
post-upgrade vacuum/analyze time, bu
Hi all,
I have a database that we've been doing some load testing on. The
performance isn't quite where we want it to be, and while I don't
believe it's a database issue, I'm doing what I can to help speed things up.
We started off with an empty database, and started off our benchmarking
tes
Hi.
Is there any way I can force explicit use of transactions on
insert/updates?
I do have users sitting on the system, that may forget to code it that
way and it would be nice to be able to force the database to just kick
them out if it didn't happen.
--
Jesper
--
Sent via pgsql-admin ma
17 matches
Mail list logo