Re: [GENERAL] How feasible is this?

nal memory. Whether it's useful for database access or not may be an open question, but it seems very messy to say "don't retry if you've touched the database", since the point here is to be composable and not make people worry about the implementation details of some other par

[GENERAL] How feasible is this?

cause the application to spin and retry the same transaction in a loop with no delays, which is hardly ideal to say the least. Any ideas on doing better than that? -- Chris Smith -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscrip

Re: [GENERAL] Bigtime scaling of Postgresql (cluster and stuff I suppose)

> Ever read anything on how myspace is laid out? The big ones need > replication to handle the traffic. Actually no. http://highscalability.com/livejournal-architecture "Using MySQL replication only takes you so far." (Yeh it's mysql but the point is valid regardless). "You can't keep adding re

Re: [GENERAL] jdbc pg_hba.conf error

On 5/31/07, Bhavana.Rakesh <[EMAIL PROTECTED]> wrote: Ok, I confirmed that I'm editing the right pg_hba.conf file. I made sure that there are no other postmasters running. I made sure that there is a user called 'brakesh'. I restart the postmaster everytime I make any changes to pg_hba.conf

Re: [GENERAL] what is the default username password for PostgreSQL, which was installed with FC5.

On 10/27/06, Purusothaman A <[EMAIL PROTECTED]> wrote: Thanks for all of your valuable replies. Please tell me, what should i do to login with syntax psql -Uusername -h192.168.2.2 -dusername(database name). Because I should be able to login from any login and also from any system

Re: [GENERAL] Best approach for a "gap-less" sequence

On 8/12/06, Jorge Godoy <[EMAIL PROTECTED]> wrote: Hi! I was trying to solve a problem on an old system and realized that there might be some better approach for doing what I need. We have some documents that need to be ordered sequentially and without gaps. I could use a sequence, but if the

Re: [GENERAL] pgsql user change to postgres

On 7/2/06, Joe <[EMAIL PROTECTED]> wrote: Hi, I started using PostgreSQL (8.0) about a year ago on Windows. Following the installation instructions, I created a 'postgres' user (BTW, this was based on the Short Version instructions for UNIX, i.e., "adduser postgres" --I'm not sure it this is ma

Re: [GENERAL] Installation problems

On 6/30/06, Victor Escobar <[EMAIL PROTECTED]> wrote: Hello, I'm going through the elongated instructions of installing pgsql and am stuck at the point where one types: %> su - postgres When I type this and type in the password I chose, I get the following error: 'su: no directory' What dir

Re: [GENERAL] Computing transitive closure of a table

seek out a route that involves modifying the database or other such things. -- Chris Smith - Lead Software Developer/Technical Trainer MindIQ Corporation ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Computing transitive closure of a table

Oleg Bartunov wrote: Chris, have you seen contrib/ltree ? I hadn't. Thanks! I will look into it further, but I'm currently a bit concerned by the word "tree" in the title. Many of the problems I'm solving are not trees, though nearly all are DAGs. -- Ch

[GENERAL] Computing transitive closure of a table

back end. Or should I just punt and let the queries be slow (not a good option, since the group thing is necessary for permission checking, which may happen up to a half-dozen times per HTTP request). Thanks, -- Chris Smith - Lead Software Developer/Technical Trainer MindIQ Corporation

Re: [GENERAL] ean code data type

On 6/7/06, Ottavio Campana <[EMAIL PROTECTED]> wrote: Is there a data type for ean codes for postgresql 7.4? I found the isbn data type, and I would appreciate something similar for ean codes. If there isn't you can create your own: http://www.postgresql.org/docs/8.1/static/sql-createtype.html

Re: [GENERAL] postgres in windows

On 6/1/06, Antonios Katsikadamos <[EMAIL PROTECTED]> wrote: Hi all. My name is Antonios and I am doing an MSc in Advanced computing at Imperial College London. I need to install postgres for my individual project on windows. Would it be a problem to ask one- or -two questions? First of all is

Re: [GENERAL] allow LIMIT in UPDATE and DELETE

On 5/19/06, Csaba Nagy <[EMAIL PROTECTED]> wrote: Hi all, Currently the LIMIT clause is not allowed in UPDATE or DELETE statements. I wonder how easy it would be to allow it, and what people think about it ? For our application it would help a lot when processing things chunk-wise to avoid long

Re: [GENERAL] Creating of User and Database

On 5/11/06, APSC, Patrick Chee Seng Onn <[EMAIL PROTECTED]> wrote: Hi, I've just installed postgresql onto my system but unable to successfully add new users and databases. I would receive a error message: createuser: could not connect to database template1: FATAL user "root" does n

Re: [GENERAL] Connecting to PostgreSQL on Linux with windows

On 10 May 2006 07:46:01 -0700, mmaclennan <[EMAIL PROTECTED]> wrote: Hi, I have a linux box (Fedora 3) running the latest version of PostgreSQL and PostGIS. I am trying connect to the database through a windows computer but can't seem to make the connection work. I've configured the pb_hba.config

Re: [GENERAL] Debugging SQL queries

On 5/11/06, Nikolay Samokhvalov <[EMAIL PROTECTED]> wrote: From my point of view, more important problem is that log doesn't help to find the query (in other words, log message doesn't show context) Yes it does.. but it depends on your logging setup. in psql: test=# blah; ERROR: syntax error

