Navicat PostgreSQL Manager for Mac OS X ver. 6.1.5 is Universal Binary and improved the Backup, Restore and Data Transfer features.
Major features of Navicat at a glance:
- Visual Query Builder- SSH Tunnel for remote database connection- Database transfer from server to server- Data and Stru
Hi,
Currently we want to upgrade postgresql to 8.1.3 but our current postgresql
database (v7.2.2) is use in the production line so we can't stop the
current database.
So is there any way to synchronize backup the current postgresql database
to another remote postgresql database without interru
On Mon, 2006-05-15 at 14:29 -0700, Jeff Frost wrote:
> On Mon, 15 May 2006, Simon Riggs wrote:
>
> > On Mon, 2006-05-15 at 09:28 -0700, Jeff Frost wrote:
> >> I've run into a problem with a PITR setup at a client. The problem is that
> >> whenever the CIFS NAS device that we're mounting at /mnt/p
On Mon, 2006-05-15 at 16:29, Jeff Frost wrote:
> On Mon, 15 May 2006, Simon Riggs wrote:
>
> > On Mon, 2006-05-15 at 09:28 -0700, Jeff Frost wrote:
> >> I've run into a problem with a PITR setup at a client. The problem is that
> >> whenever the CIFS NAS device that we're mounting at /mnt/pgbacku
On Mon, 15 May 2006, Simon Riggs wrote:
On Mon, 2006-05-15 at 09:28 -0700, Jeff Frost wrote:
I've run into a problem with a PITR setup at a client. The problem is that
whenever the CIFS NAS device that we're mounting at /mnt/pgbackup has
problems
What kind of problems?
It becomes unwritabl
On Mon, 2006-05-15 at 09:28 -0700, Jeff Frost wrote:
> I've run into a problem with a PITR setup at a client. The problem is that
> whenever the CIFS NAS device that we're mounting at /mnt/pgbackup has
> problems
What kind of problems?
> , it seems that the current client connection gets block
Jim C. Nasby wrote:
On Mon, May 15, 2006 at 12:56:16PM -0500, Xu, Xiaoyi (Rocky) FSM wrote:
Thank you Andy.
The server is SunOS 5.8 Generic_117350-29 ultra-250. The db is version 7.
7.what?
I checked disk (df -k) telling me /home0 is full 100% that has DB on. Former
DBA has notes to delet
On Mon, May 15, 2006 at 02:55:04PM -0500, Xu, Xiaoyi (Rocky) FSM wrote:
> Jim,
>
> I will find out the detailed version. Meanwhile /home0 is around 8.6 GB.
> I don't know how large the DB is. Which file or which command I should
> look for? About vacuuming, I don't know either. Can I do vacuuming
Jim,
I will find out the detailed version. Meanwhile /home0 is around 8.6 GB.
I don't know how large the DB is. Which file or which command I should
look for? About vacuuming, I don't know either. Can I do vacuuming while
making DB online? I am helping an internal department whose IT person
left a
On Mon, May 15, 2006 at 12:56:16PM -0500, Xu, Xiaoyi (Rocky) FSM wrote:
> Thank you Andy.
>
> The server is SunOS 5.8 Generic_117350-29 ultra-250. The db is version 7.
7.what?
> I checked disk (df -k) telling me /home0 is full 100% that has DB on. Former
> DBA has notes to delete large log fi
On Mon, May 15, 2006 at 09:55:23PM +0530, Gourish Singbal wrote:
> Thanks a lot for the information . We have modified the postgresql.conf file
> to have max_fsm_pages to 30. And restarted the database after doing a
> Vacuum Full .
>
> INFO: free space map contains 11518 pages in 56 relations
On Mon, May 08, 2006 at 08:37:32PM -0400, Ketema Harris wrote:
> Hello. I have been reading up on Sony Replication, and at first I thought
> Master/Slave between two offices would be perfect for my situation. After I
> got more info though I believe it may not suit my needs. If I want the two
>
On Mon, 15 May 2006, Tom Lane wrote:
That's what I thought, but that doesn't seem to be what I'm observing. Of
course the NAS device only gets wedged about once every month or two, so it's
difficult to reproduce.
If it's really a PG bug, it should be trivial to reproduce: put a long
sleep in
Jeff Frost <[EMAIL PROTECTED]> writes:
> On Mon, 15 May 2006, Tom Lane wrote:
>> No, I can't see what the connection should be there. It's supposed to
>> be designed so that the archive command can take its sweet old time and
>> nothing happens except that a backlog of WAL files builds up in pg_xl
On Mon, 15 May 2006, Tom Lane wrote:
No, I can't see what the connection should be there. It's supposed to
be designed so that the archive command can take its sweet old time and
nothing happens except that a backlog of WAL files builds up in pg_xlog.
That's what I thought, but that doesn't s
Jeff Frost <[EMAIL PROTECTED]> writes:
> I've run into a problem with a PITR setup at a client. The problem is that
> whenever the CIFS NAS device that we're mounting at /mnt/pgbackup has
> problems, it seems that the current client connection gets blocked and this
> eventually builds up to a "
Title: Error in MS Access
Thank you Andy.
The server is SunOS 5.8 Generic_117350-29
ultra-250. The db is version 7.
I checked disk (df -k) telling me /home0 is
full 100% that has DB on. Former DBA has notes to delete large log files
(server.log). But this time I didn't find same file.
What might be more bullet proof would be to make the archive command
copy the file to an intermediate local directory, then have a
daemon/cron job that wakes up once a minute or so, check for new files,
then copy them to the network mount. You may want to use something like
lofs to make sure t
I've run into a problem with a PITR setup at a client. The problem is that
whenever the CIFS NAS device that we're mounting at /mnt/pgbackup has
problems, it seems that the current client connection gets blocked and this
eventually builds up to a "sorry, too many clients already" error. I'm
w
Thanks a lot for the information . We have modified the postgresql.conf file to have max_fsm_pages to 30. And restarted the database after doing a Vacuum Full .
INFO: free space map contains 11518 pages in 56 relationsDETAIL: A total of 12320 page slots are in use (including overhead).123
On Mon, May 15, 2006 at 10:38:47AM -0500, Xu, Xiaoyi (Rocky) FSM wrote:
> Hi,
>
> My database users are getting following error:
>
> ODBC-call failed
> Error while executing query
> Error: ItsWriteBlock: failed to write block 1 of temporary file
> Perhaps out of disk space (#1)
Does the command
On Mon, May 15, 2006 at 11:17:31AM -0400, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > On Sun, May 14, 2006 at 10:50:50PM -0400, Tom Lane wrote:
> >> Enzo Daddario <[EMAIL PROTECTED]> writes:
> >>> I am now required the remove thousands of obsolete records from table
> >>> "X" a
Title: Error in MS Access
I take it you’ve checked your
server? i.e. disk space, available memory, state of the postgresql
service?
If you provide some more info, such as the
platform you’re running the server on, server version, ODBC driver
version etc, we could help more.
Andy
Title: Error in MS Access
Hi,
My database users are getting following error:
ODBC-call failed
Error while executing query
Error: ItsWriteBlock: failed to write block 1 of temporary file
Perhaps out of disk space (#1)
This happens in front-end Access. Could anyone shed some light on t
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> On Sun, May 14, 2006 at 10:50:50PM -0400, Tom Lane wrote:
>> Enzo Daddario <[EMAIL PROTECTED]> writes:
>>> I am now required the remove thousands of obsolete records from table
>>> "X" and even though I have removed all related rows in all related
>>> ta
On Mon, May 15, 2006 at 12:18:50PM +0530, Gourish Singbal wrote:
> Group.
>
> Need some help in understanding the tuning parameter.
>
> we got the below message on database wide vacuuming :-
> Vacuuming Result outcome on Sun May 14 20:22:47 PDT 2006 :-
> INFO: free space map contains 195236 page
On Sun, May 14, 2006 at 10:50:50PM -0400, Tom Lane wrote:
> Enzo Daddario <[EMAIL PROTECTED]> writes:
> > I am now required the remove thousands of obsolete records from table
> > "X" and even though I have removed all related rows in all related
> > tables, the deletion of rows in table "X" is tak
On Sat, May 13, 2006 at 11:08:58PM +0200, Thomas SMETS wrote:
> I was wondering if they were a set of stored procs like the Log4PLSQL
> available for PostgreSQL ... ?
I don't know, what's Log4PLSQL do?
If anything exists, you'll probably find it at http://pgfoundry.org.
--
Jim C. Nasby, Sr. Engi
On Mon, 2006-05-15 at 09:59, Jim C. Nasby wrote:
> On Fri, May 12, 2006 at 01:14:18PM -0400, Sean Hamilton wrote:
> > I'm currently working on an EHR myself and would love to hear a solution
> > to this.. If youget valuable feedback can you please forward that to me?
> > and if I hear anything I'
On Sat, May 13, 2006 at 03:47:00AM -0500, Thomas F. O'Connell wrote:
>
> On May 13, 2006, at 12:35 AM, Tom Lane wrote:
>
> >VACUUM FULL does all right at packing the table (except in
> >pathological
> >cases, eg a very large tuple near the end of the table). It mostly
> >bites as far as shrink
On Fri, May 12, 2006 at 01:14:18PM -0400, Sean Hamilton wrote:
> I'm currently working on an EHR myself and would love to hear a solution
> to this.. If youget valuable feedback can you please forward that to me?
> and if I hear anything I'll do the same
Given how complex HL7 apparently is (some
By default in Windows 2000, passwords are set to expire after 42 days (in my
experience.)
So after 42 days, Windows will stop the user from being able to
authenticate, so the service cannot logon.
When you reset the password, the 42-day expiry counter begins again.
If you run the Local Users & Gr
The solution is write again de password to user postgres in windows, or the
user that run the service.
I don't know why happen that, but in my experience this must solve your
problem.
Where i should mention the password.
Is it in Users of Controlpanel i need to change my password.Bcoz mine is
al
33 matches
Mail list logo