On Mon, Mar 3, 2008 at 3:55 AM, Vladimir Rusinov <[EMAIL PROTECTED]>
wrote:
> How can I check if all indexes in my database is valid, how to show the
> invalid ones (and rebuild them)?
> Any quick solutions?
How do you define whether and index is valid or invalid?
--
R
maybe this link answers
your question:
http://www.postgresql.org/about/
Regards,
Richard Broersma Jr.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
rake/2007/08/how_many_rows_do_i_have_anyway/
Regards,
Richard Broersma Jr.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
installation.
to do step 2, follow this link: http://www.geocities.com/operationsengineer1/
open the PostgreSQL word doc, go to page 5 and follow the instructions
on how to delete the OS user.
--
Regards,
Richard Broersma Jr.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To
on is to add an after update trigger, and manually set
lastupdate then.
--
Regards,
Richard Broersma Jr.
Visit the Los Angles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http
d
> tagableRS.Close()
Your advice worked perfectly. Thank you very much!
--
Regards,
Richard Broersma Jr.
Visit the Los Angles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your s
ile?
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
On Tue, Aug 26, 2008 at 5:19 PM, <[EMAIL PROTECTED]> wrote:
> This means a file systems backup. eg.
>
> tar -cvpf data_bakup.tar /var/lib/pgsql/data
Thanks also for the script. I will take a close look.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Use
overy.
Thanks for the reply! I want to be certain that I understand the
point you are making:
Is setting up a warm standby server good pratice for gaining
experience in PITR or do you mean that PITR is a good starting point
for setting up a warm standby server?
--
Regards,
Richard Broersma
blem you are seeing:
http://www.postgresql.org/docs/8.3/interactive/role-membership.html
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes t
On Thu, Aug 28, 2008 at 1:49 PM, Richard Broersma
<[EMAIL PROTECTED]> wrote:
> On Thu, Aug 28, 2008 at 1:37 PM, Carol Walter <[EMAIL PROTECTED]> wrote:
>
>> I granted the app_admin role to my user name. When I try to
>> describe the table using the "\d"
Reading the manual for PITR, I see the backup commands are tar, cpio, and rsync.
What DOS shell commands recommended: copy, xcopy? Is there something better?
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via
ut what is available:
http://pgfoundry.org/search/?type_of_search=soft&words=dbi+link
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make chan
need to be on topic. So far us users are free to advocate
anthing we want in our signatures as long as it is not vulgar.
Aside from this, we individually have the freedom to spam-bucket
anyone's emails that astound and dismay us.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles Pos
ted is the putting down or
belittling people because they fall into anyone these categories.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes
You probably need break up your insert transactions into smaller
segments that coincide DDL changes.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To m
d
scripts.
The following archived thread illustrates what one person did to
develop automatic creation of table partitions:
http://archives.postgresql.org/pgsql-general/2009-04/msg01077.php
The above mentioned email may give you a workable solution.
--
Regards,
Richard Broersma Jr.
Visit the
On Thu, Aug 20, 2009 at 10:31 AM, Tena Sakai wrote:
> Can somebody please tell me how I could retrieve a
> history of this particular thread?
Generally:
http://archives.postgresql.org/
Specifically:
http://archives.postgresql.org/pgsql-admin/2009-08/msg00056.php
--
Regards,
Richard Br
eems I do not know how to look for.
> Waiting for helpt, I thank very much in advance.
You can export the database using the pg_dump command line tool.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgs
ed to insure that the data is secure to satisfy federal
> HIPAA regulations. One way to do that would be to store some or all of it
> in an encrypted format.
Here is a presentation that give a high level view of how to secure the data.
http://momjian.us/main/writings/pgsql/securing.pdf
--
esql.org/images/9/91/Pguswest2008hnd.pdf
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
undry.org/projects/oledb/
You should probably use the odbc driver since it is production ready
and actively supported.
http://www.postgresql.org/ftp/odbc/versions/msi/
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent
tgres users who store encrypted credit card numbers
> and other personal data. How do they solve this problem?
Bruce has a presentation on this subject:
http://momjian.us/main/writings/pgsql/securing.pdf
Although, I don't know if it has an illustration that exactly matches
your problem.
is there a way around to use select row(...) = row(...)?
Does: (T1.value1,T1.value2, T1.value3, ... ) IS NOT DISTINCT FROM
(T2.value1,T2.value2, T2.value3,...)
or: Row( T1.* ) IS NOT DISTINCT FROM ( T2.* )
work for you?
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL U
> 1 | some text
> 2 | some texta
SELECT Array_agg( id ) AS duplicate_ids, val
FROM test_dup
GROUP BY val
HAVING COUNT(*) > 1;
SELECT T1.id, T2.id, T.val
FROM test_dup AS T1
INNER JOIN test_dup AS T2
USING ( val );
--
Regards,
Richard Broersma Jr.
V
-
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Are you referring to a historical data achieve used for logging instantaneous
process values?
--- Rodrigo Sakai <[EMAIL PROTECTED]> wrote:
> Hi everyone, I'm focus on temporal databases (not temporary), and I want to
> know if anyone
> here is studying this tecnologies too. So, we can exchang
e completed then log out using "\q"
Now if you wanted to change you ident method back to md5 you will be able to
use you new password.
This should work, but you would probably be better server by following the
directions in the
postgresql documentation.
Regards,
Ri
> How should I do this? The current auto-generated pg_hba.conf file read as:
> "local all postgresident sameuser"
> on the first line, and the first line also after the # TYPE
> DATABASEMETHOD line.
>
>
> Do you mean I should change the "ident sameuser" at the end to "trust"?
Belo
Could RRS be implemented in a similar fashion to OPC-HDA?
Regards,
Richard
--- "Jim C. Nasby" <[EMAIL PROTECTED]> wrote:
> On Tue, Mar 28, 2006 at 10:23:45AM -0800, Mark Liberman wrote:
> > > Probably your biggest issue will be temporary files created by temporary
> > > tables, sorts that
> spi
Is anyone aware of documentation that describes what the valid parameters for
the PGOPTS variable
are and how they are used?
Regards,
Richard
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql
All I could find similar to PGOPTS was PGOPTIONS. Are they equivalent? If they
are, would it be
safe to use PGOPTIONS in-place of PGOPTS in the /etc/conf.d/postgresql conf
file?
--- Bruce Momjian wrote:
> Richard Broersma Jr wrote:
> > Is anyone aware of documentation that describes
You might find what you are looking for at:
http://www.postgresql.org/download/
Regards,
Richard Broersma Jr.
--- German Raul Hoyos Parravicino <[EMAIL PROTECTED]> wrote:
> Hello Everybody.
>
> I am developing an application in As400, every thing is Ok, but I need that
&
http://pgfoundry.org/frs/download.php/873/psqlodbc-08_02_0002.zip
this link should have every thing you need.
Regards,
Richard Broersma Jr.
--- Chris Hoover <[EMAIL PROTECTED]> wrote:
> This question would be better suited for the pgsql-odbc list. You will
> probably also get
l ip like 192.168.1.* will be allowed
to connect.
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
> PLEASE REMOVE ME FROM [EMAIL PROTECTED]
Most of us on the list can't remove you. But if you adjust your hotmail client
to view full
headers you will see the following line that you will need to unsubscribe:
List-Unsubscribe: <mailto:[EMAIL PROTECTED]>
Regards,
Richa
> Good morning, i ask you please erase me from the list, thanks
> I'd tried to do by myself but i forget my password.
Using your hotmail account, if you turn on full headers you will see the
following entry:
List-Unsubscribe: <mailto:[EMAIL PROTECTED]>
Regards,
Ri
n."
The error messages will help use to provide the correct configuration changes
to get postgresql up
and running.
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
cannot
> remeber any stupid thing we could have done (but may be we did... And
> what do I have to do to recreate the postgres database... in fact, is it
> even necessary doing so ?
If you issue "\l" from within the posgresql command prompt does it list
postgres as a database
> Richard,
> Are you sure that you weren't typing an additional argument, such as:
> sudo -u postgres psql db_name
I'm not the one having problems connecting to the postgres database ;)
Regards,
Richard Broersma Jr.
---(end of broadcast)
have the following
choices:
dblink, for postgres to postgres connection
dbi-link, for postgres to anything else.
http://pgfoundry.org/
For replication:
you have slony, etc. al.
http://slony.info/
Regards,
Richard Broersma Jr.
---(end of broadcast)
> I would be very grateful if someone could answer me,
> where to find instructions how to set the size ( in megabytes ) for
> particular database.
I don't understand the question, are you looking to limit the size of your
database?
Regards,
Richa
ont forget to reply-all when you
reply to email from
the postgresql lists so that everyone on the lists are copied with your emails.
This way everyone
on the list can participate in this discussion. This is important since, I can
not think of an
answer for your question. :o)
Regards,
Richard Bro
t is difficult to recover from such a situation without
> major effort.
These links supplement the above comments:
http://www.postgresql.org/docs/8.1/interactive/disk-full.html
http://www.postgresql.org/docs/8.1/interactive/manage-ag-tablespaces.html
Regards,
Richard Broersma Jr.
---
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.
---(end
---> 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.
---(end of broadcast)---
TIP 6: explain analyze is your friend
ocs/8.1/interactive/ddl-partitioning.html
Regards,
Richard Broersma Jr.
---(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
> Please help me out
> my data bases is like 1gigabyte, panicking
> thanks
May be try the general mailing list. There are more users there with the
experience needed to
advise you.
Regards,
Richard Broersma Jr.
---(end of broadcast)
I would
know one way or the other. In the future, if "the powers at be" what to give
the most
powerful/versatile Open Source RDMS a second try, you will find plenty of tools
and script to port
or MS-SQL to Postgresql.
I hope your other DBA was canned for being a stanch Postgres
oops...
I fat fingered that one...>
> I hope your other DBA wasn't canned for being a stanch Postgresql supporter.
> :o)
^^^
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
ostgresql version 8.1 to preform validation tests with your
front-ends. After you
are satisfied that everything works well you can replace the version 7
production server with
version 8.
If you would like a safety net beyond this you could contact one of the
PostgreSQL consulting
companies to wal
ve the problem increasing back-up times. Of course,
equipping yourself with a
cannon now will really help after your mosquito grows in to an albatross. :o)
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 7: You can help support the Pos
ourage more people to learn SQL.
I have some test table that I created from the SQL puzzles and answers book.
However, I didn't
not develop test for each exercise since sample data wasn't provided.
Regards,
Richard Broersma Jr.
---(end of broadcast)
> Thanks! Please do send any test data you have, or sql puzzle exercises, since
> I am anxious to
> learn as much as possible.
> And, let me know the book/author, in case I can find a copy.
Here is a link for the book:
http://books.elsevier.com/us/mk/us/subindex.asp?isbn=0123735963&country=Un
discussion. In addition to
this, there are others on the list that might have better answers than the ones
that I give. So
it is important that you always send your emails to the mailing list. The
easiest way to do this
is to reply-all when you respond to emails from the list.
R
he tables into Microsoft Access, and do my exercises there if I
> wish, and share the
> exercise tables at utteraccess.com
I am using Postgresql 8.1.5.
you could upgrade your home server to 8.2.0 or 8.1.5 and it would work fine.
Regards,
Richard Broersma Jr.
---(
QL and
postgresql.
Regards,
Richard Broersma Jr.
---(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
eply ASAP. Waiting for your reply.
This link is a good place to start. I can probably explain this process as well
as I can.
http://www.postgresql.org/docs/8.2/interactive/installation.html
Regards,
Richard Broersma Jr.
---(end of broadcast)---
notice the following links comment:
http://www.postgresql.org/support/versioning
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTEC
ed in JOINS and WHERE conditions. I don't see either
of those in your
query.
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
e
> referencing work. If an index is needed on the F-key column, it has to be
> created, right?
Correct.
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
cho
on
>
The solution that I use is found on this link:
http://archives.postgresql.org/pgsql-general/2006-12/msg01486.php
Maybe be it can give you some ideas that you can use in your bat script file.
Regards,
Richard Broersma Jr.
---(end of broadcast)--
--- George Wilk <[EMAIL PROTECTED]> wrote:
> Is there a reliable way of verifying version of the database by looking at
> the PGDATA directory?
Does the file "PG_VERSION" not tell what you need?
Regards,
Richard Broersma Jr.
--
that you
can call from a
cron or scheduler, I can provide some ideas if you are enterested.
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
ld have.
(3) And this probably will not change soon since the OLE DB driver is not
actively supported.
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-n
CONSTRAINT code_title PRIMARY KEY(code,title)
);
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
lying index in Informix.
This is not true in postgreSQL, with the exception of UNIQUE types of indexs.
However, check constraints do not require any indexs.
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 3: Have you che
its associated
schema? Also, depending on how you created your table names (created case
sensitive tables names using quotations), you may need to need to supply the
propery spelled and quoted table names to the pl function.
Regards,
Richard Broersma Jr.
---(e
is often caused by services running as a user account, try configuring
the services to run in either the LocalService or NetworkService account.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp
...
Regards, Richard Broersma Jr.
--- On Thu, 11/15/07, Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
> My desktop (acting as a db-server for my discipline's
> group) has it power cycled this morning at 4:10
>...
> C:\Program
> Files\PostgreSQL\8.2\bin>2007-11-15 06:36:13
> PANIC: could
ectory supposed to be marked read only?
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
T *
FROM Tellers
WHERE bin = ANY( '1', '2' );
and
SELECT T.*
FROM Tellers AS T
INNER JOIN ( VALUES ( '1' ), ( '2' ) ) AS B( bin )
ON T.bin = B.bin;
Regards,
Richard Broersma Jr.
---(end of broadcast)-
--- On Wed, 12/12/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> I seriously doubt that one's gonna win ...
:-)
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
73 matches
Mail list logo