Re: [GENERAL] understanding explain data

On 5/10/06, Alban Hertroys <[EMAIL PROTECTED]> wrote: Sim Zacks wrote: > Something such as: with this explain data, adding an index on table tbl > column A would drastically improve the efficiency. Or at least an > application that would say, the least efficient part of your query is on > this pa

Re: [GENERAL] Catch individual exceptions

On 3 May 2006 19:16:17 -0700, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: hi all, i want to capture individual sqlexceptions and for each different exception i want to display a different message to the user. the problem is how should i capture from the exception of its type-content and then dis

Re: [GENERAL] simple md5 authentication problems

On 5 May 2006 02:22:32 -0700, robert <[EMAIL PROTECTED]> wrote: Hi all, hope this is the right list. I have postgres 8.1 running on linux. We have tests that mostly run on windows. I want to run these tests on linux. On these windows boxes, pg_hba.conf has just one line: hostall al

Re: [GENERAL] Authentication & connection problems

On 5/1/06, chris smith <[EMAIL PROTECTED]> wrote: > Here's the deal. For example, when trying to connect to an existing > databas, or even > creating a new one with the command createdb [dbname], > different error occurs. What errors exactly? We can't guess

Re: [GENERAL] Authentication & connection problems

Here's the deal. For example, when trying to connect to an existing databas, or even creating a new one with the command createdb [dbname], different error occurs. What errors exactly? We can't guess.. Another example: when running the command psql, entering the password and hitting enter

Re: [GENERAL] Is PostgreSQL an easy choice for a large CMS?

On 4/30/06, Tony Lausin <[EMAIL PROTECTED]> wrote: Hello all, I'm working on a CMS which requires an open source database capable of handling hundreds of thousands of users simultaneously, with a high rate of database writes, and without buckling. We're talking somewhere between nerve.com/catch2

Re: [GENERAL] Postgres on WinXP - app on Cygwin

On 4/27/06, Tomas Lanczos <[EMAIL PROTECTED]> wrote: > I am curious, whether is it possible to connect to a PostgreSQL database > installed on WinXP for an application installed on the same box but running > in the Cygwin environment (the app. is the GRASS GIS). There are no reasons why this shoul

Re: [GENERAL] PostgreSQL 8.1 + PHP5.1.x/4.4.2 + Apache 2.0.55/1.3.34 PROBLEM!! PLEASE HELP

On 4/27/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Help! I was trying to make an installation of PHP 5.1.2 + Apache > 2.0.55 + PostgreSQL 8.1 on Windows 2003 Server, and I'm stuck. I > got PHP to work with Apache quite smoothly, so did I marry PHP with > PostgreSQL - scripts connecting to t

Re: [GENERAL] Problem with complex outer join expression

On 4/26/06, Chris Velevitch <[EMAIL PROTECTED]> wrote: > I'm using 7.4.5 on win XP Pro SP1. > > I'm getting:- > > ERROR: syntax error at or near "(" at character 155 > > from the query:- > > select dummy_records.sequence_nr,timesheets.weekending,timesheets.timesheet_id > from dummy_records >

Re: [GENERAL] How to implement a "subordinate database"?

