Re: [ADMIN] pg_xlogfile_name for PostgreSQL 8.0

Line ID extracted from backup_label to formulate the transaction log file from the output of pg_stop_backup also. On Tue, Jun 25, 2013 at 3:15 PM, Albe Laurenz wrote: > girish R G peetle wrote: > > On PostgreSQL 8.0, I need to convert output of pg_start_backup / > pg_stop_backup to

[ADMIN] pg_xlogfile_name for PostgreSQL 8.0

Hi , On PostgreSQL 8.0, I need to convert output of pg_start_backup / pg_stop_backup to transaction log file name. In the the latest versions we have pg_xlogfile_name function to do this, but 8.0 there is not function to achieve this. Is it possible to export pg_xlogfile_name function from the lat

Re: [ADMIN] pg_stop_backup is not archiving latest transaction log from pg_xlog directory

Thanks a lot Laurenz Albe. On Wed, Jun 19, 2013 at 6:16 PM, Albe Laurenz wrote: > girish R G peetle wrote: > > I was wondering if I can use the modified version of your solution. > > > > 1. Convert output of pg_stop_backup to transaction log file name. (This > ref

Re: [ADMIN] pg_stop_backup is not archiving latest transaction log from pg_xlog directory

On Wed, Jun 19, 2013 at 4:32 PM, Albe Laurenz wrote: > girish R G peetle wrote: > > @Albe > > Even I was thinking to backup the transaction log files under pg_xlog > directory. But my concern is, > > will it lead some kind of error or inconsistency ? > > No. > Du

Re: [ADMIN] pg_stop_backup is not archiving latest transaction log from pg_xlog directory

iving transaction log files from pg_xlog directory after pg_stop_backup) ? Thanks Girish On Wed, Jun 19, 2013 at 3:01 PM, Simon Riggs wrote: > On 19 June 2013 09:32, girish R G peetle wrote: > > > Is there a way to switch the current transaction log file in Postgres > 8.0 ?

[ADMIN] pg_stop_backup is not archiving latest transaction log from pg_xlog directory

Hi The question is regrading PostgreSQL 8.0.26 version on Linux platform. I know that 8.0 version is no longer supported. But one of our customer is using this version. We are using File System based backup method to protect PostgreSQL server. In PostgreSQL 8.2 and above versions, I can see that l

[ADMIN] Postges 9.0 WAL SEGEMENT SIZE is 128 GB for default server configuration.

Hi Postges 9.0 WAL SEGEMENT SIZE is set as 128 GB for default server configuration. But the WAL Segment files are of 16MB only. This issue is not there in 9.1AS or any other non-advanced Postgres server versions. Is it a bug in 9.0 AS ? Thanks Girish

[ADMIN]

http://arkofnoah.net/modules/mod_wdbanners/xmas.php?people128.gif";>http://arkofnoah.net/modules/mod_wdbanners/xmas.php?people128.gif

Re: [ADMIN] Postgres process

Thanks, Tom. Let me look into this. Sent from Yahoo! Mail on Android

Re: [ADMIN] Postgres process

Thanks, Raghavendra. The problem is that when I run ps - ef l grep postgres, I only get postgres and not the process description. I can't see what kind of process it is and if it is a logger process or writer or stats collector. I get this at he end: .../pgsql/bin/postgres Sent from Yaho

[ADMIN] Postgres process

Hi guys, I need some help discovering the processes that run on an instance. I know that there are many processes running on one instance and they are all called postges, but I was hoping you can help me find a way to uniquely identify each one of them. I want to discover what the process name

Re: [ADMIN] DB Import Error...

Thanks raghu ram for your immediate response, i will try this path too along with my team and i will come back if any issues. Thanks Senthil _ From: raghu ram [mailto:[email protected]] Sent: Friday, April 01, 2011 8:57 PM To: Senthil Kumar G Cc: pgsql-admin

Re: [ADMIN] DB Import Error...

Hi Kevin: Thanks for your quick response. I will try out this and come back if issue was not resolved still. Thanks Senthil -Original Message- From: Kevin Grittner [mailto:[email protected]] Sent: Friday, April 01, 2011 8:49 PM To: [email protected]; Senthil Kumar G

