postmaster
>
> actually i want to simulate, the scenario is which the user will do
> 'hard shut down / Power off'
> while system is in working state..
>
> and i want to ensure that postmaster is able to recover from this kind of
> errors when
> the system is is broug
;
> Necesito saber de favor, si existe alguna versionde PostgreSQL para Solaris
> 10.
>
>
> I need to know if exists some PostgreSQL version for Solaris 10.
>
>
> Gracias
>
> Saludos
--
Jonel Rienton
mailto:[EMAIL PROTECTED]
powered by: google
--
uch as the
> > suggestion in your next-to-last paragraph?
>
> My suggestion would be to familiarize yourself with database security.
> If using postgres, this means reading over the administration
> chapters very carefully, as well as grant/revoke usage, etc.
>
> Me
e
> diligence in protecting your clients' data.
>
> Cheers,
>
> Ted
>
>
>
> ---(end of broadcast)---
> TIP 1: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to [EMAIL PROTECTED] so that your
>message can get through to the mailing list cleanly
>
--
Jonel Rienton
mailto:[EMAIL PROTECTED]
powered by: google
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Usually bus error is cause by bad memory, haven't seen this kind of error in
a long time.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Doug Hall
Sent: Monday, February 20, 2006 1:44 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Bus error on ma
EMS' Postgresql Manager Lite is also pretty intuitive.
http://www.sqlmanager.net/products/postgresql/manager/download
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob Pawley
Sent: Friday, February 10, 2006 1:49 PM
To: Tony Caduto
Cc: Postgresql
Subje
This might be trivial, but, shouldn't you su to the user(postgres or
whatever you used) that's supposed to run the postmaster?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Shahid Butt
Sent: Monday, February 06, 2006 9:34 AM
To: pgsql-general@postgresql
Initial setup, I used the packages at http://www.entropy.ch and from that
point on, I build from source for the upgrades.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andrus
Sent: Tuesday, January 31, 2006 9:59 AM
To: pgsql-general@postgresql.org
Subje
e old location during the installation right in the initial
setup when it ask you what would like to install, where the PgAdmin, pl/java
section shows. Just highlight the Data Directory and click on browse, then
point to the location of your cluster.
Regards,
Jonel Rienton
--
I know not english well,
rowse, point to your new location of data directory (the
directory where you moved the data)
3. make sure you enable the run as service
4. don't initialize cluster db, uncheck it.
5. continue with installation.
6. you should be able to start the service from the services msc.
Regards,
Jonel Rie
esql pg_ctl -D D:\PgData81 start
It actually starts. Is there a way to fix the service way of starting the
database? I even tried running the same command in the service from the
command line and I'm getting the windows dialog box saying an internal error
occurred in pg_ctl.exe.
Regards,
Jon
er:postgresql pg_ctl -D D:\PgData81 start
It actually starts. Is there a way to fix the service way of starting the
database? I even tried running the same command in the service from the
command line and I'm getting the windows dialog box saying an internal error
occurred in pg_ctl.exe.
Regards,
Resending sample query, darn where clause didn't wrap
select a.*,b.* from a
left outer join b on a.id = b.a_id
where b.id is null;
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Wes
Sent: Wednesday, January 11, 2006 11:51 PM
To: Postgresql-General
Subj
I would use an outer join and check only those null-value records in the
right table with id's referencing table A
Sample query:
select a.*,b.* from a
left outer join b on a.id = b.a_id -- assuming a_id is my referencing
column to a
where b.id is null;
This will yield all columns in table a wh
What does your code look like? And have you tried using Npgsql instead of
the ODBC driver?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Saturday, January 07, 2006 4:39 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] The c
Thank you gentlemen, this will keep me busy for a while.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of James Cradock
Sent: Friday, December 30, 2005 1:05 PM
To: Jonel Rienton
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Data types
Try
Hi guys,
Does Postgres store all the possible column datatypes somewhere in its
system tables? Like int8, int4, character varying, etc. I'm trying to write
another GUI client that can list all the database objects in Postgres.
Thanks.
Regards,
Jonel
--
I know not english well, but I know 9 co
Please see below
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ted Byers
Sent: Wednesday, December 28, 2005 7:29 PM
To: Frank L. Parks; pgsql-general@postgresql.org
Subject: Re: [Bulk] Re: [GENERAL] Final stored procedure question, for now
anyway
-
the same. The function gets stored
somewhere, but it is not displayed anywhere by pgAdmin
Any suggestions?
- Original Message -----
From:
Jonel
Rienton
To: 'Ted Byers' ; pgsql-general@postgresql.org
Sent: Wednesday, December 28, 2005 4:16
PM
Subject: R
yup, just use lowercase all the
time
From: Ted Byers [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 28, 2005 1:45 PMTo: Jonel
Rienton; pgsql-general@postgresql.orgSubject: Re: [GENERAL] Final
stored procedure question, for now anyway
Did you find a fix for it?
- Original
I have a question about this, shouldn't it be the query should look like
SELECT *
FROM ipdb2
WHERE 3229285376 BETWEEN ipfrom AND ipto
Note the query doesn't quote the filter, since the ipfrom and ipto are both
integer types?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PR
it's because of the mixed-case you're using in the function
name, i've had this issue last week myself and it seems to be the
culprit
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ted
ByersSent: Wednesday, December 28, 2005 11:13 AMTo:
pgsql-general@postgresql.orgSubject:
you know what does work, if you issue the pg_ctl stop with /usr/local/
pgsql/data2 as the argument for -D
pg_ctl -D /usr/local/pgsql/data2 stop
odd tho.
On May 6, 2005, at 3:36 PM, Joshua D. Drake wrote:
Jonel Rienton wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
your data directory
I just tried the same setup as yours, and it worked fine, i was able
to start and stop the instance.
could it be that the process didn't start at all when you started it?
regards,
-
Jonel Rienton
http://homepage.mac.com/jrienton
Software Developer, *nix Advocate
On May 6, 2005, at 3:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
your data directory points to /usr/local/pgsql/data2 and you've
started it with -D /usr/local/pgsql/etc
might be something to look at
regards,
- -
Jonel Rienton
http://homepage.mac.com/jrienton
Software Developer, *nix Advocate
On
I just like to share that Postgres build and installed fine on my new
Mac OS X Tiger using gcc-4.0
regards,
Jonel
---(end of broadcast)---
TIP 8: explain analyze is your friend
Hi Craig,
Out of curiosity, beside portability, why haven't you use Npgsql?
regards,
-
Jonel Rienton
http://blogs.road14.com
Software Developer, *nix Advocate
On Feb 23, 2005, at 1:48 PM, Craig Bryden wrote:
Hi Shachar
Unfortunately due to a Non disclose agreement that I have on the
pr
any sample code?
regards,
-
Jonel Rienton
http://blogs.road14.com
Software Developer, *nix Advocate
On Feb 21, 2005, at 2:05 PM, Craig Bryden wrote:
Hi
I am trying to read a data set in ADO. If I exclude a timestamp field
that I
have in the return type, all works wonderfully. The moment I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I don't use PostgreSQL in Windows, I was just merely verifying that
this guy isn't the only one having this kind of problem, and yes this
is a Mac. I run my PostgreSQL db in Solaris, Linux and Mac OS X :-)
- -----
Jonel Rienton
http://bl
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
just to let you know, i got the same error message when i tried it on
my win2k inistall emulated by Virtual PC 7.
- -
Jonel Rienton
http://blogs.road14.com
Software Developer, *nix Advocate
On Feb 19, 2005, at 1:14 PM, S.D. wrote:
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
seems like it still exists in 10.3.8 which was just released today
- -
Jonel Rienton
http://blogs.road14.com
Software Developer, *nix Advocate
On Feb 9, 2005, at 3:40 PM, Tom Lane wrote:
> Joe Lester <[EMAIL PROTECTED]> writes:
>>
so if you need help just let
me know.
regards,
- -----
Jonel Rienton
http://blogs.road14.com
Software Developer, *nix Advocate
On Feb 9, 2005, at 12:35 AM, John DeSoi wrote:
>
> On Feb 9, 2005, at 10:39 AM, renato.barrios wrote:
>
>> Please tell me if Postgresql runns in an iMac
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Surabhi, search the archives, this has been discussed quite a few
times in the pass.
regards,
- -
Jonel Rienton
http://blogs.road14.com
Software Developer, *nix Advocate
On Feb 8, 2005, at 11:44 AM, Surabhi Ahuja wrote:
> i have a table
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
This can be easily done with pl/pgsql, visit the documentation at
http://www.postgresql.org/docs/7.3/interactive/programmer-pl.html
OT: seems like this is a questionnaire/survey application, yes?
- -
Jonel Rienton
http://blogs.road14.com
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
This can be easily done with pl/pgsql, visit the documentation at
http://www.postgresql.org/docs/7.3/interactive/programmer-pl.html
OT: seems like this is a questionnaire/survey application, yes?
- -
Jonel Rienton
http://blogs.road14.com
if it is
> idle)?
>
> Another possibility that I can think of is per ip address connection
> limits. How hard would that be?
>
> Paul Tillotson
>
> ---(end of broadcast)-------
> TIP 2: you can get off all lists at once wit
its
> late...)
>
> Philippe
>
> ---(end of broadcast)-------
> TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
--
Jonel Rienton
http://blogs.road14.com
Software Developer, *nix Advocate
nto xcount
from pix where image_type = 'X';
select gcount || ', ' || xcount
into result;
return result;
end;
$$ LANGUAGE plpgsql;
hope this helps, it's simple and always, there's another (better)
solution
it's my first stab at plpgsql so p
you're right it's late, i better to get to bed myself, i forgot to
throw in the parameter for the user_id in there, i'm sure you can
figure that one out.
regards,
-
Jonel Rienton
http://blogs.road14.com
Software Developer, *nix Advocate
On Feb 3, 2005, at 1:32 AM, Uwe C.
[EMAIL PROTECTED]
> LlamaLand http://netllama.linux-sxs.org
>
> ---(end of broadcast)---
> TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
--
Jonel Rienton
http://blogs.road14.com
Softwar
> you if the values are wrong.
>
> Wes
>
> ---(end of broadcast)-------
> TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
--
Jonel Rienton
http://jonel.road14.com
---(end of broadcast)--
41 matches
Mail list logo