On 4/19/06, Kynn Jones <[EMAIL PROTECTED]> wrote: > > I keep bumping against this situation: I have a main database A, and I want > to implement a database B, that is distinct from A, but subordinate to it, > meaning that it refers to data in A, but not vice versa. > > I don't simply want to add ne

Re: [GENERAL] hard shutdown of system

On 4/17/06, surabhi.ahuja <[EMAIL PROTECTED]> wrote: > > the user tries to do kill -9 -1 and log in again > > in the startup script i do the following > > /sbin/pidof -s postmaster > > and it still displays some value, > > however ps -aef | grep postmaster does not display anything > > is it ok if

Re: [GENERAL] Comparing text field

On 13 Apr 2006 12:20:08 -0700, Nik <[EMAIL PROTECTED]> wrote: > I am trying to compare a large string (that has new line characters in > it) to the contents of the text field (which also has new line > characters in it) and it is not behaving as expected. > > For example I have the following record

Re: [GENERAL] Regex with patterns in table field

On 4/14/06, pgdb <[EMAIL PROTECTED]> wrote: > > > Hi Andreas, > > strange but I don't see html from my original email received from the > mailing list, hope this reply is ok:) > > If I'm not wrong, the example you've provided is trying to return matching > rows from multiple patterns and texts as i

Re: [GENERAL] the integer type

e might be able to help you if I don't know the answer). > > -Original Message- > > From: chris smith [mailto:[EMAIL PROTECTED] > > Sent: 13 April 2006 15:17 > > To: Zahir Lalani > > Cc: pgsql-general@postgresql.org > > Subject: Re: [GENERAL] the integ

Re: [GENERAL] the integer type

> I have only recently started to use Postgresql and have a problem. I am > using v8.1 on windows. > I cannot seem to get the DB to accept either INT or INTEGER as a type > when using the admin tool. Only INT2 or INT4 work. > I even downloaded Navicat trial and this has the same issue. Is there a >

Re: [GENERAL] posting request

On 4/13/06, Anton Andreev <[EMAIL PROTECTED]> wrote: > > I want to post some questions. Go ahead and post them :) We don't bite :) -- Postgresql & php tutorials http://www.designmagick.com/ ---(end of broadcast)--- TIP 1: if posting/reading throu

Re: [GENERAL] pgcrypto-crypt

On 4/6/06, AKHILESH GUPTA <[EMAIL PROTECTED]> wrote: > dear all, > i want to encrypt and decrypt one of the fields in my table (i.e-password > field) > i have searched and with the help of pgcrypto package, using function > "crypt", i am able to encrypt my data, > but there is nothing which i fo

Re: [GENERAL] what is this error

On 4/3/06, venu gopal <[EMAIL PROTECTED]> wrote: > > Dear List, > I have created a database called dhis13 and created a login role with > user name venu and pwd gis now i have created an sql file using shp2pgsql > command it worked successfully when i m importing the same to the dhis13 > databa

Re: [GENERAL] encryption/decryption

On 4/1/06, AKHILESH GUPTA <[EMAIL PROTECTED]> wrote: > hi all, > just to ask u all one thing regarding encryption/decryption. > > i am migrating my database from mysql to pgSQL using a php script. > in mysql there is a table 'users' where a field 'password' is there of type > varchar(30), > and

Re: [GENERAL] about partitioning

On 4/1/06, fufay <[EMAIL PROTECTED]> wrote: > dear all, > i created a master table and a sub table which inherits the main table. > and then i made a trigger and a function that want to keep the master table > empty. > but the trigger didn't work anyway.when i inserted data into the table > "news",

Re: [GENERAL] giving users access to specific databases

On 4/1/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi, > > I'm hoping someone can tell me how to go about this, or if a solution is > even possible with my current set up. I realize this question may go beyond > pure postgres topics and have to do more with how my hosting company has > thei

Re: [GENERAL] How to use result column names in having cause

On 3/31/06, Andrus <[EMAIL PROTECTED]> wrote: > >> In real application I have long expression instead of 123 and do'nt want > >> repeat this expression in HAVING clause. > > > > You have to repeat the expression. "AS" changes the output name, it > > can't be used either in the where clause or any

Re: [GENERAL] How to use result column names in having cause

On 3/31/06, Andrus <[EMAIL PROTECTED]> wrote: > CREATE TEMP TABLE foo( bar integer ); > > SELECT 123 AS x > FROM foo > GROUP BY 1 > HAVING x> AVG(bar) > > causes > > ERROR: column "x" does not exist > > Why ? How to make this working ? > > In real application I have long expression instead o

Re: [GENERAL] about un-discrible

On 3/29/06, 查海平 <[EMAIL PROTECTED]> wrote: > hi, >Could anyone tell me how to un-discrible this mails list? how to do? Check the mail headers: List-Unsubscribe: -- Postgresql & php tutorials http://www.designmagick.com/ ---(end of broadcast

Re: [GENERAL] pg 8.1.2 performance issue

On 3/26/06, Ed L. <[EMAIL PROTECTED]> wrote: > On Saturday March 25 2006 9:36 pm, Ed L. wrote: > > I have a performance riddle, hoping someone can point me in a > > helpful direction. We have a pg 8.1.2 cluster using > > Apache::Sessions and experiencing simple UPDATEs taking > > sometimes 30+ sec

Re: [GENERAL] inheridt tables from db

On 3/25/06, nik600 <[EMAIL PROTECTED]> wrote: > hi > > i am considering to port an important web applications to postgres, > this applications is made of php and i reuse the same code for many > customer, due to have a clean structure and simple updates... > > now i have one code and many databases

Re: [GENERAL] Practical limit on number of tables ina single database

On 3/24/06, Just Someone <[EMAIL PROTECTED]> wrote: > Hi, > > I am creating a hosted solution that I want to base on separation by > schemas. So that each hosted family we will have, will have a schema > assigned to it (and a user). On login I will set the search path, and > so each family will see

Re: [GENERAL] can't create user collumn

On 3/17/06, loki <[EMAIL PROTECTED]> wrote: > Hi, > i'm just starting with postgres DB, but this looks very strange to me: > > If i try to create table with collumn user, it fails with error: > create exec error:ERROR: syntax error at or near "user" at character 368 > > query: > CREATE TABLE Log (

[GENERAL] full text indexing

Hi all, Just wondering which full text module is better & what the differences are between tsearch and fti ? The table in question has roughly 80,000 rows. Thanks! -- Postgresql & php tutorials http://www.designmagick.com/ ---(end of broadcast)---

Re: [GENERAL] out of memory using Postgres with Spring/Hibernate/Java

On 3/15/06, maarten roosendaal <[EMAIL PROTECTED]> wrote: > Hi, > > We are currently having a problem that our Postgres DB > is throwing an SQL error which states that it's 'out > of memory'. > > What we have is a DB with 1 table that has 3.9 million > records. We need to find certain records that

Re: [GENERAL] Question about index usage

On 3/7/06, Guido Neitzer <[EMAIL PROTECTED]> wrote: > Hi. > > Is there a reason why this query: > > select id from dga_dienstleister where plz in ('45257', '45259'); > > doesn't use this index: > > "dga_dienstleister_plz_index" btree (plz varchar_pattern_ops) > > but uses this index: > >

Re: [GENERAL] User tables

> > Suppose there 3 users red, green, blue. How can the user green know what > > tables he has created?! > > From psql command line \dt lists every table in the DB!!! > > > > Thanks in advance. > > > > Hrishi > If you mean that the owner of the table(s) is the user "green", then try > select * fro

Re: [GENERAL] Question about the contrib rpm ?

On 3/3/06, Agnes Bocchino <[EMAIL PROTECTED]> wrote: > Hello Tom, hello List, > > Sorry if we haven't been clear in our first mail. > We don't really understand your answer. > So, we try to clarify our general question and give more details : > > When we go on the web site to download PostgreSQL 8.

Re: [GENERAL] createuser permssion for group

On 2/26/06, Jebus <[EMAIL PROTECTED]> wrote: > Is it possible to give a group the the createuser permission ? This > way if a user in the group they can create users. Version 8.1.x does.. postgres=# \h create group ... | CREATEROLE | NOCREATEROLE | CREATEUSER | NOCREATEUS

Re: [GENERAL] Could DBmirror be done with the mechine using RPM installation instaed of souce code [tar.gz] ?

dbmirror) on how to do it. > 2006/2/25, chris smith <[EMAIL PROTECTED]>: > > > I use the two mechines with FC3 and postgresql 8.1 RPM installation and > > > would like to do DBmirror or other postgresql database replication from > > > master to slave server

Re: [GENERAL] Could DBmirror be done with the mechine using RPM installation instaed of souce code [tar.gz] ?

