pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedquestion
32+ messages / 25 participants
[nested] [flat]
* question
@ 2000-11-09 08:23 Mohammed A. <mjalha@essex.ac.uk>
0 siblings, 1 reply; 32+ messages in thread
From: Mohammed A. @ 2000-11-09 08:23 UTC (permalink / raw)
To: pgsql-admin
Dear sir,
I'm PhD student in Essex university in Colchester Uk.
I've tries to install Postgresql version 7.0
but I got an error while the installation (it's not my question).
My question is what is the TCL
Thank you for your time.
Kind Regards
^ permalink raw reply [nested|flat] 32+ messages in thread
* Re: question
@ 2000-11-09 11:56 Oliver Elphick <olly@lfix.co.uk>
parent: Mohammed A. <mjalha@essex.ac.uk>
0 siblings, 0 replies; 32+ messages in thread
From: Oliver Elphick @ 2000-11-09 11:56 UTC (permalink / raw)
To: Mohammed A. <mjalha@essex.ac.uk>; +Cc: pgsql-admin
"Mohammed A." wrote:
>I've tries to install Postgresql version 7.0
>but I got an error while the installation (it's not my question).
>My question is what is the TCL
Tk/Tcl is a language for which PostreSQL offers an interface. Certain
parts of PostgreSQL will not build if Tk/Tcl support is not present.
This should not stop the rest from building.
What is the error?
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"O death, where is thy sting? O grave, where is
thy victory?" 1 Corinthians 15:55
^ permalink raw reply [nested|flat] 32+ messages in thread
* Question ..
@ 2002-03-15 20:57 Hernan Nuñez <hnunez@vianetworks.com.ar>
0 siblings, 0 replies; 32+ messages in thread
From: Hernan Nuñez @ 2002-03-15 20:57 UTC (permalink / raw)
To: pgsql-admin
How i could know the database name from directory name
(/usr/local/pgsql/data/base/????)
Hernan Nuñez | VIA NET.WORKS Argentina
NICAR-P37184 |
hnunez@vianetworks.com.ar | local touch global reach
System Administrator |
Tecnología y Operaciones | http://www.vianetworks.com.ar
+ ICQ: 36528552 | DDI +54 11 43233333
^ permalink raw reply [nested|flat] 32+ messages in thread
* Question
@ 2003-09-02 19:24 Manuel Haroldo <mhcr@yahoo.com>
0 siblings, 1 reply; 32+ messages in thread
From: Manuel Haroldo @ 2003-09-02 19:24 UTC (permalink / raw)
To: pgsql-admin
I want to know if there are companies than bring
support of PostgreSQL.
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
^ permalink raw reply [nested|flat] 32+ messages in thread
* Re: Question
@ 2003-09-02 21:41 Peter Eisentraut <peter_e@gmx.net>
parent: Manuel Haroldo <mhcr@yahoo.com>
0 siblings, 0 replies; 32+ messages in thread
From: Peter Eisentraut @ 2003-09-02 21:41 UTC (permalink / raw)
To: Manuel Haroldo <mhcr@yahoo.com>; +Cc: pgsql-admin
Manuel Haroldo writes:
> I want to know if there are companies than bring
> support of PostgreSQL.
Searching for "PostgreSQL" and "support" on Google will show you hundreds
of them.
--
Peter Eisentraut peter_e@gmx.net
^ permalink raw reply [nested|flat] 32+ messages in thread
* question
@ 2003-12-07 20:42 rose <rghubari@yahoo.com>
0 siblings, 0 replies; 32+ messages in thread
From: rose @ 2003-12-07 20:42 UTC (permalink / raw)
To: pgsql-admin
i have an assembley project and i need someone to help
in solving the problem plaese
__________________________________
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/
^ permalink raw reply [nested|flat] 32+ messages in thread
* Question
@ 2003-12-08 13:04 Jerrianna Fox <jfox@infosciences.com>
0 siblings, 1 reply; 32+ messages in thread
From: Jerrianna Fox @ 2003-12-08 13:04 UTC (permalink / raw)
To: pgsql-admin
I am a newbie and need to find out if PostgreSQL is a good replacement for Oracle. I need to find out the best way to import data from Oracle to PostgreSQL. I also need to find out what the DBA capabilities are of PostgreSQL compared to that of Oracle. This is something that we are looking into immediately for production use.
Thanks
Jerrianna Fox
^ permalink raw reply [nested|flat] 32+ messages in thread
* Re: Question
@ 2003-12-09 18:46 Glenn Wiorek <gwiorek@jmlafferty.com>
parent: Jerrianna Fox <jfox@infosciences.com>
0 siblings, 0 replies; 32+ messages in thread
From: Glenn Wiorek @ 2003-12-09 18:46 UTC (permalink / raw)
To: Jerrianna Fox <jfox@infosciences.com>; pgsql-admin; +Cc: Randy Harris <randy@SpamFree.com>; sachdev@dacafe.com
Here are few links to get you started.
Intro info about PostgreSQL
http://www.postgresql.org/docs/aw_pgsql_book/index.html
Conversion to Oracle:
http://techdocs.postgresql.org/redir.php?link=http://www.samse.fr/GPL/ora2pg/ora2pg.html
http://techdocs.postgresql.org/redir.php?link=http://www.brasileiro.net/postgres/porting
There are also some commerical tools out.
----- Original Message -----
From: Jerrianna Fox
To: pgsql-admin@postgresql.org
Sent: Monday, December 08, 2003 7:04 AM
Subject: [ADMIN] Question
I am a newbie and need to find out if PostgreSQL is a good replacement for Oracle. I need to find out the best way to import data from Oracle to PostgreSQL. I also need to find out what the DBA capabilities are of PostgreSQL compared to that of Oracle. This is something that we are looking into immediately for production use.
Thanks
Jerrianna Fox
^ permalink raw reply [nested|flat] 32+ messages in thread
* question
@ 2004-08-20 17:25 Dariusz Sobierajewicz <dsobie@yahoo.com>
0 siblings, 1 reply; 32+ messages in thread
From: Dariusz Sobierajewicz @ 2004-08-20 17:25 UTC (permalink / raw)
To: pgsql-admin
Hi,
I have following problem. I have postgresql dump database. I don't have posgresql server intalled. Is there a way to restore that data?
thanks.
---------------------------------
Do you Yahoo!?
Win 1 of 4,000 free domain names from Yahoo! Enter now.
^ permalink raw reply [nested|flat] 32+ messages in thread
* Re: question
@ 2004-08-20 20:57 Bruno Wolff III <bruno@wolff.to>
parent: Dariusz Sobierajewicz <dsobie@yahoo.com>
0 siblings, 1 reply; 32+ messages in thread
From: Bruno Wolff III @ 2004-08-20 20:57 UTC (permalink / raw)
To: Dariusz Sobierajewicz <dsobie@yahoo.com>; +Cc: pgsql-admin
On Fri, Aug 20, 2004 at 10:25:06 -0700,
Dariusz Sobierajewicz <dsobie@yahoo.com> wrote:
> Hi,
> I have following problem. I have postgresql dump database. I don't have posgresql server intalled. Is there a way to restore that data?
Install a postgres server and then use pg_restore or psql to restore.
(Which you use depends on what options you used for pg_dump(all).)
^ permalink raw reply [nested|flat] 32+ messages in thread
* Re: question
@ 2004-08-21 14:38 Bruno Wolff III <bruno@wolff.to>
parent: Bruno Wolff III <bruno@wolff.to>
0 siblings, 0 replies; 32+ messages in thread
From: Bruno Wolff III @ 2004-08-21 14:38 UTC (permalink / raw)
To: Dariusz Sobierajewicz <dsobie@yahoo.com>; +Cc: pgsql-admin
I am copying this back to the list.
On Fri, Aug 20, 2004 at 14:07:03 -0700,
Dariusz Sobierajewicz <dsobie@yahoo.com> wrote:
> Ok, thanks. I'm working on windows machine. can you tell me what is the easiest way to set up PostgreSQL on win xp?
> thanks.
Trying out the 8.0.0 beta. This isn't ready for production, but would be
OK for playing around with postgres.
>
> Bruno Wolff III <bruno@wolff.to> wrote:
> On Fri, Aug 20, 2004 at 10:25:06 -0700,
> Dariusz Sobierajewicz wrote:
> > Hi,
> > I have following problem. I have postgresql dump database. I don't have posgresql server intalled. Is there a way to restore that data?
>
> Install a postgres server and then use pg_restore or psql to restore.
> (Which you use depends on what options you used for pg_dump(all).)
>
>
> ---------------------------------
> Do you Yahoo!?
> Win 1 of 4,000 free domain names from Yahoo! Enter now.
^ permalink raw reply [nested|flat] 32+ messages in thread
* Question
@ 2005-02-23 17:11 FBaron@co.belcorp.biz
0 siblings, 0 replies; 32+ messages in thread
From: FBaron@co.belcorp.biz @ 2005-02-23 17:11 UTC (permalink / raw)
To: pgsql-admin
Hi, I have a database with 100 GB size, I never have done a vacuumdb to
it, analizyng, there is a table witn almost 25 GB, I have to run a Vaccum
to clean it.. This is a longer operation.
But somebody said me that if I make a backup(pg_dump), drop the database,
create db, an then restore again, tha database is cleaned(recover disk
space) and reindexed, is that true?
If is true, how long is this?
Thnaks for your help.
Fabio.
Aviso de confidencialidad:
Este mensaje de correo electrónico contiene información estrictamente
confidencial no susceptible de ser distribuida. Si usted no es el
destinatario de este mensaje, por favor no publicarlo, copiarlo o tomar
cualquier otro tipo de accion sobre esta transmision. Si recibio este
mensaje por error, por favor notifiquenoslo y eliminelo lo antes posible.
Warning of confidentiality:
This message of electronic mail contains strictly confidential information
nonsusceptible to be distributed. If you are not the adressee of this
message, please do not publish it, copy it or take any other kind of action
on this transmission. If you got this message by mistake, please notify it
to us and eliminate it as soon as possible.
^ permalink raw reply [nested|flat] 32+ messages in thread
* Re: Question
@ 2005-02-23 18:08 John Jensen <jrj@ft.fo>
0 siblings, 0 replies; 32+ messages in thread
From: John Jensen @ 2005-02-23 18:08 UTC (permalink / raw)
To: FBaron@co.belcorp.biz; pgsql-admin
First its bad style to use a generic subject like "Question". Use
something related to the specific problem. "Help" is an other poor
choice.
Second you need to put in a lot more information about your setup. As an
absolute minimum provide postgresql release and operating system.
Third it sounds like you've got some reading to do. The manual and this
book would be a good place to start:
http://www.faqs.org/docs/ppbook/book1.htm
While you read you should run the command "vacuum analyze", this is
going to take a REALLY LONG time. 12 to 24 hours wouldn't surprise me.
But at least the base will still be online although with degraded
performance.
When you've got a better handle on thing I suggest you do a pg_dumpall,
drop the base and perform a restore.
You are likely to run on a more or less outdated version so while doing
the dump and restore you should consider upgrading to the latest
version. The INSTALL document in the source distro tells how to perform
dump/restore when upgrading.
I'm able to do a dump of a 50Gig base in one hour but the restore time
depends a lot on what sort of index'es you have. Don't hold your breath
waiting. All this depends a lot on what sort of hardware you have.
Cheers,
John
>>> <FBaron@co.belcorp.biz> 23-02-05 17:11 >>>
Hi, I have a database with 100 GB size, I never have done a vacuumdb
to
it, analizyng, there is a table witn almost 25 GB, I have to run a
Vaccum
to clean it.. This is a longer operation.
But somebody said me that if I make a backup(pg_dump), drop the
database,
create db, an then restore again, tha database is cleaned(recover disk
space) and reindexed, is that true?
If is true, how long is this?
Thnaks for your help.
Fabio.
^ permalink raw reply [nested|flat] 32+ messages in thread
* Question
@ 2006-01-19 15:59 Chris Van Reenen <chris.vanreenen@charterhouseuk.com>
0 siblings, 1 reply; 32+ messages in thread
From: Chris Van Reenen @ 2006-01-19 15:59 UTC (permalink / raw)
To: pgsql-admin
Hi.
I want to find out if postgresql can be used in place of MS SQL?
But I want to find out if I can get SharePoint working on postgre with
out any limitations.
I was given the task to see if there is any other DB that we can run
share point on.
I don't want to try for months and then find out that it can't be done.
So if you guys can just give me a answer on this, it will be great.
Thanks for your help and keep the good work going..
Regards
Chris
^ permalink raw reply [nested|flat] 32+ messages in thread
* Re: Question
@ 2006-01-19 20:30 Scott Marlowe <smarlowe@g2switchworks.com>
parent: Chris Van Reenen <chris.vanreenen@charterhouseuk.com>
0 siblings, 0 replies; 32+ messages in thread
From: Scott Marlowe @ 2006-01-19 20:30 UTC (permalink / raw)
To: Chris Van Reenen <chris.vanreenen@charterhouseuk.com>; +Cc: pgsql-admin
On Thu, 2006-01-19 at 09:59, Chris Van Reenen wrote:
> Hi.
>
>
>
> I want to find out if postgresql can be used in place of MS SQL?
>
> But I want to find out if I can get SharePoint working on postgre with
> out any limitations.
>
> I was given the task to see if there is any other DB that we can run
> share point on.
>
> I don’t want to try for months and then find out that it can’t be
> done.
>
> So if you guys can just give me a answer on this, it will be great.
>
> Thanks for your help and keep the good work going..
Microsoft makes and sells both of those products, so it's unlikely that
they'll make the database easily replaceable, as forcing you to use MS
SQL server ensures they get maximum income from SharePoint.
I'm not saying it won't work. Just that even if you do get it to work,
it's likely to have some problems here and there. PostgreSQL is NOT a
direct replacement for MS SQL server, and it's not uncommon for someone
to write code that uses some artifact of MS SQL that no other database
supports.
If your boss wants to run SharePoint, I'd suggest running MS SQL
underneath it.
Of course, I'd recommend not running either, having had experience with
both in the past. But that's just me.
^ permalink raw reply [nested|flat] 32+ messages in thread
* Fwd: Question
@ 2006-03-07 22:09 German Raul Hoyos Parravicino <rhoyos@gmail.com>
0 siblings, 1 reply; 32+ messages in thread
From: German Raul Hoyos Parravicino @ 2006-03-07 22:09 UTC (permalink / raw)
To: pgsql-admin
---------- Forwarded message ----------
From: German Raul Hoyos Parravicino <rhoyos@gmail.com>
Date: Mar 7, 2006 3:36 PM
Subject: Question
To: pgsql-general-owner@postgresql.org
Dear Administrator:
I have a problem developing a ECPG program. I am making a programa using
FETCH, when the second row is sent the following message appear:
==>sqlcode [-213] msg[NULL value without indicator in line 1192.]
My select is:
EXEC SQL FETCH cursor_onlyweb
INTO
:t_token,
:t_institucion,
:t_usuario,
:t_horasistema,
:t_pan,
:t_prcode,
:t_amount,
:t_acqinst,
:t_source,
:t_datosreq;
Is it possible to use something similar to "isnull" in Oracle?
Thanks
Raul
^ permalink raw reply [nested|flat] 32+ messages in thread
* Re: Fwd: Question
@ 2006-03-07 23:44 Michael Fuhr <mike@fuhr.org>
parent: German Raul Hoyos Parravicino <rhoyos@gmail.com>
0 siblings, 0 replies; 32+ messages in thread
From: Michael Fuhr @ 2006-03-07 23:44 UTC (permalink / raw)
To: German Raul Hoyos Parravicino <rhoyos@gmail.com>; +Cc: pgsql-admin
On Tue, Mar 07, 2006 at 05:09:56PM -0500, German Raul Hoyos Parravicino wrote:
> I have a problem developing a ECPG program. I am making a programa using
> FETCH, when the second row is sent the following message appear:
>
> ==>sqlcode [-213] msg[NULL value without indicator in line 1192.]
[...]
> Is it possible to use something similar to "isnull" in Oracle?
Are you looking for the SQL-standard COALESCE?
test=> SELECT COALESCE('foo', 'bar');
coalesce
----------
foo
(1 row)
test=> SELECT COALESCE(NULL, 'bar');
coalesce
----------
bar
(1 row)
See also the ECPG documentation on using indicators to detect NULL.
--
Michael Fuhr
^ permalink raw reply [nested|flat] 32+ messages in thread
* Re: Fwd: Question
@ 2006-03-08 14:07 Goulet, Dick <DGoulet@vicr.com>
0 siblings, 1 reply; 32+ messages in thread
From: Goulet, Dick @ 2006-03-08 14:07 UTC (permalink / raw)
To: Michael Fuhr <mike@fuhr.org>; German Raul Hoyos Parravicino <rhoyos@gmail.com>; +Cc: pgsql-admin
The syntax in Oracle is "is null" or "is not null" as in:
select count(*) from module_master where gatekeeper_status is null;
And yes that does work in PostGreSql. Now if your talking about the
Oracle function NVL, for Null Value, no that does not work and I don't
see a similar function in PostGreSql. You could create one easily
enough.
Dick Goulet
Senior Oracle DBA
Oracle Certified DBA
-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Michael Fuhr
Sent: Tuesday, March 07, 2006 6:45 PM
To: German Raul Hoyos Parravicino
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Fwd: Question
On Tue, Mar 07, 2006 at 05:09:56PM -0500, German Raul Hoyos Parravicino
wrote:
> I have a problem developing a ECPG program. I am making a programa
using
> FETCH, when the second row is sent the following message appear:
>
> ==>sqlcode [-213] msg[NULL value without indicator in line 1192.]
[...]
> Is it possible to use something similar to "isnull" in Oracle?
Are you looking for the SQL-standard COALESCE?
test=> SELECT COALESCE('foo', 'bar');
coalesce
----------
foo
(1 row)
test=> SELECT COALESCE(NULL, 'bar');
coalesce
----------
bar
(1 row)
See also the ECPG documentation on using indicators to detect NULL.
--
Michael Fuhr
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
^ permalink raw reply [nested|flat] 32+ messages in thread
* Re: Fwd: Question
@ 2006-03-08 17:24 Michael Fuhr <mike@fuhr.org>
parent: Goulet, Dick <DGoulet@vicr.com>
0 siblings, 0 replies; 32+ messages in thread
From: Michael Fuhr @ 2006-03-08 17:24 UTC (permalink / raw)
To: Goulet, Dick <DGoulet@vicr.com>; +Cc: German Raul Hoyos Parravicino <rhoyos@gmail.com>; pgsql-admin
On Wed, Mar 08, 2006 at 09:07:00AM -0500, Goulet, Dick wrote:
> The syntax in Oracle is "is null" or "is not null" as in:
>
> select count(*) from module_master where gatekeeper_status is null;
That works if you want to exclude those rows altogether.
> And yes that does work in PostGreSql. Now if your talking about the
> Oracle function NVL, for Null Value, no that does not work and I don't
> see a similar function in PostGreSql. You could create one easily
> enough.
What does NVL do? From the examples I've seen it looks like COALESCE.
Oracle themselves recommends COALESCE:
http://www.oracle.com/technology/oramag/oracle/05-jul/o45sql.html
"Oracle Database supports several functions that are similar to
COALESCE. These include NVL2, NULLIF, and NVL. (Take time to read
about these functions in the Oracle SQL Reference manual.) We
recommend COALESCE over NVL, because COALESCE can handle more than
just two arguments and it's part of the SQL standard. When COALESCE
isn't enough, you may be able to find refuge in CASE expressions,
which are also covered in Oracle SQL Reference."
PostgreSQL supports CASE as well.
--
Michael Fuhr
^ permalink raw reply [nested|flat] 32+ messages in thread
* Question
@ 2006-11-07 20:17 Mark Steben <msteben@autorevenue.com>
0 siblings, 2 replies; 32+ messages in thread
From: Mark Steben @ 2006-11-07 20:17 UTC (permalink / raw)
To: pgsql-admin
I am very new to PostgreSQL. Is it appropriate to pose questions to this
email list?
I am trying to come up with a query that will list the names of the database
indexes that
Have been chosen as clustering indexes. I know I can get the INDEXRELID
from PG.INDEX
But have yet to figure out how to get the index name from there. Any help
would be appreciated.
And, if this is not an appropriate forum to ask questions please tell me.
Thank you,
Mark Steben
AutoRevenue
^ permalink raw reply [nested|flat] 32+ messages in thread
* Re: Question
@ 2006-11-07 20:27 Richard Broersma Jr <rabroersma@yahoo.com>
parent: Mark Steben <msteben@autorevenue.com>
1 sibling, 1 reply; 32+ messages in thread
From: Richard Broersma Jr @ 2006-11-07 20:27 UTC (permalink / raw)
To: Mark Steben <msteben@autorevenue.com>; pgsql-admin
> I am very new to PostgreSQL. Is it appropriate to pose questions to this
> email list?
> I am trying to come up with a query that will list the names of the database
> indexes that
>
> Have been chosen as clustering indexes. I know I can get the INDEXRELID
> from PG.INDEX
>
> But have yet to figure out how to get the index name from there. Any help
> would be appreciated.
>
> And, if this is not an appropriate forum to ask questions please tell me.
I assume this is an appropiate list for this question. I am sure that pg_general would have
worked also. With-out knowing the postgresql pg_* schema very well I can be difficult to
determine queries that will give your this sort of information. In my case I like to cheat.
1) I turn on statement logging.
2) I issue a commands like \d from psql interface
3) Then, I look at the pg_logs to see what sql statement was actually created from "\d"
In your case I would first determine which psql function will give you the information you want
and this use it to give you the query you need.
I hope this helps.
Regards,
Richard Broersma Jr.
^ permalink raw reply [nested|flat] 32+ messages in thread
* Re: Question
@ 2006-11-07 20:29 Jeff Frost <jeff@frostconsultingllc.com>
parent: Mark Steben <msteben@autorevenue.com>
1 sibling, 1 reply; 32+ messages in thread
From: Jeff Frost @ 2006-11-07 20:29 UTC (permalink / raw)
To: Mark Steben <msteben@autorevenue.com>; +Cc: pgsql-admin
On Tue, 7 Nov 2006, Mark Steben wrote:
> I am very new to PostgreSQL. Is it appropriate to pose questions to this
> email list?
It might be better on pgsql-sql, but I'm not sure.
> I am trying to come up with a query that will list the names of the database
> indexes that
>
> Have been chosen as clustering indexes. I know I can get the INDEXRELID
> from PG.INDEX
>
> But have yet to figure out how to get the index name from there. Any help
> would be appreciated.
>
> And, if this is not an appropriate forum to ask questions please tell me.
You want to join on pg_class.oid. You can see the info on pg_index here in
the docs: http://www.postgresql.org/docs/8.1/static/catalog-pg-index.html
select i.indexrelid,c.relname from pg_index i, pg_class c where i.indexrelid =
c.oid;
will likely give you what you're after.
--
Jeff Frost, Owner <jeff@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
^ permalink raw reply [nested|flat] 32+ messages in thread
* Re: Question
@ 2006-11-07 20:45 Scott Marlowe <smarlowe@g2switchworks.com>
parent: Richard Broersma Jr <rabroersma@yahoo.com>
0 siblings, 1 reply; 32+ messages in thread
From: Scott Marlowe @ 2006-11-07 20:45 UTC (permalink / raw)
To: Richard Broersma Jr <rabroersma@yahoo.com>; +Cc: Mark Steben <msteben@autorevenue.com>; pgsql-admin
On Tue, 2006-11-07 at 14:27, Richard Broersma Jr wrote:
> > I am very new to PostgreSQL. Is it appropriate to pose questions to this
> > email list?
> > I am trying to come up with a query that will list the names of the database
> > indexes that
> >
> > Have been chosen as clustering indexes. I know I can get the INDEXRELID
> > from PG.INDEX
> >
> > But have yet to figure out how to get the index name from there. Any help
> > would be appreciated.
> >
> > And, if this is not an appropriate forum to ask questions please tell me.
>
> I assume this is an appropiate list for this question. I am sure that pg_general would have
> worked also. With-out knowing the postgresql pg_* schema very well I can be difficult to
> determine queries that will give your this sort of information. In my case I like to cheat.
>
> 1) I turn on statement logging.
> 2) I issue a commands like \d from psql interface
> 3) Then, I look at the pg_logs to see what sql statement was actually created from "\d"
Easier way to cheat:
psql -E dbname
then all the \d commands and what not will spill their secrets right on
the screen. :)
^ permalink raw reply [nested|flat] 32+ messages in thread
* Re: Question
@ 2006-11-07 20:47 Richard Broersma Jr <rabroersma@yahoo.com>
parent: Scott Marlowe <smarlowe@g2switchworks.com>
0 siblings, 0 replies; 32+ messages in thread
From: Richard Broersma Jr @ 2006-11-07 20:47 UTC (permalink / raw)
To: Scott Marlowe <smarlowe@g2switchworks.com>; +Cc: Mark Steben <msteben@autorevenue.com>; pgsql-admin
---> Easier way to cheat:
>
> psql -E dbname
>
> then all the \d commands and what not will spill their secrets right on
> the screen. :)
Cool, thanks for the tip.
^ permalink raw reply [nested|flat] 32+ messages in thread
* Re: Question
@ 2006-11-07 20:50 Mark Steben <msteben@autorevenue.com>
parent: Jeff Frost <jeff@frostconsultingllc.com>
0 siblings, 1 reply; 32+ messages in thread
From: Mark Steben @ 2006-11-07 20:50 UTC (permalink / raw)
To: jeff@frostconsultingllc.com; +Cc: pgsql-admin
Thank you, Jeff. That worked like a champ. My initial problem
Had to do with not understanding the concept of OID datatypes.
My next learning task is to read up on OID.
Thanks again, Mark
-----Original Message-----
From: jeff@frostconsultingllc.com [mailto:jeff@frostconsultingllc.com]
Sent: Tuesday, November 07, 2006 3:29 PM
To: Mark Steben
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Question
On Tue, 7 Nov 2006, Mark Steben wrote:
> I am very new to PostgreSQL. Is it appropriate to pose questions to this
> email list?
It might be better on pgsql-sql, but I'm not sure.
> I am trying to come up with a query that will list the names of the
database
> indexes that
>
> Have been chosen as clustering indexes. I know I can get the INDEXRELID
> from PG.INDEX
>
> But have yet to figure out how to get the index name from there. Any help
> would be appreciated.
>
> And, if this is not an appropriate forum to ask questions please tell me.
You want to join on pg_class.oid. You can see the info on pg_index here in
the docs: http://www.postgresql.org/docs/8.1/static/catalog-pg-index.html
select i.indexrelid,c.relname from pg_index i, pg_class c where i.indexrelid
=
c.oid;
will likely give you what you're after.
--
Jeff Frost, Owner <jeff@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
^ permalink raw reply [nested|flat] 32+ messages in thread
* Re: Question
@ 2006-11-08 00:55 adey <adey11@gmail.com>
parent: Mark Steben <msteben@autorevenue.com>
0 siblings, 0 replies; 32+ messages in thread
From: adey @ 2006-11-08 00:55 UTC (permalink / raw)
To: Mark Steben <msteben@autorevenue.com>; +Cc: jeff@frostconsultingllc.com; pgsql-admin
I think the following query should list clustered indexes for you:-
select * from pg_index
where indisclustered = 't'
On 11/8/06, Mark Steben <msteben@autorevenue.com> wrote:
>
> Thank you, Jeff. That worked like a champ. My initial problem
> Had to do with not understanding the concept of OID datatypes.
> My next learning task is to read up on OID.
>
> Thanks again, Mark
>
> -----Original Message-----
> From: jeff@frostconsultingllc.com [mailto:jeff@frostconsultingllc.com]
> Sent: Tuesday, November 07, 2006 3:29 PM
> To: Mark Steben
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Question
>
> On Tue, 7 Nov 2006, Mark Steben wrote:
>
> > I am very new to PostgreSQL. Is it appropriate to pose questions to
> this
> > email list?
>
> It might be better on pgsql-sql, but I'm not sure.
>
> > I am trying to come up with a query that will list the names of the
> database
> > indexes that
> >
> > Have been chosen as clustering indexes. I know I can get the INDEXRELID
> > from PG.INDEX
> >
> > But have yet to figure out how to get the index name from there. Any
> help
> > would be appreciated.
> >
> > And, if this is not an appropriate forum to ask questions please tell
> me.
>
> You want to join on pg_class.oid. You can see the info on pg_index here
> in
> the docs: http://www.postgresql.org/docs/8.1/static/catalog-pg-index.html
>
> select i.indexrelid,c.relname from pg_index i, pg_class c where
> i.indexrelid
> =
> c.oid;
>
> will likely give you what you're after.
>
> --
> Jeff Frost, Owner <jeff@frostconsultingllc.com>
> Frost Consulting, LLC http://www.frostconsultingllc.com/
> Phone: 650-780-7908 FAX: 650-649-1954
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
^ permalink raw reply [nested|flat] 32+ messages in thread
* question
@ 2019-08-27 08:45 AL-Temimi, Muthana <muthana.al-temimi@tuhh.hamburg.de>
0 siblings, 0 replies; 32+ messages in thread
From: AL-Temimi, Muthana @ 2019-08-27 08:45 UTC (permalink / raw)
To: pgsql-admin
Dear all,
I have 2 different Master/Slave with two different databases (DB1 und DB2). My question is: Can I manage them both with one PGPool II? Can PGPool II recognize that the first request should go to the fist Master/Slave because the request talk with DB1 and the 2nd request, which are talk to DB2, should go the 2nd Master/Slave.
Regards
Muthana
^ permalink raw reply [nested|flat] 32+ messages in thread
* Question
@ 2021-04-05 15:12 CARLOS MULESOL <cochoa@mulesol.es>
0 siblings, 1 reply; 32+ messages in thread
From: CARLOS MULESOL @ 2021-04-05 15:12 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
I have a postgresql server and I want to connect remotely configuring
ssl and a certificate like in
https://www.postgresql.org/docs/13/ssl-tcp.html. But no matter how hard
I try, it doesn't work. Any practical example please?
Besst regards,
--
CARLOS OCHOA GÓMEZ
Técnico Mto Zona Norte
E-mail: cochoa@mulesol.es / carlos8agomez@gmail.com
Tfno: 679189284
AVISO
SOBRE CONFIDENCIALIDAD: Este mensaje se dirige exclusivamente a su
destinatario. Puede contener información confidencial sometida a secreto
profesional. Si no es usted el destinatario debe saber que la
información contenida en este mensaje es reservada y su utilización o
divulgación con cualquier fin está prohibida. Si ha recibido este
documento por error, le rogamos que nos lo comunique y proceda a su
destrucción.MULESOL, S.L. con CIF B86276292 responsable del
tratamiento informa, de conformidad con lo establecido en el REGLAMENTO
(UE) 2016/679, que su correo electrónico así como otros datos de
carácter personal son tratados con la finalidad de mantener un canal de
comunicación electrónica con usted y poder atender cualquier
información, duda, petición o consulta que precise por esta misma vía. Podrá
ejercer sus derechos de acceso, rectificación, limitación de
tratamiento, supresión, portabilidad y oposición al tratamiento de sus
datos de carácter personal así como revocar los consentimientos que en
su caso haya prestado u obtener más información, dirigiendo su petición a
ADMINISTRACION@MULESOL.ES con domicilio en C/ BAHIA DE POLLENSA No5, BARAJAS (MADRID), 28042. Si
usted no nos ha facilitado directamente sus datos, le informamos que
éstos han sido extraídos de fuentes de acceso público. Puede consultar
información adicional en:https://www.accesousuario.com/protecciondedatos/rgpd/informacion_consentimientoAPI.php?codEmpresa=42...
Attachments:
cochoa.vcf (text/x-vcard, 4B) download
null
* Re: Question
@ 2021-04-05 15:30 Ron <ronljohnsonjr@gmail.com>
parent: CARLOS MULESOL <cochoa@mulesol.es>
0 siblings, 1 reply; 32+ messages in thread
From: Ron @ 2021-04-05 15:30 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
On 4/5/21 10:12 AM, CARLOS MULESOL wrote:
> I have a postgresql server and I want to connect remotely configuring ssl
> and a certificate like in https://www.postgresql.org/docs/13/ssl-tcp.html.
> But no matter how hard I try, it doesn't work. Any practical example please?
What did you try, and what error messages did you receive?
--
Angular momentum makes the world go 'round.
^ permalink raw reply [nested|flat] 32+ messages in thread
* Re: Question
@ 2021-04-05 15:51 CARLOS MULESOL <cochoa@mulesol.es>
parent: Ron <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 32+ messages in thread
From: CARLOS MULESOL @ 2021-04-05 15:51 UTC (permalink / raw)
To: Ron <ronljohnsonjr@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
I get an error that I can't connect. No more
CARLOS OCHOA GÓMEZ Técnico Mto Zona Norte E-mail: cochoa@mulesol.es / carlos8agomez@gmail.com Tfno: 679189284
Obtener BlueMail para Android
En 5 abr. 2021 17:30, en 17:30, Ron <ronljohnsonjr@gmail.com> escribió:
>On 4/5/21 10:12 AM, CARLOS MULESOL wrote:
>> I have a postgresql server and I want to connect remotely configuring
>ssl
>> and a certificate like in
>https://www.postgresql.org/docs/13/ssl-tcp.html.
>> But no matter how hard I try, it doesn't work. Any practical example
>please?
>
>What did you try, and what error messages did you receive?
>
>--
>Angular momentum makes the world go 'round.
AVISO
SOBRE CONFIDENCIALIDAD: Este mensaje se dirige exclusivamente a su
destinatario. Puede contener información confidencial sometida a secreto
profesional. Si no es usted el destinatario debe saber que la
información contenida en este mensaje es reservada y su utilización o
divulgación con cualquier fin está prohibida. Si ha recibido este
documento por error, le rogamos que nos lo comunique y proceda a su
destrucción.MULESOL, S.L. con CIF B86276292 responsable del
tratamiento informa, de conformidad con lo establecido en el REGLAMENTO
(UE) 2016/679, que su correo electrónico así como otros datos de
carácter personal son tratados con la finalidad de mantener un canal de
comunicación electrónica con usted y poder atender cualquier
información, duda, petición o consulta que precise por esta misma vía. Podrá
ejercer sus derechos de acceso, rectificación, limitación de
tratamiento, supresión, portabilidad y oposición al tratamiento de sus
datos de carácter personal así como revocar los consentimientos que en
su caso haya prestado u obtener más información, dirigiendo su petición a
ADMINISTRACION@MULESOL.ES con domicilio en C/ BAHIA DE POLLENSA No5, BARAJAS (MADRID), 28042. Si
usted no nos ha facilitado directamente sus datos, le informamos que
éstos han sido extraídos de fuentes de acceso público. Puede consultar
información adicional en:https://www.accesousuario.com/protecciondedatos/rgpd/informacion_consentimientoAPI.php?codEmpresa=42...
^ permalink raw reply [nested|flat] 32+ messages in thread
* Re: Question
@ 2021-04-05 15:53 Ron <ronljohnsonjr@gmail.com>
parent: CARLOS MULESOL <cochoa@mulesol.es>
0 siblings, 1 reply; 32+ messages in thread
From: Ron @ 2021-04-05 15:53 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
What configurations did you try?
On 4/5/21 10:51 AM, CARLOS MULESOL wrote:
> I get an error that I can't connect. No more
>
> CARLOS OCHOA GÓMEZ Técnico Mto Zona Norte E-mail: cochoa@mulesol.es /
> carlos8agomez@gmail.com Tfno: 679189284
>
> Obtener BlueMail para Android <http://www.bluemail.me/r?b=16696;
> En 5 abr. 2021, en 17:30, Ron <ronljohnsonjr@gmail.com
> <mailto:ronljohnsonjr@gmail.com>> escribió:
>
> On 4/5/21 10:12 AM, CARLOS MULESOL wrote:
>
> I have a postgresql server and I want to connect remotely
> configuring ssl and a certificate like in
> https://www.postgresql.org/docs/13/ssl-tcp.html. But no matter how
> hard I try, it doesn't work. Any practical example please?
>
>
> What did you try, and what error messages did you receive?
>
--
Angular momentum makes the world go 'round.
^ permalink raw reply [nested|flat] 32+ messages in thread
* Re: Question
@ 2021-04-05 16:01 Sachin Kumar <sachinkumaras@gmail.com>
parent: Ron <ronljohnsonjr@gmail.com>
0 siblings, 0 replies; 32+ messages in thread
From: Sachin Kumar @ 2021-04-05 16:01 UTC (permalink / raw)
To: Ron <ronljohnsonjr@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
how to do it? even i tried to do it but not able to do it. I want to access
it remotely from PGAdmin.
Sachin
On Mon, Apr 5, 2021 at 9:24 PM Ron <ronljohnsonjr@gmail.com> wrote:
>
> What configurations did you try?
>
> On 4/5/21 10:51 AM, CARLOS MULESOL wrote:
>
> I get an error that I can't connect. No more
>
> CARLOS OCHOA GÓMEZ Técnico Mto Zona Norte E-mail: cochoa@mulesol.es /
> carlos8agomez@gmail.com Tfno: 679189284
>
> Obtener BlueMail para Android <http://www.bluemail.me/r?b=16696;
> En 5 abr. 2021, en 17:30, Ron <ronljohnsonjr@gmail.com> escribió:
>>
>> On 4/5/21 10:12 AM, CARLOS MULESOL wrote:
>>>
>>> I have a postgresql server and I want to connect remotely configuring ssl
>>> and a certificate like in https://www.postgresql.org/docs/13/ssl-tcp.html.
>>> But no matter how hard I try, it doesn't work. Any practical example please?
>>
>>
>> What did you try, and what error messages did you receive?
>>
>>
> --
> Angular momentum makes the world go 'round.
>
--
Best Regards,
Sachin Kumar
^ permalink raw reply [nested|flat] 32+ messages in thread
end of thread, other threads:[~2021-04-05 16:01 UTC | newest]
Thread overview: 32+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-11-09 08:23 question Mohammed A. <mjalha@essex.ac.uk>
2000-11-09 11:56 ` Oliver Elphick <olly@lfix.co.uk>
2002-03-15 20:57 Question .. Hernan Nuñez <hnunez@vianetworks.com.ar>
2003-09-02 19:24 Question Manuel Haroldo <mhcr@yahoo.com>
2003-09-02 21:41 ` Re: Question Peter Eisentraut <peter_e@gmx.net>
2003-12-07 20:42 question rose <rghubari@yahoo.com>
2003-12-08 13:04 Question Jerrianna Fox <jfox@infosciences.com>
2003-12-09 18:46 ` Re: Question Glenn Wiorek <gwiorek@jmlafferty.com>
2004-08-20 17:25 question Dariusz Sobierajewicz <dsobie@yahoo.com>
2004-08-20 20:57 ` Bruno Wolff III <bruno@wolff.to>
2004-08-21 14:38 ` Bruno Wolff III <bruno@wolff.to>
2005-02-23 17:11 Question FBaron@co.belcorp.biz
2005-02-23 18:08 Re: Question John Jensen <jrj@ft.fo>
2006-01-19 15:59 Question Chris Van Reenen <chris.vanreenen@charterhouseuk.com>
2006-01-19 20:30 ` Re: Question Scott Marlowe <smarlowe@g2switchworks.com>
2006-03-07 22:09 Fwd: Question German Raul Hoyos Parravicino <rhoyos@gmail.com>
2006-03-07 23:44 ` Re: Fwd: Question Michael Fuhr <mike@fuhr.org>
2006-03-08 14:07 Re: Fwd: Question Goulet, Dick <DGoulet@vicr.com>
2006-03-08 17:24 ` Re: Fwd: Question Michael Fuhr <mike@fuhr.org>
2006-11-07 20:17 Question Mark Steben <msteben@autorevenue.com>
2006-11-07 20:27 ` Re: Question Richard Broersma Jr <rabroersma@yahoo.com>
2006-11-07 20:45 ` Re: Question Scott Marlowe <smarlowe@g2switchworks.com>
2006-11-07 20:47 ` Re: Question Richard Broersma Jr <rabroersma@yahoo.com>
2006-11-07 20:29 ` Re: Question Jeff Frost <jeff@frostconsultingllc.com>
2006-11-07 20:50 ` Re: Question Mark Steben <msteben@autorevenue.com>
2006-11-08 00:55 ` Re: Question adey <adey11@gmail.com>
2019-08-27 08:45 question AL-Temimi, Muthana <muthana.al-temimi@tuhh.hamburg.de>
2021-04-05 15:12 Question CARLOS MULESOL <cochoa@mulesol.es>
2021-04-05 15:30 ` Re: Question Ron <ronljohnsonjr@gmail.com>
2021-04-05 15:51 ` Re: Question CARLOS MULESOL <cochoa@mulesol.es>
2021-04-05 15:53 ` Re: Question Ron <ronljohnsonjr@gmail.com>
2021-04-05 16:01 ` Re: Question Sachin Kumar <sachinkumaras@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox