How can I run a PostgreSQL database independently of the normal packaged
based configuration?
I just want to start up postgres or pg_ctl process using a different port,
pointing to a different data directory and get it running, with permissions
etc working okay.
I don't want it to depend on the
I am using Django to develop an app and I think I must have done a syncdb
(which deletes all records) without realizing it.
I have not vacuumed that database and I have also made a copy of the data
directory.
Is there some way to recover the deleted records?
--
Frank Church
On 8 March 2012 16:23, Guillaume Lelarge wrote:
> On Thu, 2012-03-08 at 10:18 +0000, Frank Church wrote:
> > How do you purge the postgresql transaction log?
> >
>
> You don't. PostgreSQL does it for you.
>
> > I am creating a virtual machine image and I wan
How do you purge the postgresql transaction log?
I am creating a virtual machine image and I want to erase any transaction
logs that got built up during development. What is the way to do that?
I am currently using 8.3 and 8.4.
Is there the possibility that the logs saved in /var/log also contai
An application I have written connects to a remote Postgresql 8.3/8.4
database using Lazarus/FreePascal components, Zeoslib, but it has been
timing out too often as the network gets busy in a bursty mode. When the
network times out, restarting the app retrieves the data quickly, it is
always avail
I want to migrate a lot of single user databases onto a single server
to allow the users to access them remotely, instead of on the
workstations. The databases are quite small and even the most heavily
used ones only have at most a few hundred records added to them
everyday.
The problem is they ha
Is it possible to change password through pg_auth?
I am developing a VM where may be necessary to reset passwords through
a web interface, without having postgresql actually running.
If the users are already set in the database, can the passwords be
changed by adding their md5 encoding to pg_auth
Can PostgresSQL be setup to automtatically run a script at start up?
I need something to run at start up in case the database crashed or
some programs did not close their databases properly on shutdown.
/voipfc
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make change
I need to package the ability to backup a PostgreSQL database in my application?
I obviously need to add pg_dump.exe to the package, and the dlls
required are listed below,
15/08/2007 15:4112,288 comerr32.dll
15/08/2007 15:41 139,264 gssapi32.dll
15/08/2007 15:41
Are there SQL commands that can do a backup over a client connection,
rather than from the command line like pgsql etc?
By that I mean some kind of SELECT commands that can retrieve the
database's content as SQL commands that can be replayed to a server to
restore it, rather than something that sa
I want to install postgresql as an embedded database and I am looking
to install the most minimal installation, with perhaps some support
for ODBC. I prefer to install it all in a separate directory so it
does not affect any standard PostgreSQL installation on the same
computer, running it as a dif
I have to this to extract formated times from timestamps, but I
suspect there is something much better, even if it uses a stored
procedure. The lpad command to is also funny because I have to
concatenate it with an empty quote to convert the output to a string.
select lpad(extract(hour from calld
Is there a built in function for retrieving the next value of a
sequence and updating the sequence counter?
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Which of the postgresql rpms contains pgdump. I have downloaded
postgresql-server and postgresql-libs and pgdump is not included.
Which rpm contains it?
/frank
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Sorry, I realized that.
On 9/7/06, Jan de Visser <[EMAIL PROTECTED]> wrote:
On Thursday 07 September 2006 11:38, Frank Church wrote:
> Does this device allow connection to other phones besides Skype, like
> Xten Xlite?
>
> http://www.voipvoice.com/UConnect-2.html.
>
Does this device allow connection to other phones besides Skype, like
Xten Xlite?
http://www.voipvoice.com/UConnect-2.html.
Compatibility with standard voip is not mentioned on their website?
---(end of broadcast)---
TIP 1: if posting/reading thro
On 9/5/06, codeWarrior <[EMAIL PROTECTED]> wrote:
It's generally considered bad form to use reserved words as column names
I am aware of that - in this case the column names are chosen to
reflect exactly the names of the attributes of the event being
recorded.
&qu
On 9/4/06, Alban Hertroys <[EMAIL PROTECTED]> wrote:
Michael Glaesemann wrote:
> Note that epoch does not mean 1900-01-01 00:00:00.
select *, timestamp 'EPOCH' + "timestamp" * interval '1 second' as
tstamp from ccmanager_log where id > 15400
select *, timestamp '1900-01-01 00:00:00' + "times
Peter's suggestion did not work.
On 9/4/06, Michael Glaesemann <[EMAIL PROTECTED]> wrote:
Please reply to the list so that others may contribute to and learn
from the discussion.
I am now getting familiar with google mail
On Sep 4, 2006, at 8:34 , Frank Church wrote:
> ER
On 9/4/06, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
Frank Church wrote:
> error: cannot cast tupe double precision to timestamp without time
> zone
>
> What is the right syntax?
It's not clear what the meaning of a double precision as a timestamp
would be. How about
I am trying to create a view based on this query
'select *, "timestamp"::timestamp from ccmanager_log'
This is the error I get to below, how do I use the time zone syntax
error: cannot cast tupe double precision to timestamp without time zone
What is the right syntax?
The column to be conve
My databases are created in SQL ASCII by default.
Is there some disadvantage to this? As a British user, which is the preferred
character set and what advantage do I have to gain by using it?database
---(end of broadcast)---
TIP 2: Don't 'kill -9'
I am looking for service providers that offer postgresql hosting.
One requirement, cheap but reliable (if there is any such thing).
It will be good if they can run different versions simultaneously (on different
ports of course)
If they offer versions of apache, php, mysql etc simultaneously i
I need to access PostgreSQL on a low level using libpq.dll.
Are there any programmers using Delphi here? Free Pascal users is also fine.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose a
Quoting Tom Lane <[EMAIL PROTECTED]>:
Quoting Tom Lane <[EMAIL PROTECTED]>:
Can this info be obtained by querying the system tables,
especially in the case of views? I am using 'scripting' languages and using C
will be quite awkward.
> Frank Church <[EMAIL PROTECTE
Quoting Tom Lane <[EMAIL PROTECTED]>:
Can this info be obtained by querying the system tables,
especially in the case of views? I am using 'scripting' languages and using C
will be quite awkward.
I have got to find if libpq's output is exposed in PHP or Ruby.
> Frank
Is there way to determine the table a query or a view's columns come from?
I am looking for something like that in postgresql. If it doesn't exist is there
some generalized SQL that can parse the query or view's definition and retrieve
the list.
something like
column name | actual column name |
This issue always stumps me. I need to set the default date for a column in
postgres. A value for today, today + x days, now (timestamp), now + x amount of
days.
I never seem to be able to locate it in the documentation or online. Can anyone
post it here once and for all for posterity?
I will be
I get this error when I try to delete a column in a table in PG 7.4
"ERROR: multiple INTERNAL dependencies for table"
What could the cause be and how do I get rid of it?
---(end of broadcast)---
TIP 5: don't forget to increase your free space map
Does PostgreSQL support INSERT syntax of this kind -
insert into table (table.col1, table.col2, table.col3) values('one', 'two',
'three')?
Trying it out generates an error. It works when the 'table' bit is removed from
the column names.
F Church
---(end of broadcast)---
I want to copy the data from one server to another. One is running Postgresql
7.4.6 and the other 7.4.7.
Are they any gotchas I should lookout for when making the copy?
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignor
One of my database tables appears to corrupted see this post - Re: [GENERAL]
REPOST:Memory Allocation error using pg_dump on 7.4.
On checking the archives it appears I have to use a pg_filedump program to fix
it, which doesn't appear to be in my distribution. Where can I find it and
install it?
I repeatedly get this error whenever I try to backup a database
The command used is:
pg_dump -Fc -O -U username tablename > tablename.20060122
pg_dump: ERROR: invalid memory alloc request size 4294967290
pg_dump: SQL command to dump the contents of table "cc_ratecard" failed:
PQendcopy() faile
I want to use pg_dump in a php program. Does pg_dump have specific error codes?
Does use the normal shell result codes to indicate success or failure ?
This message was sent using IMP, the Internet Messaging Program.
---
I repeatedly get this error whenever I try to backup a database
The command used is:
pg_dump -Fc -O -U username tablename > tablename.20060122
pg_dump: ERROR: invalid memory alloc request size 4294967290
pg_dump: SQL command to dump the contents of table "cc_ratecard" failed:
PQendcopy() failed
I am trying to work out how much space is taken up by a given database in the
file system.
I have googled the archives and found the stuff there looks dated.
Is there some script or query that can work it all out?
My current version is 7.4. Knowing abut 8.x.x will be fine too?
--
Is there a way to list running queries in PostgreSQL, especially those that
appear to have gone away or don't seem to be running at all?
This message was sent using IMP, the Internet Messaging Program.
---
What is the maximum length of an IN(a,b,cd) list in PostgreSQL?
I am using 7.4.
This message was sent using IMP, the Internet Messaging Program.
---(end of broadcast)---
TIP 3:
Is there a way to list runaway or long runninng queries and kill them?
Frank
This message was sent using IMP, the Internet Messaging Program.
---(end of broadcast)---
TIP 3: Have y
I am loading lots of data via SQL into a database and wrapping it into
transactions to speed it up.
This fails a number of times and causes the whole transaction to fail. The
queries results are logged so it is easy for me to find problem records.
Is there a setting or feature that allows which
How do you check the options a PosgreSQL service was started with?
Frank
This message was sent using IMP, the Internet Messaging Program.
---(end of broadcast)---
TIP 3: Have you c
Hi guys,
What is the command change database owner in PostgreSQL 7.4?
I think the 'ALTER DATABASE foo OWNER TO blob;' is not implemented in 7.4
R Church
This message was sent using IMP, the Internet Messaging Program.
-
42 matches
Mail list logo