> I use the two mechines with FC3 and postgresql 8.1 RPM installation and > would like to do DBmirror or other postgresql database replication from > master to slave server . Could I do this replication using RPM or I must use > the tar.gz version ? Could anybody suggest me about replication? The

Re: [GENERAL] success with p2p ip connection

Please reply to the same thread you start instead of starting a new one every time (choose the last reply and hit "Reply to All"). [EMAIL PROTECTED] wrote: I looked at the server machine, in a section regarding ip connections, and saw that security was set to prevent other machines from connecti

Re: [GENERAL] Baffling sequential scan plan when index scan would

ion tuples is OK, but an index scan returning a single tuple is right out. What? -Confused in California ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings -- Regards, Chris Smith Unit 2, 3 National Street, Roz

[GENERAL] using limit with delete

ugh a webapp and if there are 500,000 records for example, I can't really leave the page open and expect it to finish... -- Regards, Chris Smith Unit 2, 3 National Street, Rozelle, NSW 2039 Australia Ph: +61 2 9555 5570 Fx: +61 2 9555 5571 email: [EMAIL PROTECTED]

Re: [GENERAL] sequence advances on failed insert

ence value as any type of identifier? Sven ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match -- Regards, Chris Smith Unit 2, 3 National Street, Rozelle, NSW

Re: [GENERAL] using limit with delete

On Thu, 2005-04-07 at 04:11, Chris Smith wrote: I don't care about the order in my particular case, just that I have to clear the table. I'll try the subquery and see how I go :) Thanks! Neil Conway wrote: Chris Smith wrote: I'm trying to use a limit clause with delete, but it doesn

Re: [GENERAL] using limit with delete

For the archives... Using 7.4 so IN() is a little slower, so I rewrote it slightly to be DELETE FROM table WHERE EXISTS (select x from table LIMIT ...); Works very nicely :) Thanks again. Neil Conway wrote: Chris Smith wrote: I'm trying to use a limit clause with delete, but it doesn&#

Re: [GENERAL] using limit with delete

I don't care about the order in my particular case, just that I have to clear the table. I'll try the subquery and see how I go :) Thanks! Neil Conway wrote: Chris Smith wrote: I'm trying to use a limit clause with delete, but it doesn't work at the moment It isn't in

[GENERAL] using limit with delete

y to approach this? I'm trying to delete records through a webapp and if there are 500,000 records for example, I can't really leave the page open and expect it to finish... -- Regards, Chris Smith Unit 2, 3 National Street, Rozelle, NSW 2039 Australia Ph: +61 2 9555 5570 Fx: +61 2 9555

Re: [GENERAL] Referencing created tables fails with message that

r list archives? http://archives.postgresql.org -- Regards, Chris Smith Suite 30, 45-51 Huntley St, Alexandria, NSW 2015 Australia Ph: +61 2 9517 2505 Fx: +61 2 9517 1915 email: [EMAIL PROTECTED] web: www.interspire.com ---(end of broadcast)---

Re: [GENERAL] [OT] Duration between two timestamps