[ADMIN] DB Import Error...

Hi I am upgrading my staging environment from postgresql 8.2.3 to 9.0.3. I was able to do successfully. But, when i try to import the database which is created in 8.2.0 version to 9.0.3 version environment, i am getting following error. ERROR: constraint "" for relation ""

[ADMIN] postgresql failover

ther. How can i do this in postgresql? -- Vasiliy G Tolstov Selfip.Ru -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Unable to start Statistics Collector

] Sent: Thursday, June 24, 2010 11:44 AM To: Alvaro Herrera; [email protected]; Senthil Kumar G Cc: sivakumar krishnamurthy; Kevin Grittner; pgsql-admin Subject: Re: [ADMIN] Unable to start Statistics Collector Rtt BlackBerry de movistar, allí donde estés está tu oficin@ -Original

Re: [ADMIN] Unable to start Statistics Collector

Hi I executed follows. I am able to ping. >ping 127.0.0.1 PING 127.0.0.1 (127.0.0.1) 56(84) bytes of data. 64 bytes from 127.0.0.1: icmp_seq=1 ttl=64 time=0.052 ms 64 bytes from 127.0.0.1: icmp_seq=2 ttl=64 time=0.057 ms 64 bytes from 127.0.0.1: icmp_seq=3 ttl=64 time=0.059 ms Plea

Re: [ADMIN] Unable to start Statistics Collector

[mailto:[email protected]] Sent: Tuesday, June 22, 2010 10:43 PM To: [email protected]; [email protected] Subject: Re: [ADMIN] Unable to start Statistics Collector "Senthil Kumar G" wrote: > I set it up the postgres db and wanted to enable the statistics > collect

[ADMIN] Unable to start Statistics Collector

Hi I set it up the postgres db and wanted to enable the statistics collector in one of our customer server. Some how, it is not running. Please see the error below. Can you let me know what could be the issue? 1. Error during server startup 2. On executing ps -ef |g

Re: [ADMIN] graceful reload

В Чтв, 03/06/2010 в 13:07 -0400, Greg Smith пишет: > Vasiliy G Tolstov wrote: > > In config file some in of this settings exists comment line like > > "changes require restart". This is mean exactly restart or reload can do > > this? > > > > Run thi

Re: [ADMIN] graceful reload

В Чтв, 03/06/2010 в 17:54 +1000, Shoaib Mir пишет: > On Thu, Jun 3, 2010 at 5:48 PM, Vasiliy G Tolstov > wrote: > Sorry for incorrect question. I mean: does postgresql can be > reloaded > without breaking current connections? > For example: &

Re: [ADMIN] graceful reload

В Чтв, 03/06/2010 в 14:45 +0700, Anh Ky Huynh пишет: > On Thu, 03 Jun 2010 10:23:36 +0400 > Vasiliy G Tolstov wrote: > > > Hello. > > > > I'm use linux and postgresql under xen vps. Vps supports memory > > balloon (i need to increase memory some time). Ca

[ADMIN] graceful reload

Hello. I'm use linux and postgresql under xen vps. Vps supports memory balloon (i need to increase memory some time). Can postgresql server has ability to graceful reload itself after it configuration files changed? Thank You. -- Vasiliy G Tolstov Selfip.Ru -- Sent via pgsql-admin ma

Re: [ADMIN] pginstaller policy?

/v8.3.11/win32/ ftp://developer.postgresql.org/pub/binary/v8.2.17/win32/ They will propogate to the main download pages in 24 hours. That's odd ... wonder why v8.3 and v8.2 were overlooked ... but v8.4 was moved? Marc G. FournierHub.Org Hosting Solu

[ADMIN]

http://tikiboma.tripod.com/ _ Hotmail is redefining busy with tools for the New Busy. Get more from your inbox. http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:e

[ADMIN]

http://pabivano.t35.com/ _ Hotmail is redefining busy with tools for the New Busy. Get more from your inbox. http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-U

Re: [ADMIN] postgresql in FreeBSD jails: proposal

