473,748 Members | 8,779 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

PostgreSQL DB Outage: logfile & trace question

2 New Member
Hey guy ever night it seems our DBs is locking up or like this morning crashing and restarts. Today is just my 4th day on the job, they have an offshore team that currently handles all their DBA and db work currently. I was brought on because they will be moving to a SQL Server environment soon and just kind of wanted me to work with these guys a little on the postgresql now to see whats in place.

The problem is, this offshore group is unable to tell us why the DB keeps crashing or any type of insite. I requested the log file and trace for the time of the outage last night. My issue is I want to help them but I’m just not familiar with postgresql.

So my question I wanted to ask is, are there any key error messages I should be on the look out for in a case like this where the DB keep going out. Any key words I should look for in the log file or trace?

Thanks,
May 8 '14 #1
0 1205

Sign in to post your reply or Sign up for a free account.

Similar topics

3
1210
by: Chan | last post by:
SqlParameter is a class, consider the following statements: 1> Dim Q1() as SqlParameter 2> Dim Q2 as SqlParameter() 3> Dim Q3() as SqlParameter()
7
1306
by: Richard Gutery | last post by:
I have written a COM component who's purpose is to allow a user to change his Windows (NT/AD) password via a web page. Now the component works fine when I run it in VB 6, but not via the web page. The component also returns an integer value that contains a return code from the Component (and the appropriate Windows API). The result (using the ASP page) is Zero, which indicates success. However the password doesn't change. (Zero = success,...
5
1773
by: Florian Proch | last post by:
Hi all... i'm currently working for a big project to construct a website. We need to support some browser and OS : IE 5.0 -> IE 6, Mozilla 1.2 -> 1.7, Opera 5 -> Opéra 7.5x, Netscape 4.75 -> NS 7.2, Safari and for OS : Win95/98/NT/Me/2000/XP, MacOS 9/10, Linux. I have some problems with browser on different OS. For example i have write a javascript who make a automatic submit when the page is reload.
0
1853
by: bwaha | last post by:
I've posted this question to comp.graphics.apps.gnuplot too but given that this python group may also comprise a lot of gnuplot users, and is far more active, I've posted this question here too. My apologies to those who read this twice. I posted to cgag before I decided to post here with a more meaningful subject. Anyone had any success getting stdout from gnuplot on an ms windows system (XP)? I'm trying to read mouse coordinates...
2
3689
by: Trent | last post by:
Hello, all. I have the following production DB2 environment. DB2 8.1.4 (fp4) WG edition with 2 production databases on Windows 2003 standard edition. My first question is regard with locking. I found some escalations for X lock on some tables. How do I work out an appropriate MAXLOCK & LOCKTIMEOUT settings to optimize the lock escalation issue.
3
1420
by: Miguel | last post by:
Hi all friends: It's said that Sessions objects in ASP 3.0 with IIS 5.0 occupy certain memory of the machine which take to take care about use a lot of Sessions objects in the ASPs pages of the applications. So my question is about how recommendable is to use a lot of Sessions objects in ASP.Net I want to use in my application 30 of this objects. Im gonna use them for give permissions to the users of the application. Regards.
3
1158
by: Rob C | last post by:
Hi, I turned on page level tracing, but the trace output overwrites the the controls on the page. All I did was: - create a new asp.net web app - Put 3 labels, 2 textboxes and one button on the page - Handle button click event, perform simple calculation with trace logging message - Turned on page level tracing and ran the project The labels, textboxes and button are overwritten with the trac eoutput.
2
1913
by: WB | last post by:
Hi, How can I access Server and Trace within a helper class? I have a webform that allows user to select a PDF file (on the web server) and render a jpeg image of that PDF file. The helper class has a method like this: public void ProcessFile(string virtualPath, string outputFilename) {
5
1348
by: Eric | last post by:
Hi, I am kind of new to OO and I have the following problem : I have a class containing a huge list of functions for accessing an SQL database. Public Class Transaction #region "Client" Public function GetClientInfos() as Dataset ... Public sub InsertClientInfos() ...
0
3238
by: coolatt | last post by:
hi all. I have already read the documentation for PostgreSQL Continuous Archiving and Point-In-Time Recovery (PITR) I want to know if it is possible to take regular base backup & use smaller number of WAL files for the recovery. Please advise if this is possible. thanks.
0
8989
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8828
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9367
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9319
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
6073
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4599
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3309
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2780
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2213
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.