t off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) -- Regards, Chris Smith Suite 30, 45-51 Huntley St, Alexandria, NSW 2015 Australia Ph: +61 2 9517 2505 Fx: +61 2 9517 1915 email: [EMAIL PROTECTED

Re: [GENERAL] Easy transaction question

ce, or can I begin the transaction, issue commands one at a time, and then end the transaction? -- Regards, Chris Smith Suite 30, 45-51 Huntley St, Alexandria, NSW 2015 Australia Ph: +61 2 9517 2505 Fx: +61 2 9517 1915 email: [EMAIL PROTECTED] web: www.interspire.com

Re: [GENERAL] sorting problem

Would doing it this way require an index: create index lower_lastname on table x lower(lastname); ? Regards, Chris Smith Suite 30, 45-51 Huntley St, Alexandria, NSW 2015 Australia Ph: +61 2 9517 2505 Fx: +61 2 9517 1915 email: [EMAIL PROTECTED] web: www.interspire.com Michael Fuhr wrote: On Fri

Re: [GENERAL] MD5

(Ignore my other reply.. ;P) You'll need to import the pgcrypto.sql file (this creates the functions for you). Read the doco on how to install the extension, it should tell you where the sql file is. Regards, Chris Smith Suite 30, 45-51 Huntley St, Alexandria, NSW 2015 Australia Ph: +61 2

Re: [GENERAL] MD5

Use the md5 function: select md5('welcome'); md5 -- 40be4e59b9a2a2b5dffb918c0e86b3d7 (1 row) Regards, Chris Smith Suite 30, 45-51 Huntley St, Alexandria, NSW 2015 Australia Ph: +61 2 9517 2505 Fx: +61 2 9517 1915 email: [EMAIL PROT

Re: [GENERAL] Debian Packages for Postgresql 8.0.0 RC1

I doubt you'll find any for an RC release... when 8 is released (final), then I think you'll find them. Regards, Chris Smith Suite 30, 45-51 Huntley St, Alexandria, NSW 2015 Australia Ph: +61 2 9517 2505 Fx: +61 2 9517 1915 email: [EMAIL PROTECTED] web: www.interspire.com Simon Wit

Re: [GENERAL] Insert do not work in my case

The easiest way to start is to turn on query logs for your server and see if it gets that far. If it does - copy the query into psql and run it manually - it will tell you if there's a problem. If it doesn't get that far, then that's another problem altogether... Regards, Chris

Re: [GENERAL] postgresql and javascript

[EMAIL PROTECTED] wrote: Does anyone know how to connect javascript to a postgresql database You can't connect javascript to any sort of database. You need something like php, python etc - it can connect to your database and generate javascript. Regards, Chris Smith Suite 30, 45-51 Huntl

[GENERAL] rewrite count distinct query

Hi all, 'Scuse the long post :) I'm trying to include all relevant info.. I'm trying to work out a better way to approach a query, any tips are greatly appreciated. The relevant tables: db=# \d tp_conversions Table "public.tp_conversions" Column | Type |

Re: [GENERAL] Interpreting query plan

groupid = 1268) OR (groupid = 1858) OR (groupid = 1859) OR (groupid = 2804)) Total runtime: 144.690 ms (11 rows) -- www.designacourse.com The Easiest Way to Train Anyone... Anywhere. Chris Smith - Lead Software Developer/Technical Trainer MindIQ Corporation ---(end of broad

[GENERAL] Interpreting query plan

NITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noactio n_del"('adminvisit_fk1', 'adminvisit', 'useraccount', 'UNSPECIFIED', 'userid', ' userid') "RI_ConstraintTrigger_255941" AFTER UPDATE ON useraccoun

[GENERAL] Wire protocol v3 details

Hi, I'm attempting to port some JDBC driver modifications to 7.4 so I can migrate an application. Where can I find an overview of the wire protocol v3? -- www.designacourse.com The Easiest Way to Train Anyone... Anywhere. Chris Smith - Lead Software Developer/Technical Trainer M

Re: [GENERAL] Very long time to commit or close connections

Oops, meant to copy the list on this... - Original Message - From: "Chris Smith" <[EMAIL PROTECTED]> To: "Tom Lane" <[EMAIL PROTECTED]> Sent: Monday, January 19, 2004 8:01 AM Subject: Re: [GENERAL] Very long time to commit or close connections &g

Re: [GENERAL] Very long time to commit or close connections

ght, but the app and database are on the same box, and communicating via TCP/IP on the localhost address. I'm not sure it's even possible to set up a firewall there, and I'm certain it hasn't been done. Thanks, -- www.designacourse.com The Easiest Way to Train Anyone... Anywhere

[GENERAL] Re: Database Recovery Help...

ike to recover... > > Is there any way wherein I could recover or reconstruct the data? -- Chris Smith http://www.squiz.net ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL] Re: Report Writer for PostgreSQL

gt; > > Patrick Lanphier wrote: > > > Sorry to grab your email address and ask you this. But I have been > > > looking for an inexpensive report writer that is feature rich. What > > > are your thoughts? > > > > > > Patrick Lanphier > > > The Artemis Group > > > http://www.artemisgroup.com -- Chris Smith http://www.squiz.net ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

[GENERAL] pg_ctl restart?

ameter & a correct error message appears pgsql@elrond:~/bin$ ./pg_ctl restart -s -m fast pg_ctl: no database directory or environment variable $PGDATA is specified Try 'pg_ctl --help' for more information. pgsql@elrond:~/bin$ The other switches for pg_ctl work (start & stop), just