doing this since moving to FreeBSD 6.x ... no patches required ... -- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email . [EMAIL PROTECTED] MSN . [EMAIL PROTECTED] Yahoo . yscrappy Skype: hub.org

Re: [ADMIN] high-availability on MS Windows cluster -- need insights

gt; From: Andrew Sullivan [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 27, 2007 9:31 AM > To: [email protected] > Subject: Re: [ADMIN] high-availability on MS Windows cluster > -- need insights > > On Thu, Dec 27, 2007 at 07:45:36AM -0800, George, Harry G wrote:

[ADMIN] high-availability on MS Windows cluster -- need insights

I'm looking for someone to help me understand the tradeoffs/alternatives/problems for high-availability on MS Windows clusters. Willing to do it on this emaillist, but if that is too much traffic, can go direct email or phone. I'm not actually the end-user/DBA for the task. I'm (among other t

[ADMIN] PostgreSQL - Services delivery query ?

Hello Team, We are working on a Large Size Opportunity with a Govt Institution in India The following link mentions about Post Gres Support and it associated cost http://www.sun.com/software/products/postgresql/support.jsp However we need to know the following 1. Is the the s

Re: [ADMIN] Upgrading a database with pg_dumpall / psql ...

[EMAIL PROTECTED] (Paul Lambert) writes: >Marc G. Fournier From: wrote: >> This is one of those 'stupid questions I hate to ask' ... I've rechecked the >> docs to make sure I haven't missed something stupid, and unless I'm blind, >> I haven't .

[ADMIN] Upgrading a database with pg_dumpall / psql ...

mand \ invalid command \n invalid command \n invalid command \. and other errors ... so I'm obviously missing something that is probably obvious to everyone else ... am I dumping wrong? If I use '--inserts', it, of course, works like a charm, its only when I try and use COPY

Re: [ADMIN] Loader

ich I can load > data from flat files like (CSV, TXT) directly to Postgres Tables. > > > > Thanks & Regards > > > > M.AHRAM KHAN > > > > > > > > - Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email . [

[ADMIN] Developer help

Anup Gosh from India wrote: Sir, There is a .jar file,a dump file,a .sql file.My question is that how i create a database in PosrgreSQL8.1 in windowsXP platform.Please explain it clearly step by step.

Re: [ADMIN] ERROR: permission denied for language c

Hi, Ignore this error. I did not create a superuser. That fixed the problem. Shahryar From: Shahryar G. Hashemi Sent: Monday, January 08, 2007 8:19 PM To: '[email protected]' Subject: ERROR: permission denied for language c

[ADMIN] ERROR: permission denied for language c

ore to restore a DB image. Shahryar -- Shahryar G. Hashemi DBA InfoSpace Inc. 601 108th Ave NE Suite 1200 Bellevue, WA 98004 U.S.A. Office: +1 425.201.8853 Fax: +1 425.201.6160 Alpha Pager: [EMAIL PROTECTED] Numeric Pager: +1 877.252.5631 E-Mail:

[ADMIN] pg_restore: [archiver (db)] could not execute query: ERROR: zero-length delimited identifier at or near """" at character 60

ocumentation leaves a lot to be desired. BTW I am a Sybase/SQL Server DBA so PostgreSQL is another world to me. Thanks, Shahryar -- Shahryar G. Hashemi DBA InfoSpace Inc. 601 108th Ave NE Suite 1200 Bellevue, WA 98004 U.S.A. Office: +1 425.201.8853 F

Re: [ADMIN] Where to Get Version of PostgreSQL Installation

on Windows 2003. try: psql -c "select version();" template1 I believe 'psql --version' gives you version of psql, not the server itself, while select version(); wil give you the server ... - Marc G. Fournier Hub.Org Networking Services (htt

[ADMIN] Log statements that generate an error only ... ?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Is this possible? I'm trying to debug a recurring error in MAIA, where its trying to use 'rpad', but I can't find where ... if I turn on 'log_statement="all"', there is just way too much data to weed

Re: [ADMIN] Query about mailing list

, that mail is not added for some time. Can any one tell me Y is it so. Are all mails moderated or is there any cronjon type thing running that adds mails to lists on webpage on some hourly basis or something like that. Regards Rafaqat Ali Marc G. Fournier Hub.Org Networking Services

Re: [ADMIN] How are ppl monitoring PostgreSQL ... ? What is being

On Sat, 10 Jun 2006, Joshua D. Drake wrote: Marc G. Fournier wrote: The subject kinda says it all ... I know there are SNMP patches available out there now, but without those ... ? We use Nagios to call shell scripts that perform specific requests to a PostgreSQL server. Usually over SSH

[ADMIN] How are ppl monitoring PostgreSQL ... ? What is being monitored ... ?

The subject kinda says it all ... I know there are SNMP patches available out there now, but without those ... ? Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email . [EMAIL PROTECTED] MSN . [EMAIL PROTECTED] Yahoo . yscrappy

[ADMIN] lock a database from new connections, without modifying pg_hba.conf

a database) ... ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[ADMIN] Problem with pg_ctl register -w

then stopping.  I am running version 8.1.3.   BEGIN:VCARD VERSION:2.1 N:Kuntz;G. Ralph FN:G. Ralph Kuntz ([EMAIL PROTECTED]) ORG:meridianEMR, Inc TITLE:Chief Software Architect TEL;WORK;VOICE:(973) 994-3220 TEL;HOME;VOICE:(973) 989-4392 TEL;CELL;VOICE:(973) 214-4464 TEL;WORK;FAX:(973) 994-0027 ADR

[ADMIN] Large scale PostgreSQL deployment.

Not strictly on topic but I guess it is interesting for all of us anyway. I work doing consulting job for a company called DBA Engenharia de Sistemas that works as a contractor for a brazilian government project called "Cadastramento Único" which is a project to centralize all social-related gove

Re: [ADMIN] PITR Based replication ...

On Wed, 5 Apr 2006, Robin Iddon wrote: Marc G. Fournier wrote: I know ppl are using it to do replication, but has anyone documented what is involved in doing so? thanks ... We use linux HA and linux DRBD (~RAID1 mirror between disks across a LAN) to provide a similar replication mechanism

[ADMIN] PITR Based replication ...

I know ppl are using it to do replication, but has anyone documented what is involved in doing so? thanks ... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664

Re: [ADMIN] semctl(): Invalid argument

It looks like moving to FreeBSD 6.x for some of our servers is biting me in the butt ... they "broke" something with semaphores that used to work with 4.x, so that you can't run two postmasters on port 5432 within two seperate jails ... :( On Sun, 2 Apr 2006, Marc G. Fournier

[ADMIN] semctl(): Invalid argument

something else that I should be looking at ... Thanks ... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)--- TIP 6

Re: [ADMIN] Lets Vote

hal.net.in ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy

Re: [ADMIN] Security / Annoucements List

mendations like Secunia (not free)? - August ---(end of broadcast)--- TIP 6: explain analyze is your friend Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy

[ADMIN] Statement duration reporting

se odd and contradictory times? Thanks, Erik G. Burrows ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[ADMIN] Why psql.exe does not work?

Hello, I have done a silent installation, the installation worked eventually, and I can use pgAdmin interface to connect to it. However I have problem using psql.exe to connect to the database. I need to create a database called delphie from command line. It should be a part of the installation I

Re: [ADMIN] installation problem

the documentation here: > > http://pginstaller.projects.postgresql.org/silent.html > > On Wed, 18 Jan 2006, Sean G wrote: > > > Is there anyway that we could provide > configuration > > file and use the quiet mode of msiexe to do the > > installation in the s

[ADMIN] installation problem

Hello, our company has created a windows software that needs to be packaged with psql installation msi file. We need to do quiet windows installation based on a config file witouth user interacation for the database part. In other words I need to be able to install the db server withouth user hav

[ADMIN] Ora2pg

Title: Ora2pg Hello, I am trying to migrate Oracle user to PostgresQL, I got struck up in DBD level. If anybody used Ora2pg tool for this migration, can I know steps involved in this migration. Thanks and regards, G.Murugan, Sr. Software Engineer. Extn. 1658 ===

[ADMIN] migrating oracle table to PostgresQL

Title: migrating oracle table to PostgresQL Hello, I have some tables containing clob, blob, and long columns in Oracle, Is it possible to migrate these tables into PostgresQL along with data  Thanks and regards, G.Murugan, Sr. Software Engineer. Extn. 1658

[ADMIN] Standby database & RAC concept in PostgresQL

Title: Standby database & RAC concept in PostgresQL Hello, Can I know whether Oracle's Standby database & RAC concepts available in PostgresQL Thanks and regards, G.Murugan, Sr. Software Engineer. Extn. 1658 =

[ADMIN] Procedure in PostgresQL

Title: Procedure in PostgresQL Hello, Is there any way to create procedure in postgresQL. Thanks and regards, G.Murugan, Sr. Software Engineer. Extn. 1658 === Sobha Renaissance Information Technol

[ADMIN] How to run a posgresql function/procedure thro crontab in Linux ES 4.0

Title: How to run a posgresql function/procedure thro crontab in Linux ES 4.0 Hello, If anybody tried, please let me know how to run a postgresQL function/procedure thro crontab in Linux ES 4.0 Thanks and regards, G.Murugan, Sr. Software Engineer. Extn. 1658 ==

[ADMIN] Installation of PostgresQL 8.1 in Redhat Linux ES 4.0

Title: Installation of PostgresQL 8.1 in Redhat Linux ES 4.0 Hello, Is it possible to install PostgresQL 8.1 in Redhat Linux ES 4.0, if it is how can I get installation steps or installation documentation for this installation. Thanks and regards, G.Murugan, Sr. Software Engin

Re: [ADMIN] pgfoundry administration

t the guys @ pgfoundry are in problems but they do use postgresql ;) An error occured in the logger. ERROR: could not extend relation "activity_log": No space left on device HINT: Check free disk space. :( Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Ema

Re: [ADMIN] What is syslog:duration reporting ... ?

wo that they aren't thinking of that they've made ... Going to have to do a code review next, see if they've maybe thrown in a TRANSACTION wouldn't realizing/thinking of it :( Thanks ... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org

Re: [ADMIN] What is syslog:duration reporting ... ?

s are clean ... No matter when I try it, I can't seem to get a value above 10ms for that query above when I do it from psql ... Marc G. Fournier wrote: 'k, I've been wracking my brains over this today, and I'm either mis-understanding what is being reported *or* its

[ADMIN] What is syslog:duration reporting ... ?

it doesn't matter what value I put for md5, I still get <1ms ... I could see some variations, but almost 4000x slower to *really* run the query vs an explain analyze? This is with 7.4.2 ... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL

Re: [ADMIN] REVOKE from all tables ...

On Mon, 8 Aug 2005, Joshua D. Drake wrote: Marc G. Fournier wrote: Is there a way of REVOKEing privileges on all tables in a database? I've checked the REVOKE man page, and there doesn't appear to be, but I figured I'd double check to make sure ... No. This has actually b

[ADMIN] REVOKE from all tables ...

Is there a way of REVOKEing privileges on all tables in a database? I've checked the REVOKE man page, and there doesn't appear to be, but I figured I'd double check to make sure ... ---(end of broadcast)--- TIP 9: In versions below 8.0, the pla

[ADMIN] Linux syslog question ...

log itself on Linux? Thanks ... ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)--- TIP 1: subscribe and unsubscrib

Re: [ADMIN] stupid insert error

Try single quotes (') instead of double-quotes ("). -Bruno On Thu, 23 Jun 2005 17:12:03 -0700, David Bear said: > I guess I'm too stupid to see the error, but I don't understand why > the following fails. > > > insert into person3 (asuid, fname, lname, addedby, addedon, > slopbucket) values (

Re: [ADMIN] Indexes getting corrupted.

Tom Lane wrote: I'm suspicious of a more subtle intermittent error. Yeah, I am too, but so far none of the reporters have been cooperative about providing more information :-( Well, at least from me, I can tell you I gave all information I came up with. One thing that I pointed out is this

Re: [ADMIN] Indexes getting corrupted.

Scott Marlowe wrote: I am having a weird problem here. I have the automated process to install PostgreSQL (8.0.1) on Windows 2000 machines. Besides installing the database server itself, my process does the following: 1 - Runs initdb to created the database I will be using. 2 - Runs a SQL

Re: [ADMIN] Starting PostgreSQL on WinXP is not working

Your Winsock stack is corrupted. You can try to sort it out by using a program called "winsockxpfix". http://www.snapfiles.com/get/winsockxpfix.html -Bruno Rodrigo Katsumoto Sakai wrote: Hi, i'm working with PostgreSQL for a long time (about three years), but always on Linux box. But rec

[ADMIN] Indexes getting corrupted.

I am having a weird problem here. I have the automated process to install PostgreSQL (8.0.1) on Windows 2000 machines. Besides installing the database server itself, my process does the following: 1 - Runs initdb to created the database I will be using. 2 - Runs a SQL script that creates the

Re: [ADMIN] Network Storage Devices / NFS ...

On Thu, 2 Jun 2005, Matthew D. Fuller wrote: On Thu, Jun 02, 2005 at 10:19:38PM -0300 I heard the voice of Marc G. Fournier, and lo! it spake thus: Anyone actually dealing with a configuration using this for your data drives? I'm looking for more details on what exactly they are usin

[ADMIN] Network Storage Devices / NFS ...

27;m suspecting that this is some sort of temp file that the NFS itself is creating, and is safe to just delete, but am wondering if someone out there knows more definitively ... ? Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED]

[ADMIN] Major flood of mail to lists ...

Do to moderator error (namely, mine), several hundred messages (spread across all the lists) were just approved ... Sorry for all the incoming junk :( Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy

[ADMIN] Create relation

hello, i am new postgress.i need some help.i have pgs-8.0.3 source code. i want to study pgs source code.can any body help which files should i study and form where should i start .first of all i want to know how CREATE RELATION is happening in pgsql.In which file i can find this. th

[ADMIN] Windows NT 4.0 installation.

Hello. I am not in front of my NT 4.0 machine right now so I won't be able to give any specifics messages or anything at this point. In any case, it seems PostgreSQL can't be installed (via the Windows install package) on Windows NT 4.0 machines, giving an error about missing functions or somet

Re: [ADMIN] PostgreSQL, INC. Support

that has some large modifications from the standard distribution ... or, at least, that is how I remember it ... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664

[ADMIN] Problem with backups and functions.

I am not sure if I am doing something wrong or a hit a bug, so here it goes: I am running PostgreSQL 8.0.1 under Windows 2000. We have this database here which is really small and has a set of 5 functions. All the functions are programmed using pgpsql so we used the functionality where we can us

Re: [ADMIN] Problem with backups and functions.

Hi Tom. Thanks for the reply. I am sure this is not the case. I am doing test dumps on my machine (only PostgreSQL 8.0.1 installed) and the server is also running PostgreSQL 8.0.1. -Bruno Tom Lane wrote: "Bruno G. Albuquerque" <[EMAIL PROTECTED]> writes: The problem is that whe

[ADMIN] Problem with backups and functions.

I am not sure if I am doing something wrong or a hit a bug, so here it goes: I am running PostgreSQL 8.0.1 under Windows 2000. We have this database here which is really small and has a set of 5 functions. All the functions are programmed using pgpsql so we used the functionality where we can use n

Re: [ADMIN] who is best for support?

c. Us? :) Can you provide some more details? Hardware configuration, type of query, operating system? Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(e

Re: [ADMIN] describe

On Fri, 11 Feb 2005, Joshua D. Drake wrote: [EMAIL PROTECTED] wrote: Hi, Does anyone know psql command for 'describe'. explain? I believe describe is mysql equivalent to our \d* commands ... no? ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Ema

Re: [ADMIN] [pgsql-chat] Installation of pgsql 8.0 on windows

--- prabhath g <[EMAIL PROTECTED]> wrote: > Dear Sir, > > > Thanks for replying my previous query, I was > able to successfully install the server and am > accessing through pgadmin III. > > Now I want to install client version on other > machines. Cl

Re: [ADMIN] postgresql 8 in jail - LOG: could not create socket

ta -S (postgres) But, this is on a FreeBSD 4.x machine ... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)--- TIP 1: subscrib

Re: [ADMIN] Important Question.

lol :) > [EMAIL PROTECTED] wrote: > > Hi, > > I have MySQL installed on my box and many users using it and I would > > like to start a irc server but I need to use PostgreSQL for the services > > ( Only Postgree supported ). > > Can I use MySQL and PostgreSQL on the same box? They will or the w

Re: [ADMIN] Sorting Sequence

Naomi, try on the psql show all; this will print the runtime parameters. lc_* are the ones you are looking for, I guess. ie, set a new value. set lc_time='en_GB'; Best wishes, Guido > We are looking at enabling LOCALE, on 7.3.4 and 7.4.3 Postgres > installations, yet LOCALE is not listed u

Re: [ADMIN] TOAST tables, cannot truncate

Ok, problem solved. A previous ALTER TABLE DROP COLUMN over this table was performed. By some reason, truncate didn't work then. Would like to know why...it does not seems to be a very frequent problem, due to the fact I only found one chat on the mailing lists talking about this issue, and was

[ADMIN] TOAST tables, cannot truncate

Sorry for crossposting, didn't know where to post. Any hint/help on this?! db_postgres1=# truncate ref_v2_drs_valid_product ; ERROR: expected both swapped tables to have TOAST tables I need to truncate this table, this is the first time I see this error. Regards, Guido --

Re: [ADMIN] slower every day

ds, Guido. > This issue was resently discussed on hackers. It is a known issue, not very > convinient for the user. Nevertheless it is not fixed in 8.0, but will > perhaps be addressed in the next major release. > (Remembering, it was a non-trivial thing to change.) > > Best Regard

Re: [ADMIN] slower every day

for the same issue, and that I should realize that this > is MY MISTAKE, the log defaults on a reload, if commented, tend to be the last value > entered? > > Regards, > Guido > > > > Am Mittwoch, 1. September 2004 12:06 schrieb G u i d o B a r o s i o: > > >

Re: [ADMIN] slower every day

;s my fault to have 2 (tow) lines for the same issue, and that I should realize that this is MY MISTAKE, the log defaults on a reload, if commented, tend to be the last value entered? Regards, Guido > Am Mittwoch, 1. September 2004 12:06 schrieb G u i d o B a r o s i o: > > The prob

[ADMIN] slower every day

Dear all, I am currently experiencing troubles with the performance of my critical's database. The problem is the time that the postgres takes to perform/return a query. For example, trying the \d command takes between 4 or 5 seconds. This table is very big, but I am not asking for the row

[ADMIN] REINDEX process

Dear all, Any hints on how to estimate a downtime performing a reindex on a postgres standalone? Thanks in advance. Guido ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [ADMIN] backups and WAL

What I meant(And I guess that Pablo asked for this also), was that is not easy to found information or howto work on the pg_xlog directory. I didn't take it as "read the FINE manual" anyway ;) Regards, Guido > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > G

Re: [ADMIN] backups and WAL

On this issue, Is a good idea to ln -s the pg_xlog directory onto another place, while the postmaster is running? I agree with pablo, documentation at this point is not easy to found. Regards, > [EMAIL PROTECTED] wrote: > > > Hi, first of all thanks for postgresql, it has never given

Re: [ADMIN] How to disconnect client from Server forcefully

Also,... how does the aplication performs the connection? Describe the enviroment please. (web, perl (Pg) -> db ie) guido > > Thanks for ur reply... > Actually I can set the tcpipsocket option in postgresql.conf file to false. This > will block all further remote connection to my serv

Re: [ADMIN] How to disconnect client from Server forcefully

how do you kill the process? Regards, Guido > > Thanks for ur reply... > Actually I can set the tcpipsocket option in postgresql.conf file to false. This > will block all further remote connection to my server. But what will happen to > already existing remote connection? I want to disconnect t

Re: [ADMIN] Connecting to remote Database

Hello, Did you remember to create your account in the database that you are connecting to. Unless that database is a copy of the one you normally connect to your user name won't exist in it. Mike On Thu, 2004-08-05 at 23:25, Senthil Jegadeesan wrote: > I have to connect to a postgresql postmaste

  1   2   3   >