Re: Error when loading data to database to postgresql

2021-07-15 Thread Kasper Laudrup
On 7/15/21 11:05 AM, Wale Olajumoke wrote: Please how do I fix this error that comes up when loading data. See the error message below. Reading something like this is a good start: https://www.propublica.org/nerds/how-to-ask-programming-questions Kind regards, Kasper Laudrup -- You

Error when loading data to database to postgresql

2021-07-15 Thread Wale Olajumoke
Please how do I fix this error that comes up when loading data. See the error message below. Thanks Traceback (most recent call last): File "/app/.heroku/python/lib/python3.9/site-packages/django/contrib/contenttypes/models.py", line 19, in get_by_natural_key ct =

Trouble with Select_for_update. Postgresql

2021-03-30 Thread zidan....@gmail.com
Hi there . code is as follows: ` models.Classroom table have just one record. # THREAD 1 school_classrooms = models.Classroom.objects.select_for_update().all() with transaction.atomic(): list(school_classrooms) time.sleep(10) # THREAD 2 classroom = models.Classroom.objects.first() classroom.name

Re: I have a 2drop down list and 1 description box i want to save the data from all this to my postgresql data base

2021-02-18 Thread Siarhei Siarhei
А, зачем все это: class Dataform(forms.ModelForm): class Meta: model = data можно и так: contact_date = forms.CharField(required=True) jQuery('.contact_date').datetimepicker(); четверг, 18 февраля 2021 г. в 03:15:55 UTC+3, itmin...@gmail.com: > SAME ISSUE WITH ME > > > On Wed, Feb 17, 2021 at

Re: I have a 2drop down list and 1 description box i want to save the data from all this to my postgresql data base

2021-02-17 Thread itmind club
SAME ISSUE WITH ME On Wed, Feb 17, 2021 at 2:09 PM neha bhurke wrote: > Hii Everyone, > > I have created a form with 2dropdown list , 1 description box and 1 > datetime field but data is not saved in the database. I am getting problem > due to date can anyone help me please.. > > This is my

I have a 2drop down list and 1 description box i want to save the data from all this to my postgresql data base

2021-02-17 Thread neha bhurke
Hii Everyone, I have created a form with 2dropdown list , 1 description box and 1 datetime field but data is not saved in the database. I am getting problem due to date can anyone help me please.. This is my models.py class data(models.Model): machinename = models.CharField(max_length=100)

Does Django 2.2 LTS supports Postgresql 11 ?

2021-02-16 Thread phep
Hi, Pretty much everything is in the subject line! The release-notes say Postgresql 9.4 or higher is supported, but Postgresql 11 had been released only 6 months before Django 2.2, so I'd prefer to be sure. Thanks in advance, phep -- You received this message because you are subscribed

Memory Leak and Solution for Django and PostgreSQL Application

2021-01-18 Thread Sachin Kumar
Hi Experts, Please help me out with a solution in finding Memory leak from a Django and PostgreSQL App. which is the best way to find Memory leak and what would be the solution? How to built Memory Profiler for a Django Applications? if anyone has ever created a Django Memory Profiler, pls

In postgresql, ExpressionWrapper and DurationField does not work.

2021-01-17 Thread 김정진
Hi. I used mariadb and have migrated into postgresql 12 now. One of source code generates an error on postgresql. ... Q(active_at__lt=now()- ExpressionWrapper(F('configuration__interval') * 1.5 * 100 * 60, output_field=DurationField( ... is compile as : str(queryset.query) "acti

Re: PostgreSQL Django Query

2021-01-07 Thread gabriela...@gmail.com
ngo and PostgreSQL to build our report app. > > I am using below mention query to find some details. the query mention > below is running fine in PostgreSQL command line and giving result in 2 sc > for 2 million cards but when i i am try the same in Django application it > is takin

PostgreSQL Django Query

2021-01-07 Thread Sachin Kumar
I am using Python Django and PostgreSQL to build our report app. I am using below mention query to find some details. the query mention below is running fine in PostgreSQL command line and giving result in 2 sc for 2 million cards but when i i am try the same in Django application it is taking

Re: Problem with Postgresql-11.9 ??

2020-11-22 Thread Israel Adeyeye
\Envs\easynet\lib\site-packages\django\db\backends\postgresql\base.py", line 25, in import psycopg2 as Database File "C:\Users\lenovo\Envs\easynet\lib\site-packages\psycopg2\__init__.py", line 51, in from psycopg2._psycopg import ( # noqa ModuleNotF

Re: Problem with Postgresql-11.9 ??

2020-10-16 Thread David Nugent
Apologies, I must have bumped send accidentally. To complete the sentence, unless fields have null=True then referencing unsaved records here will fail because there is no id in the dependent records to provide a reference. By default there is a constraint that the reference is not null. But

Re: Problem with Postgresql-11.9 ??

2020-10-16 Thread David Nugent
here is some useless info… I’ve been using various combinations of Postgres and Django (currently 12.4 and 3.1.2, respectively) and would think I would have stumbled on this at some point when using postgresql-11. But I probably haven’t tried 11.x with 3.1.2 specifically… - Tom On Oct 12, 2020

Re: Problem with Postgresql-11.9 ??

2020-10-12 Thread Joakim Hove
currently > 12.4 and 3.1.2, respectively) and would think I would have stumbled on this > at some point when using postgresql-11. But I probably haven’t tried 11.x > with 3.1.2 specifically… > > - Tom > > On Oct 12, 2020, at 9:24 AM, Joakim Hove wrote: > > [ This question is a

Re: Problem with Postgresql-11.9 ??

2020-10-12 Thread Thomas Lockhart
No one has answered yet, so here is some useless info… I’ve been using various combinations of Postgres and Django (currently 12.4 and 3.1.2, respectively) and would think I would have stumbled on this at some point when using postgresql-11. But I probably haven’t tried 11.x with 3.1.2

Problem with Postgresql-11.9 ??

2020-10-12 Thread Joakim Hove
[ This question is also posted to StackOverflow: https://stackoverflow.com/questions/64320386/django-postgresql-model-with-only-foreign-keys ] I have a model which looks like this: class InputTypeMap(models.Model): input_type = models.ForeignKey(InputType, on_delete=models.CASCADE

Re: Django and PostgreSQL update

2020-09-17 Thread Oussama Ben Rejeb
u can do a data dump before, but i think that there is no problem to update it On Thursday, September 17, 2020 at 2:29:46 PM UTC+2 dupakoo...@gmail.com wrote: > Hello everyone, > > I have a small database. Django version currently 2.2, postgres 9.2.24. I > forgot to note the psycopg2 older

RE: Django and PostgreSQL update

2020-09-17 Thread dupakoor kannan
Hello everyone, I have a small database. Django version currently 2.2, postgres 9.2.24. I forgot to note the psycopg2 older version. It was working fine. I have updated django to 2.2.26 and psycopg2==2.8.3. Also, I made changes in my model and migrated. I come across this error during migration.

HOWTO : Redundant PostgreSQL connection

2020-09-16 Thread Charles Bueche
Hi, We have a redundant PostgreSQL server pair and this is how I managed to connect to both servers using the underlying libpq features.     https://www.netnea.com/cms/2020/09/16/redundant-postgresql-connection-in-django/ keywords : DATABASES, OPTIONS, target_session_attrs, sslmode Regards

RES: Command open postgresql in from cmd in windows

2020-05-31 Thread Samuel Nogueira
You’re welcome  De: sunday honestyEnviado:domingo, 31 de maio de 2020 06:19Para: django-users@googlegroups.comAssunto: Re: Command open postgresql in from cmd in windows It worked Samuel. Thank you very much On Sun, May 31, 2020, 7:38 AM sunday honesty <honesty202...@gmail.com> wrote:All

Re: Command open postgresql in from cmd in windows

2020-05-31 Thread sunday honesty
gt;>> wrote: >>> >>>> Sorry but i think your screenshot wasn’t attached to your last email, >>>> please end it again >>>> >>>> *De: *sunday honesty >>>> *Enviado:*sábado, 30 de maio de 2020 18:28 >>>>

Re: Command open postgresql in from cmd in windows

2020-05-31 Thread sunday honesty
;>> *De: *sunday honesty >>> *Enviado:*sábado, 30 de maio de 2020 18:28 >>> *Para: *django-users@googlegroups.com >>> *Assunto: *Re: Command open postgresql in from cmd in windows >>> >>> >>> >>> Here is the screenshot... Pls

Re: Command open postgresql in from cmd in windows

2020-05-30 Thread Samuel Nogueira
Samuel Nogueira > wrote: > >> Sorry but i think your screenshot wasn’t attached to your last email, >> please end it again >> >> *De: *sunday honesty >> *Enviado:*sábado, 30 de maio de 2020 18:28 >> *Para: *django-users@googlegroups.com >> *Assu

Re: Command open postgresql in from cmd in windows

2020-05-30 Thread sunday honesty
om > *Assunto: *Re: Command open postgresql in from cmd in windows > > > > Here is the screenshot... Pls download. > > > > PS: I was connected to the internet and also tried it without internet > connection. > > > > On Sat, May 30, 2020, 10:17 PM Samuel Nogueira

RES: Command open postgresql in from cmd in windows

2020-05-30 Thread Samuel Nogueira
Sorry but i think your screenshot wasn’t attached to your last email, please end it againDe: sunday honestyEnviado:sábado, 30 de maio de 2020 18:28Para: django-users@googlegroups.comAssunto: Re: Command open postgresql in from cmd in windows Here is the screenshot... Pls download. PS: I

Re: Command open postgresql in from cmd in windows

2020-05-30 Thread sunday honesty
> *Enviado:*sábado, 30 de maio de 2020 15:18 > *Para: *django-users@googlegroups.com > *Assunto: *Re: Command open postgresql in from cmd in windows > > > > @Samuel, > > I did that and psql now opened and prompted me to enter password for my > user name(syste

RES: Command open postgresql in from cmd in windows

2020-05-30 Thread Samuel Nogueira
Can you send  me more details about the error? A screenshot should be enoughDe: sunday honestyEnviado:sábado, 30 de maio de 2020 15:18Para: django-users@googlegroups.comAssunto: Re: Command open postgresql in from cmd in windows @Samuel,I did that and psql now opened and prompted me to enter

Re: Command open postgresql in from cmd in windows

2020-05-30 Thread sunday honesty
@Samuel, I did that and psql now opened and prompted me to enter password for my user name(system). I entered the password I created while installing postgresql and got a fatal error even when I was connected to the internet... PS: the username it gave me during installation is postgres

Re: Command open postgresql in from cmd in windows

2020-05-30 Thread Jorge Gimeno
Postgres on Windows may have a different story and user interface. You may need to use something like pAdmin to work with it. -Jorge On Sat, May 30, 2020 at 10:20 AM sunday honesty wrote: > I have been in a message before I could successfully install postgresql on > my windows; it

RES: Command open postgresql in from cmd in windows

2020-05-30 Thread Samuel Nogueira
Set path For PostgreSQL in Windows: Searching for env will show Edit environment variables for your accountSelect Environment VariablesFrom the System Variables box click new(to add new path) Include the bin directory of your PostgreSQL installation. then add new path there[for example]C

Command open postgresql in from cmd in windows

2020-05-30 Thread sunday honesty
I have been in a message before I could successfully install postgresql on my windows; it seems everyone is using Linux or Mac. Pls can someone help me now... I want to open postgres she'll from my command prompt so I can continue what am learning... The Tutorial am following is using Linux

Re: Postgresql and mysql

2020-05-23 Thread Sebastian Jung
Hey you can Import Files on a Terminal with sudo -u postgres psql < File.txt Salima Begum schrieb am Mo., 18. Mai 2020, 13:50: > Hi , > Mysql query which we used previously now we moved to postgresql, > Here is the below query in mysql , Can anyone help me to write > similar quer

Re: Postgresql and mysql

2020-05-23 Thread Ram
benefits. https://pgloader.readthedocs.io/en/latest/index.html HTH, ~Ram On Mon, May 18, 2020 at 5:50 AM Salima Begum wrote: > Hi , > Mysql query which we used previously now we moved to postgresql, > Here is the below query in mysql , Can anyone help me to write > similar query i

Postgresql and mysql

2020-05-18 Thread Salima Begum
Hi , Mysql query which we used previously now we moved to postgresql, Here is the below query in mysql , Can anyone help me to write similar query in postgresql. query = "LOAD DATA LOCAL INFILE '41098_category_list.txt' INTO TABLE pages_rim_ls_categories FIELDS TERMINATED BY '|' LINES TERMI

Gunicorn-wsgi-nginx-postgresql-django linode hosting

2020-05-13 Thread Tobi DEGNON
Hi I need help, I'm hosting a django app on linode, the app is running on Ubuntu 18.04 LTS with gunicorn, nginx a postgresql database, and I'm using let's encrypt for SSL certificate, the issue is when I fill a form (login or signup) I get a timeout error but I don't have that issue

Add Active Directory accounts informations (sn, givenname, etc....) in the postgresql DB

2020-04-28 Thread David OCTAU
, mail, etc...) in my postgresql Data Base via the models.py because i would like to add a lot of other informations about users (ex : If they need a laptop, their type of contract, fonctions, services, etc...) and i would like to have the possibility to create new AD users or modify

postgresql/operations.py @ 235 leaking memory

2020-04-01 Thread Francesco Meli
Hello, I have posted a well detailed issue here on StackOverflow (it can be improved if asked): https://stackoverflow.com/questions/60972577/django-postgres-memory-leak - I have a custom command that crunches jobs coming from a Postgresql table jobs. - Since the command

Re: I have issue. I want to migrate database from sqlite3 to postgresql. With a table have 10M records. I need a solution for issue. Maybe help me?

2020-03-26 Thread Farai M
Export to csv in SQL then import into postgresql from there On Wed, Mar 25, 2020, 6:43 PM Thắng IT wrote: > solution > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsubscribe from this group an

Re: I have issue. I want to migrate database from sqlite3 to postgresql. With a table have 10M records. I need a solution for issue. Maybe help me?

2020-03-26 Thread Daniel Chimeno
One possible solution: $ createdb newdb $ pgloader ./test/sqlite/sqlite.db postgresql:///newdb https://github.com/dimitri/pgloader El miércoles, 25 de marzo de 2020, 17:45:54 (UTC+1), Thắng IT escribió: > > solution -- You received this message because you are subscribed to the

Re: I have issue. I want to migrate database from sqlite3 to postgresql. With a table have 10M records. I need a solution for issue. Maybe help me?

2020-03-25 Thread Motaz Hejaze
cant be done directly from sqlite to postgres as there are differences between them ... safer to generate an intermediate file like a CSV or Excel file from the sqlite database .. create the new postgres database with proper column types .. make a python script to loop through each row in CSV or

I have issue. I want to migrate database from sqlite3 to postgresql. With a table have 10M records. I need a solution for issue. Maybe help me?

2020-03-25 Thread Thắng IT
solution -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To view this discussion on the web visit

need connection string help to connect to Db Postgresql

2020-03-20 Thread Juan J . Moreno Piña
I am not able to connect Postgresql , due to miss connectio string. also filling DB confi table: Engine="" Name="" User pass Host: ? Database_port: ? thanks -- You received this message because you are subscribed to the Google Groups "Django users" group.

Re: PostgreSQL data transfering

2020-03-12 Thread Naveen Arora
Please be more specific about your question. As far i could understand by now, you need to check how your models are related and then you can easily normalize them into as many models as possible. Cheers On Wednesday, 11 March 2020 15:29:32 UTC+5:30, Eldar Yerzhanov wrote: > > Hello, I have

PostgreSQL data transfering

2020-03-11 Thread Eldar Yerzhanov
Hello, I have this kind of problem. We have designed two applications with different models. Now we should divide these applications into three apps by dividing all information inside them into 3 models. What kind of method or technique I can use to apply it. -- You received this message

Re: json null value in a PostgreSQL jsonb column

2020-02-04 Thread Макс Вернер
t; sql NULL value). > > Assume the following model: > > class Container(models.Model): > data = JSONField(blank=False, null=False) # emphasis on null=False > > > In PostgreSQL, it is perfectly reasonable to do this: > > INSERT INTO container VALUES (1, 'null'); > >

Re: Hi everyone I am new in django and postgresql. Actually I am getting following error when i run the project, Although I am putting right password and username. Please Help me....

2020-01-03 Thread Muhammed Rafi A
return func(*args, **kwargs) > File > "/Applications/Projects/venv/lib/python3.8/site-packages/django/db/backends/base/base.py", > line 197, in connect > self.connection = self.get_new_connection(conn_params) > File > "/Applications/Projects/venv/

Re: Hi everyone I am new in django and postgresql. Actually I am getting following error when i run the project, Although I am putting right password and username. Please Help me....

2020-01-03 Thread Rajesh Maruti
cio.py", > line 26, in inner > return func(*args, **kwargs) > File > "/Applications/Projects/venv/lib/python3.8/site-packages/django/db/backends/base/base.py", > line 197, in connect > self.connection = self.get_new_connection(conn_params) > File > "/A

Re: Hi everyone I am new in django and postgresql. Actually I am getting following error when i run the project, Although I am putting right password and username. Please Help me....

2020-01-03 Thread sagar ninave
Hello ShailendraI have tried to attached postgresql to django but it could not happened please can you tell me what is procedure to do that -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiv

Re: Hi everyone I am new in django and postgresql. Actually I am getting following error when i run the project, Although I am putting right password and username. Please Help me....

2020-01-03 Thread shailendra singh
pplications/Projects/venv/lib/python3.8/site-packages/django/utils/asyncio.py", > > line 26, in inner > return func(*args, **kwargs) > File > "/Applications/Projects/venv/lib/python3.8/site-packages/django/db/backends/base/base.py", > > line 197,

Re: Hi everyone I am new in django and postgresql. Actually I am getting following error when i run the project, Although I am putting right password and username. Please Help me....

2020-01-03 Thread Motaz Hejaze
/Applications/Projects/venv/lib/python3.8/site-packages/django/utils/asyncio.py", > line 26, in inner > return func(*args, **kwargs) > File > "/Applications/Projects/venv/lib/python3.8/site-packages/django/db/backends/base/base.py", > line 197, in connect > self

Re: Hi everyone I am new in django and postgresql. Actually I am getting following error when i run the project, Although I am putting right password and username. Please Help me....

2020-01-03 Thread ramadhan ngallen
;     self.connect() >   File > "/Applications/Projects/venv/lib/python3.8/site-packages/django/utils/asyncio.py", > line 26, in inner >     return func(*args, **kwargs) >   File > "/Applications/Projects/venv/lib/python3.8/site-packages/django/db/backends/base/base.p

Hi everyone I am new in django and postgresql. Actually I am getting following error when i run the project, Although I am putting right password and username. Please Help me....

2020-01-03 Thread shailendra singh
n connect self.connection = self.get_new_connection(conn_params) File "/Applications/Projects/venv/lib/python3.8/site-packages/django/utils/asyncio.py", line 26, in inner return func(*args, **kwargs) File "/Applications/Projects/venv/lib/python3.8/site-packages/django/db/b

Re: I am very nice in Django Postgresql. I am getting attached error . Please resolve..

2019-12-30 Thread Vivek Jha
psycopg2 library is missing. Use pip install psycopg2 to fix it. It is an connection adapter between Python and PostgreSQL On Mon, 30 Dec 2019, 18:29 shailendra singh, wrote: > > -- > You received this message because you are subscribed to the Google Groups > "Dj

Re: Django on an existing PostgreSQL Database?

2019-11-25 Thread carlos
https://docs.djangoproject.com/en/2.2/howto/legacy-databases/ On Mon, Nov 25, 2019 at 3:03 PM Ulrich Goebel wrote: > Hi, > > I have an existing PostgreSQL Database with about 20 tables, using > collating sequences, foreign keys, triggers, and even additional indexes. > For that

Django on an existing PostgreSQL Database?

2019-11-25 Thread Ulrich Goebel
Hi, I have an existing PostgreSQL Database with about 20 tables, using collating sequences, foreign keys, triggers, and even additional indexes. For that database I want to write a WEB-frontend to insert, update and delete data in the database. I don't want to define the data model in python

Re: Problem trying to use postgresql and psycopg2 in a django project

2019-11-20 Thread Yoo
o 2 developement environment and to > connect it to postgresql but whern I change the parameters in settings.py on > the sections of DATABASES to use POSTGRES and Psycopg2  I Receive the > following error > > > > > > > > eztve) Indiras-MBP-16a3:ezt

Problem trying to use postgresql and psycopg2 in a django project

2019-11-20 Thread tramites xpress drive
*Hi, I Have been trying to setup my django 2 developement environment and to connect it to postgresql but whern I change the parameters in settings.py on the sections of DATABASES to use POSTGRES and Psycopg2 I Receive the following error* eztve) Indiras-MBP-16a3:ezt Sindira$ python

Re: Fedora 30 server (Configuring Postgresql with Django)

2019-10-30 Thread hari49pf
gt;> hari...@gmail.com> wrote: >>>>>> >>>>> >>>>>>> Hi, >>>>>>> >>>>>>> Please find the attachment, below are the screen shots of the >>>>>>> setting & DB permissions

Re: Fedora 30 server (Configuring Postgresql with Django)

2019-10-30 Thread carlos
permissions please help me >>>>>> >>>>>> >>>>>> [image: Screenshot from 2019-10-29 10-40-47.png] >>>>>> >>>>>> >>>>>> [image: Screenshot from 2019-10-29 10-40-40.png] >>>>>> &

Re: Fedora 30 server (Configuring Postgresql with Django)

2019-10-30 Thread hari49pf
sions please help me >>>>> >>>>> >>>>> [image: Screenshot from 2019-10-29 10-40-47.png] >>>>> >>>>> >>>>> [image: Screenshot from 2019-10-29 10-40-40.png] >>>>> >>>>> >>>

Re: How to migrate and copy Data from sqlite to Postgresql

2019-10-30 Thread Uzama Zaid Mohammed Jaward
ployed Application on pythonanywhere . > > There are 250 records already created and relational database with 5 > models present in Application. > > Default DB is Sqlite and I have to switch to Postgresql with all old > Records. I have support of Postgresql in Application. > > Than

How to migrate and copy Data from sqlite to Postgresql

2019-10-30 Thread Balaji Shetty
to Postgresql with all old Records. I have support of Postgresql in Application. Thanks in advance. -- Mr Shetty Balaji Asst. Prof. IT Department SGGS I Nanded. My. India -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from

Re: Fedora 30 server (Configuring Postgresql with Django)

2019-10-30 Thread hari49pf
i am using *postgresql*, not *oracle*. please help me out On Wednesday, October 30, 2019 at 4:39:18 PM UTC+5:30, Siratim Mustaquim wrote: > > Can You please check your DB configuration @hari49pf. As @carlos mentioned > there might be an error there. > > [imag

Re: Fedora 30 server (Configuring Postgresql with Django)

2019-10-30 Thread Siratim Mustaquim
>> & DB permissions please help me >>>>> >>>>> >>>>> [image: Screenshot from 2019-10-29 10-40-47.png] >>>>> >>>>> >>>>> [image: Screenshot from 2019-10-29 10-40-40.png] >>>>> >>>>&g

Re: Fedora 30 server (Configuring Postgresql with Django)

2019-10-29 Thread Kevin Jay
B permissions please help me >>>> >>>> >>>> [image: Screenshot from 2019-10-29 10-40-47.png] >>>> >>>> >>>> [image: Screenshot from 2019-10-29 10-40-40.png] >>>> >>>> >>>> On Monday, October

Re: Fedora 30 server (Configuring Postgresql with Django)

2019-10-29 Thread Kevin Jay
10-40-40.png] >>> >>> >>> On Monday, October 28, 2019 at 7:57:47 PM UTC+5:30, sacrac wrote: >>>> >>>> You can show the settings and permissions of the DB, because the user >>>> harish.b and harishb are different! >>>>

Re: Fedora 30 server (Configuring Postgresql with Django)

2019-10-29 Thread hari49pf
er >>> harish.b and harishb are different! >>> >>> On Mon, Oct 28, 2019 at 5:00 AM Motaz Hejaze wrote: >>> >>>> did you install all required packages for postgresql ? >>>> >>>> >>>> On Mon, Oct 28, 2019 at 12:55 PM Ha

Re: Fedora 30 server (Configuring Postgresql with Django)

2019-10-28 Thread Harish Bheemanpally
Yes, I have installed all the packages required for postgresql, I configured the Djanog in windows with Postgresql, it running perfectly. but in Fedroa 30 server i am facing the problem, On Monday, October 28, 2019 at 4:30:59 PM UTC+5:30, Motaz Hejaze wrote: > > did you install all re

Re: Fedora 30 server (Configuring Postgresql with Django)

2019-10-28 Thread Harish Bheemanpally
On Monday, October 28, 2019 at 4:30:59 PM UTC+5:30, Motaz Hejaze wrote: > > did you install all required packages for postgresql ? > > > On Mon, Oct 28, 2019 at 12:55 PM Harish Bheemanpally > wrote: > >> Yes it was running perfectly in sqllie & Mysql. Bu

Re: Fedora 30 server (Configuring Postgresql with Django)

2019-10-28 Thread carlos
You can show the settings and permissions of the DB, because the user harish.b and harishb are different! On Mon, Oct 28, 2019 at 5:00 AM Motaz Hejaze wrote: > did you install all required packages for postgresql ? > > > On Mon, Oct 28, 2019 at 12:55 PM Harish Bheemanpally >

Re: Fedora 30 server (Configuring Postgresql with Django)

2019-10-28 Thread Motaz Hejaze
did you install all required packages for postgresql ? On Mon, Oct 28, 2019 at 12:55 PM Harish Bheemanpally wrote: > Yes it was running perfectly in sqllie & Mysql. But in postgresql i am > unable to configure Djanog > the postger server screen shot > > please let me know

Re: Fedora 30 server (Configuring Postgresql with Django)

2019-10-28 Thread Motaz Hejaze
Does it run on sqlite ?? You need to show the code On Mon, 28 Oct 2019, 8:10 am Harish Bheemanpally, wrote: > There is not user with harish in *DB*(postgresql) > the harish is the user of *OS*. > > As suggested by sacrac: > > I have created a new user in DB with th

Re: Fedora 30 server (Configuring Postgresql with Django)

2019-10-28 Thread Harish Bheemanpally
There is not user with harish in *DB*(postgresql) the harish is the user of *OS*. As suggested by sacrac: I have created a new user in DB with the name harishb who is the owner of the DB and changed the setting.py still raising same error when i am trying to run migrate or run the django PLZ

Re: How can i share one Database Sqlite between 2 app on pythonanywhere -. Should I prefer postgresql or MySQL - Security

2019-09-05 Thread Amirhosein Rajabi
I enumerate your questions and answer them in order. For the first one, yes, you can have DB using Postgres, but for configurations you have to refer to databases tab in your PythonAnyWhere account. Also you can use PythonAnyWhere help for setting up databases. (Note1: For Postgresql, you need

Re: How can i share one Database Sqlite between 2 app on pythonanywhere -. Should I prefer postgresql or MySQL - Security

2019-09-05 Thread Balaji Shetty
Thanks for your reply. I hosted on pythonAnywhere. Is it possible for postgresql. Should I prefer postgresql or MySQL regarding security issues . Can you please tell me how to achieve in MySQL. Also how can I backup daily data of server on my local machine . Can any DB also provide front-end

How to save an array of text in PostgreSQL using Django model.?

2019-08-19 Thread Shafay Haseeb
I have asked this question on StackOverflow here, https://stackoverflow.com/questions/57547588/how-to-save-an-array-of-text-in-postgresql-using-django-model but havent received any input. My question is simple, how to store a list in django postgresql model. You could refer to my link above

Re: --fake-initial does not follow PostgreSQL search_path schema list

2019-06-11 Thread Axel Rau
This worked with Django 2.1. Seems to be a bug in 2.2 Axel > Am 08.06.2019 um 21:50 schrieb Axel Rau : > > The database user sets a search_path to a,b > In schema b exists a set of tables corresponding to models and > inital_migration. > Running > migrate --fake-initial app

--fake-initial does not follow PostgreSQL search_path schema list

2019-06-08 Thread Axel Rau
The database user sets a search_path to a,b In schema b exists a set of tables corresponding to models and inital_migration. Running migrate --fake-initial app inital_migration recreates all table in schema a. Documentation says "--fake-initial does nothing if tables already exist. Is

Re: How to migrate MySQL -> PostgreSQL?

2019-06-06 Thread Devender Kumar
uction database MySQL -> PostgreSQL? > > (MySQL has several bugs, I want to try something other on my production > server.) > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receivin

Re: How to migrate MySQL -> PostgreSQL?

2019-06-05 Thread phep
o dump Into another database (PostgreSQL) in between you can use transition state of JSON OR XML Thank you On Tue, Jun 4, 2019 at 2:46 PM Julien Enselme mailto:julien.ense...@bureauxlocaux.com>> wrote: Hi, At my company we recently made a switch from MySQL to PG. We us

Re: How to migrate MySQL -> PostgreSQL?

2019-06-05 Thread Devender Kumar
If its production end then you might have to write some scripts to copy data from one database (MySQL) to dump Into another database (PostgreSQL) in between you can use transition state of JSON OR XML Thank you On Tue, Jun 4, 2019 at 2:46 PM Julien Enselme < julien.ense...@bureauxlocaux.c

Re: How to migrate MySQL -> PostgreSQL?

2019-06-04 Thread Julien Enselme
gs before that use the django > fixtures feature to take a backup of the data etc. try in test env only as > this has breaking potential. > > Regards, > Kiran Capoor > > On Tue, 4 Jun 2019 at 01:33, Ankhi Roy wrote: > >> Hey Victor, >> >> Do you mean to us

Re: Django model form is not getting saved in Postgresql database

2019-06-03 Thread Taylor Hughes-Scott
creates a database table like databasename_modelclassname and have all the > columns as per Django model form. > > Anyway thanks for your time. > > Thanks > > > > On Mon, Jun 3, 2019, 4:38 PM Ankhi Roy wrote: > >> Hi, >> >> I am using Django admin

Re: Django model form is not getting saved in Postgresql database

2019-06-03 Thread Taylor Hughes-Scott
With your form.save() call try passing commit=True so it looks like form.save(commit=True) On Tue., 4 Jun. 2019, 1:39 am Ankhi Roy, wrote: > Hi, > > I am using Django admin - 2.2.1 and Postgresql as my database. So my > problem is I have saved the user entered data in form.py on &q

Re: How to migrate MySQL -> PostgreSQL?

2019-06-03 Thread Kiran Capoor
an to use postgresql instead of mysql, if so please change > database settings in settings.py. However, I am not sure how will you > migrate your existing mysql tables and contents to postgresql. Just a > workaround you can recreate tables in postgresql and re add the data. There > must be an

Re: Django model form is not getting saved in Postgresql database

2019-06-03 Thread Ankhi Roy
thanks for your time. Thanks On Mon, Jun 3, 2019, 4:38 PM Ankhi Roy wrote: > Hi, > > I am using Django admin - 2.2.1 and Postgresql as my database. So my > problem is I have saved the user entered data in form.py on "POST" Request > but it isn't saving in the postgres

Re: How to migrate MySQL -> PostgreSQL?

2019-06-03 Thread Ankhi Roy
Hey Victor, Do you mean to use postgresql instead of mysql, if so please change database settings in settings.py. However, I am not sure how will you migrate your existing mysql tables and contents to postgresql. Just a workaround you can recreate tables in postgresql and re add the data

How to migrate MySQL -> PostgreSQL?

2019-06-03 Thread Victor Porton
How to migrate a production database MySQL -> PostgreSQL? (MySQL has several bugs, I want to try something other on my production server.) -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and s

Django model form is not getting saved in Postgresql database

2019-06-03 Thread Ankhi Roy
Hi, I am using Django admin - 2.2.1 and Postgresql as my database. So my problem is I have saved the user entered data in form.py on "POST" Request but it isn't saving in the postgresql database. Model.py - class modelForm(models.Model): CHOICES = [('Y', 'Yes'),

Re: Django + PostgreSQL Installation (pipenv install psycopg2)

2019-04-11 Thread Junaid Burke
Thanks Sandip and Danny, below commend worked for me. pipenv install psycopg2-binary Thanks > On Apr 11, 2019, at 2:08 AM, Sandip Nath wrote: > > Try the command: > pipenv install psycopg2-binary > > -- > You received this message because you are subscribed to the Google Groups > "Django

Django + PostgreSQL Installation (pipenv install psycopg2)

2019-04-11 Thread Sandip Nath
Try the command: pipenv install psycopg2-binary -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this

Re: Django saleor postgresql hstore issue

2019-04-10 Thread Asif Saif Uddin
Fixed using this https://stackoverflow.com/questions/10757431/postgres-upgrade-a-user-to-be-a-superuser On Thursday, April 11, 2019 at 10:05:58 AM UTC+6, Asif Saif Uddin wrote: > > facing this error even after creating hstore extension from pg shell and > generated empty migrations for hstore:

Django + PostgreSQL Installation (pipenv install psycopg2)

2019-04-10 Thread Danny Blaker
https://github.com/psycopg/psycopg2/issues/699 Try updating pip too :) -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to

Django + PostgreSQL Installation (pipenv install psycopg2)

2019-04-10 Thread Danny Blaker
https://www.google.com/url?sa=t=web=j=https://stackoverflow.com/questions/11618898/pg-config-executable-not-found=2ahUKEwitxePlncfhAhVDwIsBHeQbBTEQjjgwAHoECAkQAg=AOvVaw1ujp9GSEZRKKrkOSHWdMiD -- You received this message because you are subscribed to the Google Groups "Django users" group. To

Django saleor postgresql hstore issue

2019-04-10 Thread Asif Saif Uddin
facing this error even after creating hstore extension from pg shell and generated empty migrations for hstore: line 89, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "/usr/local/lib/python3.6/dist-packages/django/db/backends/utils.py", line 84, in

Re: How To Use PostgreSQL with your Django on Ubuntu

2019-03-20 Thread VeeraNagaRaja Sankar
'USER': 'merudan', >>> # 'PASSWORD': 'merudan', >>> # 'HOST': 'localhost', >>> # 'PORT': '5432', >>> # } >>> # } >>> Best Regards, >>> Inti VeeraNagaRaja Sankar,M.Tech(IT) >>> M: 9985864383 >>> intis...@gmai

Re: How To Use PostgreSQL with your Django on Ubuntu

2019-03-20 Thread Nasim TKP
WORD': 'merudan', >> # 'HOST': 'localhost', >> # 'PORT': '5432', >> # } >> # } >> Best Regards, >> Inti VeeraNagaRaja Sankar,M.Tech(IT) >> M: 9985864383 >> intis...@gmail.com >> >> >> On Tue, Mar 19, 2019 at 6:28 PM omar ahmed wr

Re: How To Use PostgreSQL with your Django on Ubuntu

2019-03-20 Thread omar ahmed
9985864383 > intis...@gmail.com > > > On Tue, Mar 19, 2019 at 6:28 PM omar ahmed > wrote: > >> ok what about old projects >> only install postgresql and change db settings >> >> On Tuesday, March 19, 2019 at 2:42:02 PM UTC+2, Jani Tiainen wrote:

Re: How To Use PostgreSQL with your Django on Ubuntu

2019-03-19 Thread VeeraNagaRaja Sankar
', # 'PORT': '5432', # } # } Best Regards, Inti VeeraNagaRaja Sankar,M.Tech(IT) M: 9985864383 intisank...@gmail.com On Tue, Mar 19, 2019 at 6:28 PM omar ahmed wrote: > ok what about old projects > only install postgresql and change db settings > > On Tuesday, March 19, 201

  1   2   3   4   5   6   7   8   9   10   >